Match the LIST-I with LIST-II
| LIST-I | LIST-II |
|---|---|
| A. Wait-for graph | I. Holds all locks until it commits |
| B. Precedence graph | II. Holds write-locks until it commits |
| C. Rigorous 2PL | III. Use to check deadlocks |
| D. Strict 2PL | IV. Used to check serializability |
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
- Consider the following three relations: Employee(eid, eName), Comp(cid, cName), Own(eid, cid). Which of the following relational algebra ex…
- Consider R(A, B, C, D, E) be a relation with the following dependencies: C → F, E → A, EC → D, A → B. Which of the following is a key for R?
- Consider the following statements: A. Data transformation is involved in the Data mining process. B. Online database is used in Data wareho…
- Consider the relation T1(A, B, C, D, E) with the dependencies {EB → C, D → E, EA → B} and T2(A, B, C, D) with the dependencies {C → A, A →…
- In a relational database, which one of the following is CORRECT?
- Consider the following statements: A. A non-serial schedule is said to be conflict serializable if it is conflict-equivalent to some serial…