Database Management System DBMS MCQs with Answers 2026

1. DBMS stands for:

a) Data Base Management Server    b) Database Management System ✅    c) Data Backup Main System    d) Digital Base Memory System

2. Which of the following is a DBMS software?

a) MS Word    b) Chrome    c) MySQL ✅    d) Photoshop

3. A collection of related data organized for easy access is called:

a) File    b) Folder    c) Database ✅    d) Spreadsheet

4. Which language is used to interact with databases?

a) HTML    b) Python    c) Java    d) SQL ✅

5. SQL stands for:

a) Simple Query Language    b) Structured Query Language ✅    c) Standard Question Language    d) System Query Logic

6. Which SQL command is used to retrieve data?

a) INSERT    b) UPDATE    c) DELETE    d) SELECT ✅

7. Which SQL command adds new records?

a) SELECT    b) UPDATE    c) INSERT INTO ✅    d) DROP

8. The command to delete an entire table is:

a) DELETE    b) REMOVE    c) DROP TABLE ✅    d) TRUNCATE

9. A primary key is:

a) Any column    b) A unique identifier for each row in a table ✅    c) A password    d) A type of index

10. A foreign key is used to:

a) Encrypt data    b) Delete records    c) Link two tables together ✅    d) Sort data

11. Which key can have duplicate values?

a) Primary key    b) Foreign key ✅    c) Candidate key    d) Super key

12. Normalization is used to:

a) Speed up queries    b) Remove data redundancy and anomalies ✅    c) Add more tables    d) Encrypt database

13. ER stands for:

a) Electronic Record    b) Error Recovery    c) Entity Relationship ✅    d) Extended Register

14. In an ER diagram, a rectangle represents:

a) Attribute    b) Relationship    c) Entity ✅    d) Key