+ Submit

DBMS Objective Questions and Answers

Practice DBMS objective questions with answers and detailed explanations. Covers normalization, transactions, indexing, SQL, concurrency control, recovery, and query optimization.

This DBMS quiz contains carefully curated objective questions with correct answers and clear explanations. It is designed for computer science students, backend developers, and interview preparation, focusing on database design, SQL internals, transactions, indexing, and performance tuning.

Practice DBMS MCQs with Detailed Explanations

Answer at least 12 questions to submit.

16

Which SQL command is DDL?

Easy
17

Which join returns unmatched rows from the left table?

Medium
18

Which problem is addressed by multiversion concurrency control?

High
19

What is the main disadvantage of bitmap indexes?

Medium
20

Which SQL clause filters grouped data?

Medium
21

Which failure requires redo during recovery?

High
22

Which key uniquely identifies a tuple?

Medium
23

Which join produces maximum number of rows?

Medium
24

Which schedule avoids cascading rollback?

High
25

Which index is automatically created with primary key?

Medium
26

Which SQL function returns NULL if input is NULL?

Medium
27

Which normal form removes multivalued dependency?

High
28

Which problem occurs when two transactions update same data simultaneously?

Medium
29

Which clause is mandatory with GROUP BY?

Medium
30

Which optimizer uses statistics to choose execution plans?

High

Other Objective Questions