Which of the following concurrency control protocols ensure(s) both conflict…
2018
Which of the following concurrency control protocols ensure(s) both conflict serializability and freedom from deadlock? Statements: I. 2-phase locking (2PL) II. Timestamp ordering
- A.
I only
- B.
II only
- C.
Both I and II
- D.
Neither I nor II
Attempted by 373 students.
Show answer & explanation
Correct answer: B
2-Phase Locking (2PL) ✔ Ensures conflict serializability ❌ Can cause deadlock
Timestamp Ordering Protocol ✔ Ensures conflict serializability ✔ Deadlock-free (no waiting, only aborts)
👉 Therefore, only Timestamp Ordering satisfies both conditions.
A video solution is available for this question — log in and enroll to watch it.