Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

GATE | Sudo GATE 2020 Mock I (27 December 2019) | Question 18

  • Last Updated : 23 Dec, 2019

Consider the following two statements about database transaction schedules:

I. Timestamp protocol ensures freedom from deadlock as no transaction ever waits, but the schedule may not be cascade free, and may not even be recoverable.
II. Timestamp-ordering concurrency control protocol with Thomas’ Write Rule can generate view serializable schedules that are not conflict serializable.
III. Binary Locking does not guarantee Serializability.

Attention reader! Don’t stop learning now.  Practice GATE exam well before the actual exam with the subject-wise and overall quizzes available in GATE Test Series Course.

Learn all GATE CS concepts with Free Live Classes on our youtube channel.

Which of the above statements is/are TRUE?
(A) Only I and II
(B) Only I and III
(C) Only II and III
(D) All I, II and III


Answer: (D)

Explanation: Timestamp protocol ensures freedom from deadlock as no transaction ever waits, but the schedule may not be cascade free, and may not even be recoverable.
So, statement (I) is correct.



Timestamp-ordering concurrency control protocol with Thomas’ Write Rule can generate view serializable schedules that are not conflict serializable.
Statement (II) is correct.

Binary Locking does not guarantee Serializability.
Statement (III) is also correct.

Option (D) is true.

Quiz of this Question

My Personal Notes arrow_drop_up
Recommended Articles
Page :