LIVE Course for free

Rated by 1 million+ students
Get app now
0 votes
in Computer by (71.8k points)
closed by

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 T; on a variable Z, wi;(Z) denotes a write operation by Ti on a variable Z and a, 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

1 Answer

+1 vote
by (70.8k points)
selected by
Best answer

(C) S does not have a cascading abort 

No transaction is reading the data item written by some other transaction. So the given schedule is cascade less.

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.