Question

T1: R(X), T2:W(X), T1:W(X), T3: W(X), T1: commit, T2: commit, T3: commit. Identify the characteristics of above Schedule.

• A. Not Recoverable, cascading rollbacks, Conflict and view serializable
• B. Recoverable, cascade less, not conflict but view serializable
• C. Recoverable, cascading rollbacks, view but not conflict serializable
• D. Recoverable, cascade less, Conflict and view serializable

Answer 1

The correct option is B Recoverable, cascade less, not conflict but view serializable

As there is no dirty read the given schedule is recoverable and cascadeless.
In precedence of the schedule, a cycle is found from $T1\to T2\to T1$ and the schedule is not conflict serializable but view serializable.