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.