The GATE Grind

GATE 2014 CS (CS2) – Question 39

Databases · Transactions and Concurrency Control · 2 marks · Multiple choice

For the shown schedule S of T1, T2, T3 and T4, which statement is correct?

Diagram for GATE 2014 CS (CS2) question 39
  1. Conflict serializable but not recoverable
  2. Not conflict serializable but recoverable
  3. Both conflict serializable and recoverable
  4. Neither conflict serializable nor recoverable

Practise this question in The GATE Grind →

Show answer and explanation

Correct answer: (C) Both conflict serializable and recoverable

Explanation

Conflicts yield T2→T3,T2→T1,T3→T1 and edges from these writers/readers toward T4; no edge returns to create a cycle. T4 reads only after the relevant T1 and T2 commits; other reads do not consume uncommitted writes. Thus **both conflict-serializable and recoverable,C**.