Consider the following partial Schedule \(S\) involving two transactions…

PYQ GATE 2015

Consider the following partial Schedule SS involving two transactions T1T1 and T2T2. Only the readread and the writewrite operations have been shown. The readread operation on data item PP is denoted by read(P)read(P) and the write operation on data item PP is denoted by write(P)(P).

Suppose that the transaction T1T1 fails immediately after time instance 9. Which one of the following statements is correct?

  1. A.

    T2T2 must be aborted and then both T1T1 and T2T2 must be re-started to ensure transaction atomicity

  2. B.

    Schedule SS is non-recoverable and cannot ensure transaction atomicity

  3. C.

    Only T2T2 must be aborted and then re-started to ensure transaction atomicity

  4. D.

    Schedule SS is recoverable and can ensure atomicity and nothing else needs to be done

Attempted by 439 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…