Gate CS-2016-2 Question Paper With Solutions

Q. 61 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: (C)

Explanation:

Gate CS-2016-2 Question Paper With Solutions

Learn More:   Gate EE-2009 Question Paper With Solutions

LEAVE A REPLY

Please enter your comment!
Please enter your name here