Question 11225 – Algorithms
May 13, 2024Question 9286 – Database-Management-System
May 13, 2024GATE 2010
|
Question 20
|
Which of the following concurrency control protocols ensure both conflict serializability and freedom from deadlock?
I. 2-phase locking II. TIme-stamp ordering
|
I only
|
|
|
II only
|
|
|
Both I and II
|
|
|
Neither I nor II
|
Question 20 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.
Correct Answer: B
Question 20 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.
Subscribe
Login
0 Comments