Home » Database » Database miscellaneous » Question

Database miscellaneous

  1. 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 ?
    1. S is non-recoverable
    2. S is recoverable, but has a cascading abort
    3. S does not have a cascading abort
    4. S is strict
Correct Option: C

There is no transaction which reads the data item written by any other transaction. Therefore the given schedule is cascadeless.



Your comments will be displayed only after manual approval.