UGC-NET | UGC NET CS 2014 Dec – III | Question 8
Which of the following is correct ?
I.Two phase locking is an optimistic protocol.
II. Two phase locking is pessimistic protocol
III. Time stamping is an optimistic protocol.
IV. Time stamping is pessimistic protocol.
(A) I and III
(B) II and IV
(C) I and IV
(D) II and III
Explanation: Two phase locking is pessimistic protocol and Time stamping is an optimistic protocol.
For more information On two phase locking protocol and time stamp protocol Refer:DBMS | Concurrency Control Protocol | Two Phase Locking (2-PL)-III and DBMS | Concurrency Control Protocols | Timestamp Ordering Protocols
Option (D) is correct.
Quiz of this Question