Database-Management-System
August 29, 2024Keys
August 29, 2024Transactions
Question 44
|
Which of the following concurrency protocol ensures both conflict serializability and freedom from deadlock?
(a) Z-Phase Locking
(b) Timestamp ordering
(a) Z-Phase Locking
(b) Timestamp ordering
Both (a) and (b)
|
|
(a) only
|
|
(b) only
|
|
Neither (a) nor (b)
|
Question 44 Explanation:
Timestamp ordering provides a schedule which is conflict serializable and free from deadlock but Z-phase locking provides a schedule which is conflict serializable only.
Correct Answer: C
Question 44 Explanation:
Timestamp ordering provides a schedule which is conflict serializable and free from deadlock but Z-phase locking provides a schedule which is conflict serializable only.
Subscribe
Login
0 Comments