A directory of Objective Type Questions covering all the Computer Science subjects. Here you can access and discuss Multiple choice questions and answers for various compitative exams and interviews.

Discussion Forum

Que. 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:S does not have a cascading abort
Confused About the Answer? Ask for Details Here
Know Explanation? Add it Here

Similar Questions: