All mock tests are FREE till 31 December — register to save your progress
Unit 4 · Database Management Systems Paper 2 CS · 22 June 2026

Match the LIST-I with LIST-II
LIST-ILIST-II
A. Wait-for graphI. Holds all locks until it commits
B. Precedence graphII. Holds write-locks until it commits
C. Rigorous 2PLIII. Use to check deadlocks
D. Strict 2PLIV. Used to check serializability
Choose the correct answer from the options given below:

Pick an option to check yourself, or open the answer below.

Show answer & explanation

Correct answer: A. A-III, B-IV, C-I, D-II

Explanation

A wait-for graph is a runtime structure that tracks which transaction is waiting for locks held by another, and is used to detect deadlocks (A-III). A precedence (serialization) graph records the order of conflicting operations between transactions and is used to check whether a schedule is conflict-serializable (B-IV). Rigorous 2PL holds all locks, both shared and exclusive, until the transaction commits (C-I), whereas Strict 2PL only holds write (exclusive) locks until commit while read locks may be released earlier (D-II). This gives A-III, B-IV, C-I, D-II.

More Database Management Systems questions