GATE CSE 2024 Session 2 Q27: True statements about two-phase locking
- Databases
- 1 mark
- MSQ
- No negative marking
Question
Which of the following statements about the Two Phase Locking (2PL) protocol is/are TRUE?
Try it: multiple select: one or more correct options
Select all correct options. No negative marking, no partial marks.
Show answer and explanation
Answer: A, C, D (official GATE 2024 final answer key)
Concept used: 2PL has a growing phase then a shrinking phase; it guarantees conflict serializability but not deadlock freedom.
First step: Check (B) against the rule that no lock may be acquired after any lock is released.
Full step-by-step solution
Detailed working, common mistakes and linked mock tests will be available with a free GATEiit account. Log-in is coming soon.
Share this question
Source: official GATE 2024 Session 2 CS question paper and final answer key, organised by IISc Bangalore. Question paper · Answer key
More Databases PYQs
- 2026 Session 1 · Q30Which functional dependency inferences always hold
- 2026 Session 1 · Q31Dependency-preserving decompositions for 1NF, 2NF, 3NF, BCNF
- 2026 Session 1 · Q43Relational algebra equivalent of a tuple calculus join query
- 2026 Session 1 · Q65Number of superkeys with candidate keys {A,B} and {A,C}
- 2026 Session 2 · Q15Match DBMS schema levels with what they describe
- 2026 Session 2 · Q20When two transactions do not conflict on a data item