1 votes 1 votes • T1:W(X), T2:R(Y), T1:R(Y), T2:R(X) is it recoverable? gabbar asked Oct 30, 2016 gabbar 406 views answer comment Share Follow See all 2 Comments See all 2 2 Comments reply Habibkhan commented Oct 30, 2016 reply Follow Share For recoverability commit or abort must be mentioned in the transaction else we cannot conclude. 1 votes 1 votes Rajesh Pradhan commented Oct 30, 2016 reply Follow Share Correct @HabibKhan 0 votes 0 votes Please log in or register to add a comment.
Best answer 2 votes 2 votes Remember:-> if the Tx which done dirty read commit first then this is non-recoverable schedule else recoverable. Here T2 has done Dirty read. Suppose if T2 commits before T1 then T1 rollbacks then this schedule will lead to Non-recoverable . Any other combination is recoverable. Rajesh Pradhan answered Oct 30, 2016 • selected Nov 6, 2016 by Rajesh Pradhan Rajesh Pradhan comment Share Follow See 1 comment See all 1 1 comment reply gabbar commented Oct 30, 2016 reply Follow Share thnq 0 votes 0 votes Please log in or register to add a comment.