Database-Management-System
August 29, 2024
Keys
August 29, 2024
Database-Management-System
August 29, 2024
Keys
August 29, 2024

Transactions

Question 44
Which of the following concurrency protocol ensures both conflict serializability and freedom from deadlock?
(a) Z-Phase Locking
(b) Timestamp ordering
A
Both (a) and (b)
B
(a) only
C
(b) only
D
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.
0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x
error: Alert: Content selection is disabled!!