-
Consider the following schedules involving two transactions. Which one of the following statements is true?
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)
-
- Both S1 and S2 are conflict serializable
- S1 is conflict serializable and S2 is not conflict serialzable
- S1 is not conflict serializable and S2 is conflict serializable
- Both S1 and S2 are not conflict serializable
- Both S1 and S2 are conflict serializable
Correct Option: C
Lets construct the S1 and S2 with the time to check the serializable conflict.
S1 → No serializable conflict
S2 → Serializable conflict in w1 (x)