Which of the following concurrency protocol ensures both conflict serializability and freedom from deadlock :
Which of the following concurrency protocol ensures both conflict serializability and freedom from deadlock :
I. 2-phase locking
II. Time phase ordering
Show answerHide answer
Correct answer: (B) II only
Explanation
2-phase locking is a concurrency control method that guarantees serializability, but because transactions may block one another while holding locks, 2PL can lead to deadlocks. Timestamp-based (time phase) ordering is a non-lock concurrency method: it ensures conflict serializability and no deadlock can occur since no transaction ever waits. So the answer is (b) II only.