Skip to content
Related Articles

Related Articles

Improve Article

UGC-NET | UGC NET CS 2015 Jun – II | Question 17

  • Last Updated : 14 May, 2018

Which of the following concurrency protocol ensures both conflict serializability and freedom from deadlock?
(a)z – phase Locking
(b)Time stamp – ordering

(A) Both (a) and (b)
(B) (a) only
(C) (b) only
(D) Neither (a) nor (b)


Answer: (C)

Explanation: (a) z – phase Locking is a concurrency control method that guarantees serializability. The protocol utilizes locks, applied by a transaction to data, which may block (interpreted as signals to stop) other transactions from accessing the same data.
during the transaction’s life. 2PL may be lead to deadlocks that result from the mutual blocking of two or more transactions.
(b)Time stamp – ordering concurrency protocol ensures both conflict serializability and freedom from deadlock.
Only (b) is correct.
So, option (C) is correct option.


Quiz of this Question

My Personal Notes arrow_drop_up
Recommended Articles
Page :