DBMS Objective Questions and Answers - Set 3

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. This is part 3 of the series.

Practice DBMS MCQs with Detailed Explanations

Answer at least 12 questions to submit and verify answers.

31 Which recovery technique uses shadow paging? High

32 Which join requires both inputs to be sorted? Medium

33 Which isolation level prevents phantom reads? High

34 Which SQL constraint enforces domain integrity? Medium

35 Which dependency is required for lossless decomposition? High

36 Which problem occurs in Read Committed isolation? Medium

37 Which file organization is best for sequential access? Medium

38 Which SQL feature improves performance of repeated queries? Medium

39 Which concurrency issue does strict 2PL avoid? High

40 Which SQL statement permanently removes a table? Easy

41 Which index supports equality search efficiently? Medium

42 Which transaction property ensures all-or-nothing execution? Medium

43 Which join avoids sorting but requires memory? High

44 Which SQL keyword removes duplicate rows? Medium

45 Which database component manages metadata? Medium