-
Consider the following database schedule with two transactions, T1 and T2.
S = r2 (X); r1(X); r2 (Y); w1 (X); r1 (Y); w2 (X); a1; a2
where ri (Z) denotes a read operation by transaction Ti on a variable Z, wi (Z) denotes a write operation by Ti on a variable Z and ai denotes an abort by transaction Ti.
Which one of the following statements about the above schedule is TRUE ?
-
- S is non-recoverable
- S is recoverable, but has a cascading abort
- S does not have a cascading abort
- S is strict
- S is non-recoverable
Correct Option: C
There is no transaction which reads the data item written by any other transaction. Therefore the given schedule is cascadeless.