GATE | GATE-IT-2004 | Question 77
Consider the following schedule S of transactions T1 and T2:
|Read(A)A = A – 10||Read (A)Temp = 0.2*A|
Attention reader! Don’t stop learning now. Practice GATE exam well before the actual exam with the subject-wise and overall quizzes available in GATE Test Series Course.
Learn all GATE CS concepts with Free Live Classes on our youtube channel.
B = B + 10
|B = B + TempWrite(B)|
(A) S is serializable only as T1, T2
(B) S is serializable only as T2, T1
(C) S is serializable both as T1, T2 and T2, T1
(D) S is serializable either as T1 or as T2
(E) None of these
Explanation: This given schedule is not serializable as cycles exist in precedence graph .Therefore, options A, B, C, D are practically not possible.
The answer should be schedule is NOT serializable both as T2,T1 and T1,T2