GATE | CS | 2016 | Set 2 | DBMS | Transactions | Question 61 (original) (raw)

• DSA
• Practice Problems
• C
• C++
• Java
• Python
• JavaScript
• Data Science
• Machine Learning
• Courses
• Linux
• DevOps

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 recoverable, but has a cascading abort

S does not have a cascading abort

Share your thoughts in the comments

GeeksforGeeks