Q. 39 Consider the following partial Schedule S involving two transactions T1 and T2.
Only the read and write operations have been shown. The read operation on data
item P is denoted by read (P) and the write operation on data item P is denoted
by write (P).
Suppose that the transaction T1 fails immediately after time instance 9. Which
one of the following statements is correct?
(A) T2 must be aborted and then both T1 and T2 must be re-started to ensure
transaction atomicity
(B) Schedule S is non-recoverable and cannot ensure transaction atomicity
(C) Only T2 must be aborted and then re-started to ensure transaction atomicity
(D) Schedule S is recoverable and can ensure atomicity and nothing else needs to
be done
Answer: (B)
Explanation:
