391 views
1 votes
1 votes

T1:W(X), T2:R(Y), T1:R(Y), T2:R(X)

 

is it  recoverable?

1 Answer

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.
selected by

Related questions

0 votes
0 votes
2 answers
1
joshipratik232 asked Aug 16, 2022
453 views
Does Conservative 2PL ensures Recoverability ? If Yes then Does it ensures Cascadeless or Strict recoverable schedule ?
0 votes
0 votes
0 answers
3
gatecrack asked Sep 5, 2018
378 views
Consider th following scheduler1(A)r2(B)r3(C)w1(B)w2(C)w3(D)Find the schedule which are possible to execute by strict 2PL protocol? consider commit operation as immediate...