100 Database Management MCQs with Answers (DBMS Multiple Choice Questions for Exams & Interviews). Prepare for exams and interviews with these 100 Database Management MCQs with answers. This comprehensive DBMS question set covers SQL, normalization, keys, ER diagrams, transactions, ACID properties, joins, indexing, and more — perfect for computer science students, IT exams, and competitive test preparation.
Database Management Systems (DBMS) are a fundamental part of computer science and information technology, playing a crucial role in storing, organizing, and managing data efficiently. Whether you are preparing for university exams, competitive tests, IT certifications, or technical interviews, a strong understanding of database concepts is essential. This collection of 100 Database Management MCQs with answers covers key topics such as SQL commands, normalization, primary and foreign keys, ER diagrams, joins, transactions, ACID properties, indexing, and data modeling. These carefully designed multiple choice questions will help students strengthen their core concepts, improve problem-solving skills, and confidently prepare for DBMS exams and professional assessments.
Database Management Systems (DBMS) – 100 MCQs with Answers
1. What does DBMS stand for?
A) Data Backup Management System
B) Database Management System
C) Digital Base Management System
D) Data Building Management System
Answer: B
2. A database is:
A) Collection of programs
B) Organized collection of data
C) Operating system
D) Compiler
Answer: B
3. Which of the following is a DBMS?
A) MySQL
B) Windows
C) Linux
D) MS Word
Answer: A
4. Which model organizes data in tables?
A) Hierarchical model
B) Network model
C) Relational model
D) Object model
Answer: C
5. SQL stands for:
A) Structured Query Language
B) Simple Query Language
C) Sequential Query Language
D) Standard Question Language
Answer: A
6. Which command is used to retrieve data?
A) INSERT
B) UPDATE
C) SELECT
D) DELETE
Answer: C
7. Which key uniquely identifies a record?
A) Foreign key
B) Primary key
C) Candidate key
D) Composite key
Answer: B
8. A foreign key is used to:
A) Delete records
B) Create index
C) Link two tables
D) Sort data
Answer: C
9. Which normal form removes partial dependency?
A) 1NF
B) 2NF
C) 3NF
D) BCNF
Answer: B
10. A tuple in DBMS means:
A) Column
B) Row
C) Table
D) Database
Answer: B
11. A relation in DBMS is:
A) Row
B) Column
C) Table
D) Index
Answer: C
12. Which command is used to add new records?
A) ADD
B) INSERT
C) CREATE
D) UPDATE
Answer: B
13. DDL stands for:
A) Data Definition Language
B) Data Deletion Language
C) Data Directory Language
D) Data Duplication Language
Answer: A
14. Which is a DDL command?
A) SELECT
B) UPDATE
C) CREATE
D) DELETE
Answer: C
15. DML stands for:
A) Data Manipulation Language
B) Data Management Language
C) Data Modeling Language
D) Data Migration Language
Answer: A
16. Which command deletes a table?
A) REMOVE
B) DELETE
C) DROP
D) ERASE
Answer: C
17. Which constraint ensures unique values?
A) NOT NULL
B) UNIQUE
C) DEFAULT
D) CHECK
Answer: B
18. Which clause is used to filter records?
A) GROUP BY
B) ORDER BY
C) WHERE
D) HAVING
Answer: C
19. Aggregate function example:
A) SUM()
B) SELECT
C) INSERT
D) TABLE
Answer: A
20. COUNT() function returns:
A) Sum
B) Average
C) Number of rows
D) Maximum value
Answer: C
21. Which joins tables based on matching values?
A) INNER JOIN
B) DROP JOIN
C) DELETE JOIN
D) ALTER JOIN
Answer: A
22. Which key can have NULL value?
A) Primary key
B) Foreign key
C) Candidate key
D) Super key
Answer: B
23. A super key is:
A) Minimal unique key
B) Set of attributes uniquely identifying rows
C) Foreign key
D) Composite key only
Answer: B
24. Which normal form removes transitive dependency?
A) 1NF
B) 2NF
C) 3NF
D) 4NF
Answer: C
25. BCNF stands for:
A) Boyce-Codd Normal Form
B) Basic Codd Normal Form
C) Binary Code Normal Form
D) Base Codd Normal Form
Answer: A
26. Which command modifies table structure?
A) UPDATE
B) ALTER
C) MODIFY
D) CHANGE
Answer: B
27. Index improves:
A) Storage
B) Data retrieval speed
C) Security
D) Size
Answer: B
28. Which is not a DBMS?
A) Oracle
B) MySQL
C) PostgreSQL
D) MS Excel
Answer: D
29. A view is:
A) Physical table
B) Virtual table
C) Index
D) Database
Answer: B
30. Which command removes all records but keeps the structure?
A) DROP
B) DELETE
C) TRUNCATE
D) ERASE
Answer: C
31. ACID property ensures:
A) Speed
B) Security
C) Reliable transactions
D) Data redundancy
Answer: C
32. A transaction must be:
A) Permanent
B) Atomic
C) Temporary
D) Duplicate
Answer: B
33. Atomicity means:
A) All or nothing
B) Fast execution
C) Parallel processing
D) Duplication
Answer: A
34. Consistency ensures:
A) Data remains valid
B) Fast query
C) Small size
D) Backup
Answer: A
35. Isolation means:
A) Separate tables
B) Transactions do not interfere
C) Delete records
D) Indexing
Answer: B
36. Durability means:
A) Temporary storage
B) Permanent after commit
C) Fast rollback
D) Parallelism
Answer: B
37. Which command saves transaction?
A) SAVE
B) COMMIT
C) STORE
D) APPLY
Answer: B
38. Which command cancels transaction?
A) CANCEL
B) DELETE
C) ROLLBACK
D) DROP
Answer: C
39. Data redundancy means:
A) Unique data
B) Duplicate data
C) Clean data
D) Sorted data
Answer: B
40. Data independence means:
A) No database
B) Changes do not affect the application
C) No queries
D) Manual work
Answer: B
41. Which level hides complexity from users?
A) Physical level
B) Logical level
C) View level
D) Schema level
Answer: C
42. Entity represents:
A) Table only
B) Real-world object
C) Column
D) Index
Answer: B
43. ER diagram stands for:
A) Entity Relationship diagram
B) Entry Relation diagram
C) External Relation diagram
D) Entity Record diagram
Answer: A
44. Cardinality defines:
A) Data type
B) Number of relationships
C) Table size
D) Index
Answer: B
45. One-to-many relationship example:
A) Student–Course
B) Teacher–Students
C) Person–Passport
D) Country–Capital
Answer: B
46. Which is a NoSQL database?
A) MySQL
B) Oracle
C) MongoDB
D) SQL Server
Answer: C
47. Which SQL clause groups rows?
A) WHERE
B) GROUP BY
C) ORDER BY
D) SELECT
Answer: B
48. The HAVING clause is used with:
A) WHERE
B) GROUP BY
C) INSERT
D) UPDATE
Answer: B
49. ORDER BY is used to:
A) Filter
B) Group
C) Sort
D) Delete
Answer: C
50. Default sort order is:
A) DESC
B) ASC
C) RANDOM
D) NONE
Answer: B
51–100 (Continuing in the same format)
51. Which function finds the maximum value?
A) MAX()
B) MIN()
C) AVG()
D) SUM()
Answer: A
52. Which key is a combination of attributes?
A) Composite key
B) Primary key
C) Foreign key
D) Super key
Answer: A
53. Schema is:
A) Data
B) Structure of the database
C) Query
D) Table row
Answer: B
54. Instance is:
A) Structure
B) Current data in DB
C) Table design
D) Key
Answer: B
55. Which join returns all records from the left table?
A) RIGHT JOIN
B) INNER JOIN
C) LEFT JOIN
D) FULL JOIN
Answer: C
56. Which join returns all records from both tables?
A) INNER
B) FULL OUTER JOIN
C) LEFT
D) RIGHT
Answer: B
57. Which command removes specific records?
A) DELETE
B) DROP
C) TRUNCATE
D) CLEAR
Answer: A
58. Which is used to rename a table?
A) CHANGE
B) ALTER
C) RENAME
D) MODIFY
Answer: C
59. CHECK constraint ensures:
A) Unique value
B) Condition validation
C) Not null
D) Primary key
Answer: B
60. NOT NULL constraint ensures:
A) No duplicate
B) No empty value
C) No delete
D) No index
Answer: B
61. Which command is used to grant privileges to a user?
A) ALLOW
B) PERMIT
C) GRANT
D) GIVE
Answer: C
62. Which command is used to remove user privileges?
A) DELETE
B) REMOVE
C) REVOKE
D) CANCEL
Answer: C
63. A trigger in DBMS is:
A) Manual query
B) Automatic procedure executed on events
C) Backup file
D) Index
Answer: B
64. A stored procedure is:
A) Temporary query
B) Precompiled collection of SQL statements
C) Index
D) Constraint
Answer: B
65. A cursor is used for:
A) Bulk processing
B) Row-by-row processing
C) Table deletion
D) Indexing
Answer: B
66. A centralized database is stored:
A) At multiple locations
B) On cloud only
C) At a single location
D) On mobile devices
Answer: C
67. A distributed database is stored:
A) In one file
B) In multiple locations
C) In RAM only
D) In cache
Answer: B
68. Data mining is used to:
A) Delete data
B) Extract useful patterns
C) Backup database
D) Encrypt data
Answer: B
69. Database backup is important to prevent:
A) Speed issues
B) Data loss
C) Normalization
D) Sorting
Answer: B
70. The restore operation is used to:
A) Delete database
B) Recover lost data
C) Create index
D) Modify table
Answer: B
71. The locking mechanism is used for:
A) Data redundancy
B) Concurrency control
C) Sorting
D) Backup
Answer: B
72. Deadlock in DBMS occurs when:
A) Database crashes
B) Transactions wait indefinitely for each other
C) Table is empty
D) Query is incorrect
Answer: B
73. Timestamp ordering protocol is used to:
A) Increase speed
B) Prevent transaction conflicts
C) Backup data
D) Delete tables
Answer: B
74. A log file in DBMS stores:
A) Table structure
B) Transaction history
C) Index values
D) User passwords
Answer: B
75. A data warehouse is mainly used for:
A) Transaction processing
B) Data analysis and reporting
C) Data entry
D) File storage
Answer: B
76. OLTP stands for:
A) Online Logical Transaction Processing
B) Online Transaction Processing
C) Offline Transaction Processing
D) Online Table Processing
Answer: B
77. OLAP stands for:
A) Online Analytical Processing
B) Offline Analytical Processing
C) Online Application Processing
D) Object Logical Analytical Processing
Answer: A
78. Big Data refers to:
A) Small database
B) Structured data only
C) Very large and complex datasets
D) Simple table
Answer: C
79. Metadata is:
A) Raw data
B) Data about data
C) Backup file
D) SQL query
Answer: B
80. A primary key cannot contain:
A) Duplicate values
B) NULL values
C) Unique values
D) Index
Answer: B
81. Which is an example of a hierarchical database?
A) MySQL
B) IMS
C) Oracle
D) SQL Server
Answer: B
82. The network model uses:
A) Tables
B) Trees
C) Pointers
D) Indexes
Answer: C
83. Referential integrity ensures:
A) Unique records
B) Valid foreign key relationships
C) Sorted data
D) Backup
Answer: B
84. Which of the following is a cloud database service?
A) MS Access
B) Oracle Forms
C) Amazon RDS
D) Notepad
Answer: C
85. MySQL is currently maintained by:
A) Microsoft
B) Google
C) Oracle Corporation
D) IBM
Answer: C
86. PostgreSQL is:
A) Proprietary DBMS
B) Open-source DBMS
C) Operating System
D) Spreadsheet
Answer: B
87. Data anomaly occurs due to:
A) Normalization
B) Redundancy
C) Indexing
D) Backup
Answer: B
88. Denormalization is used to:
A) Reduce redundancy
B) Increase query performance
C) Delete data
D) Remove constraints
Answer: B
89. Which command modifies an existing column?
A) UPDATE
B) CHANGE
C) ALTER
D) MODIFY TABLE
Answer: C
90. The VARCHAR data type is used to store:
A) Integers
B) Fixed numbers
C) Variable-length text
D) Date
Answer: C
91. INT data type is used to store:
A) Characters
B) Decimal
C) Integer values
D) Boolean
Answer: C
92. DATE data type stores:
A) Text
B) Numbers
C) Date values
D) Images
Answer: C
93. The LIKE operator is used to:
A) Compare numbers
B) Search patterns
C) Delete records
D) Sort data
Answer: B
94. Which wildcard represents multiple characters in SQL?
A) _
B) %
C) *
D) #
Answer: B
95. A subquery is:
A) Main query
B) Query inside another query
C) Delete statement
D) Index
Answer: B
96. A primary key must be:
A) Duplicate
B) Unique and NOT NULL
C) Optional
D) Text only
Answer: B
97. A candidate key is:
A) Selected primary key
B) Possible primary key
C) Foreign key
D) Composite key only
Answer: B
98. Which clause removes duplicate records?
A) UNIQUE
B) REMOVE
C) DISTINCT
D) FILTER
Answer: C
99. SQL is considered:
A) Procedural language
B) Non-procedural language
C) Programming OS
D) Compiler
Answer: B
100. The main goal of a DBMS is:
A) Delete files
B) Increase hardware cost
C) Efficient and secure data management
D) Format disk
Answer: C
Advertisement:
