Consider the following schedule: S: r1(y), r2 (z), w1(y), w1 (z), r2(x),…

Consider the following schedule: 

S: r1(y), r2 (z), w1(y), w1 (z), r2(x), w2(x), r2(y), w2(y), r1(x), c1, c2 

Which of the following is true about S? 

  1. A.

    (a) S is cascade-less.

  2. B.

    S is not cascade-less, but recoverable. 

  3. C.

    S is not recoverable, but changing the order of commits to c2; c1 makes the schedule recoverable. 

  4. D.

    S is not recoverable, and changing the order of commits to c2; c1 does not make the schedule recoverable. 

Attempted by 136 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…