Skip to content
Related Articles

Related Articles

GATE | GATE CS 2021 | Set 1 | Question 42

View Discussion
Improve Article
Save Article
Like Article
  • Difficulty Level : Easy
  • Last Updated : 24 May, 2021

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) 

Which one of the following options is correct?
(A) S1 is conflict serializable, and S2 is not conflict serializable
(B) S1 is not conflict serializable, and S2 is conflict serializable
(C) Both S1 and S2 are conflict serializable
(D) Neither S1 nor S2 is conflict serializable


Answer: (B)

Explanation:

    S1
T1 T2
r(x)  
r(y)  
  r(x)
  r(y)
  w(y)
w(x)  
    S2 
T1 T2
r(x)  
  r(x)
  r(y)
  w(y)
r(y)  
w(x)  



Quiz of this Question

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!