UGC NET CS 2012 June-Paper2
November 9, 2023Transactions
November 9, 2023Database-Management-System
| Question 4 |
Let ri(z) and wi(z) denote read and write operations respectively on a data item z by a transaction Ti. Consider the following two schedules.
S1: r1(x) r1(y) r2(x) r2(y) w2(y) w1(x)
S2: r1(x) r2(x) r2(y) w2(y) r1(y) w1(x)
S1: r1(x) r1(y) r2(x) r2(y) w2(y) w1(x)
S2: r1(x) r2(x) r2(y) w2(y) r1(y) w1(x)
Which one of the following options is correct?
| S1is not conflict serializable, and S2 is conflict serializable. | |
| Neither S1nor S2is conflict serializable.
| |
| Both S1and S2are conflict serializable. | |
| S1is conflict serializable, and S2is not conflict serializable. |
Question 4 Explanation:
Correct Answer: A
Question 4 Explanation: