Which of the following is correct? I. Two phase locking is an optimistic protocol
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
Show answerHide answer
Correct answer: (D) II and III
Explanation
Two phase locking is a pessimistic protocol (it assumes conflicts will happen) because it applies locks. Time stamping is an optimistic protocol because it uses no locking and handles conflicts later. So II and III are correct.