+ Add

DBMS Objective Questions and Answers

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.
Easy
Which SQL command is DDL?
17.
Medium
Which join returns unmatched rows from the left table?
18.
High
Which problem is addressed by multiversion concurrency control?
19.
Medium
What is the main disadvantage of bitmap indexes?
20.
Medium
Which SQL clause filters grouped data?
21.
High
Which failure requires redo during recovery?
22.
Medium
Which key uniquely identifies a tuple?
23.
Medium
Which join produces maximum number of rows?
24.
High
Which schedule avoids cascading rollback?
25.
Medium
Which index is automatically created with primary key?
26.
Medium
Which SQL function returns NULL if input is NULL?
27.
High
Which normal form removes multivalued dependency?
28.
Medium
Which problem occurs when two transactions update same data simultaneously?
29.
Medium
Which clause is mandatory with GROUP BY?
30.
High
Which optimizer uses statistics to choose execution plans?
Answered: 0 / 15

Other Objective Questions