Database Basics – DBMS, Tables, Keys, SQL & Database Concepts MCQs

DBMS stands for Database Management System, software used to create, maintain, secure, and access databases.

A database is an organized collection of related data that can be stored, searched, updated, and managed efficiently.

A: Wrong because slides and animations belong to presentations. B: Correct because tables store records in rows and fields in columns. C: Wrong because pixels and colors relate to images/displays. D: Wrong because speakers and microphones are audio devices.

A: Wrong because encryption is a separate security process. B: Correct because a primary key uniquely identifies a row in a table. C: Wrong because primary keys do not delete tables. D: Wrong because display brightness is unrelated to databases.

A: Correct because SELECT fetches records from one or more database tables. B: Wrong because DELETE removes existing records. C: Wrong because DROP removes database objects such as tables. D: Wrong because ALTER changes table structure.

Correct Answer: A. Uniquely identify a record Fact Check: A primary key uniquely identifies each record in a database table. A. Correct — Uniquely identify a record is right because A primary key uniquely identifies each record in a database table. B. Delete all data is not correct because it does not match the verified fact: A primary key uniquely identifies each record in a database table. C. Print page is not correct because it does not match the verified fact: A primary key uniquely identifies each record in a database table. D. Open browser is not correct because it does not match the verified fact: A primary key uniquely identifies each record in a database table.

Correct Answer: A. Table Fact Check: A table stores related records in rows and columns. A. Correct — Table is right because A table stores related records in rows and columns. B. Keyboard is not correct because it does not match the verified fact: A table stores related records in rows and columns. C. Monitor is not correct because it does not match the verified fact: A table stores related records in rows and columns. D. Slide is not correct because it does not match the verified fact: A table stores related records in rows and columns.

Correct Answer: A. Field Fact Check: A field is a column in a database table, such as Name, Age, or Email. A. Correct — Field is right because A field is a column in a database table, such as Name, Age, or Email. B. Record is not correct because it does not match the verified fact: A field is a column in a database table, such as Name, Age, or Email. C. File is not correct because it does not match the verified fact: A field is a column in a database table, such as Name, Age, or Email. D. Folder is not correct because it does not match the verified fact: A field is a column in a database table, such as Name, Age, or Email.

Correct Answer: B. Record Fact Check: A record is a complete row of related information in a table. A. Field is not correct because it does not match the verified fact: A record is a complete row of related information in a table. B. Correct — Record is right because A record is a complete row of related information in a table. C. Table is not correct because it does not match the verified fact: A record is a complete row of related information in a table. D. Query is not correct because it does not match the verified fact: A record is a complete row of related information in a table.

Correct Answer: A. Database Management System Fact Check: DBMS means Database Management System, used to store, manage, and retrieve data. A. Correct — Database Management System is right because DBMS means Database Management System, used to store, manage, and retrieve data. B. Data Basic Machine Software is not correct because it is not the accepted expansion; the correct form is Database Management System. C. Digital Backup Memory System is not correct because it is not the accepted expansion; the correct form is Database Management System. D. Database Main Server is not correct because it is not the accepted expansion; the correct form is Database Management System.