VOOZH about

URL: https://www.geeksforgeeks.org/questions/consider-the-following-database-schedule-with-two-transactions-t1/

⇱ GATE | CS | 2016 | Set 2 | DBMS | Transactions | Question 61


Last Updated :
Discuss
Comments

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?

S is non-recoverable

S is recoverable, but has a cascading abort

S does not have a cascading abort

S is strict

Share your thoughts in the comments
GeeksforGeeks