UGC NET CS 2012 June-Paper2
November 9, 2023
Transactions
November 9, 2023
UGC NET CS 2012 June-Paper2
November 9, 2023
Transactions
November 9, 2023

Database-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)

Which one of the following options is correct?

A
S1is not conflict serializable, and S2 is conflict serializable.
B
Neither S1nor S2is conflict serializable.
C
Both S1and S2are conflict serializable.
D
S1is conflict serializable, and S2is not conflict serializable.
Question 4 Explanation: 
Correct Answer: A
Question 4 Explanation: 
0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x