Consider the following database schedule with two transactions, T1 and T2.S = r2(X); r1(X); r2(Y); w1(X); r1(Y); w2(X); a1; a2;where ri(Z) denotes a read operation by transaction Ti on a variable Z, wi(Z) denotes a write operation by Ti on a variable Z and ai denotes an abort by transaction Ti . Which one of the following statements about the above schedule is TRUE?

Question

TuteeHUB · Accepted Answer

S is strict

TuteeHUB · Answer

S is non-recoverable

TuteeHUB · Answer

S is recoverable, but has a cascading abort

TuteeHUB · Answer

S does not have a cascading abort

1.	Consider the following database schedule with two transactions, T1 and T2.S = r2(X); r1(X); r2(Y); w1(X); r1(Y); w2(X); a1; a2;where ri(Z) denotes a read operation by transaction Ti on a variable Z, wi(Z) denotes a write operation by Ti on a variable Z and ai denotes an abort by transaction Ti . Which one of the following statements about the above schedule is TRUE?
A.	S is non-recoverable
B.	S is recoverable, but has a cascading abort
C.	S does not have a cascading abort
D.	S is strict
Answer» D. S is strict

Discussion

No Comment Found

Related MCQs

Reply to Comment