Consider the following database schedule with two transactions, \(T_1\) and…

GATE · 2016 · CS · Set 2 · Computer Science & IT

Consider the following database schedule with two transactions, T1T_1 and T2T_2.

S=r2(X);r1(X);r2(Y);w1(X);r1(Y);w2(X);a1;a2S= r_{2}\left(X\right); r_{1}\left(X\right); r_{2} \left(Y\right); w_{1} \left(X\right); r_{1} \left(Y\right); w_{2} \left(X\right); a_{1}; a_{2}

where ri(Z)r_i(Z) denotes a read operation by transaction TiT_i on a variable ZZ, wi(Z)w_i(Z) denotes a write operation by TiT_i on a variable ZZ and ai denotes an abort by transaction TiT_i .

Which one of the following statements about the above schedule is TRUE?

  1. A.

    SS is non-recoverable

  2. B.

    SS is recoverable, but has a cascading abort

  3. C.

    SS does not have a cascading abort

  4. D.

    SS is strict

Attempted by 231 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…