GATE 2021 CS-Set-2
October 22, 2023
JNU 2018-1 PhD CS
October 22, 2023
GATE 2021 CS-Set-2
October 22, 2023
JNU 2018-1 PhD CS
October 22, 2023

GATE 2021 CS-Set-2

Question 21
Let S be the following schedule of operations of three transactions T1, T2 and T3in a relational database system:

  R2(Y), R1(X), R3(Z), R1(Y), W1(X), R2(Z), W2(Y), R3(X), W3(Z)

Consider the statements P and Q below:

P: S is conflict-serializable.

Q: If T3commits before T1finishes, then S is recoverable.

Which one of the following choices is correct? 

A
P is true and Q is false.
B
Both P and Q are false.
C
Both P and Q are true.
D
P is false and Q is true.
Question 21 Explanation: 
Correct Answer: A
Question 21 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
error: Alert: Content selection is disabled!!