GATE CSE 2015 SET 3

Planning to take coaching on Unacademy http://bit.ly/gate_unacademy or https://unacademy.com/ here is a code for 10% off PLUS1BPK1 Telegram Notification Group link:- https://t.me/joinchat/X5egW_cvdt9kMGY1 Telegram discussion Group link:- https://t.me/joinchat/VCyGUmVq8RNkMzhl Downloads resources from here https://education4fun.com/gate-cse/ MCQ (Single Correct Answer) GATE CSE 2015 Set 3 Consider the following partial Schedule S involving two transactions T1 and T2. Only the read and the 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