Home » Database » Database miscellaneous » Question

Database miscellaneous

  1. 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)
    1. Both S1 and S2 are conflict serializable
    2. S1 is conflict serializable and S2 is not conflict serialzable
    3. S1 is not conflict serializable and S2 is conflict serializable
    4. Both S1 and S2 are not 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)



Your comments will be displayed only after manual approval.