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.

31.
High
Which recovery technique uses shadow paging?
32.
Medium
Which join requires both inputs to be sorted?
33.
High
Which isolation level prevents phantom reads?
34.
Medium
Which SQL constraint enforces domain integrity?
35.
High
Which dependency is required for lossless decomposition?
36.
Medium
Which problem occurs in Read Committed isolation?
37.
Medium
Which file organization is best for sequential access?
38.
Medium
Which SQL feature improves performance of repeated queries?
39.
High
Which concurrency issue does strict 2PL avoid?
40.
Easy
Which SQL statement permanently removes a table?
41.
Medium
Which index supports equality search efficiently?
42.
Medium
Which transaction property ensures all-or-nothing execution?
43.
High
Which join avoids sorting but requires memory?
44.
Medium
Which SQL keyword removes duplicate rows?
45.
Medium
Which database component manages metadata?
Answered: 0 / 15