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
Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.