Question 11225 – Algorithms
May 13, 2024Question 9286 – Database-Management-System
May 13, 2024Question 9034 – Database-Management-System
Which of the following concurrency control protocols ensure both conflict serializability and freedom from deadlock?
I. 2-phase locking II. TIme-stamp ordering
Correct Answer: B
Question 70 Explanation:
― Two-phase locking protocol (2PLP) ensures the conflict serializable schedule but it may not free from deadlock.
― Timestamp ordering protocol ensures conflict serializability and free from deadlock.
― Timestamp ordering protocol ensures conflict serializability and free from deadlock.
I only
II only
Both I and II
Neither I nor II
Subscribe
Login
0 Comments