Open In App

UGC-NET | UGC NET CS 2014 Dec – III | Question 8

Like Article
Like
Save
Share
Report

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


Answer: (D)

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


Last Updated : 28 Jun, 2018
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads