GATE 2021 CSSet2
October 22, 2023JNU 20181 PhD CS
October 22, 2023GATE 2021 CSSet2
Question 21

Let S be the following schedule of operations of three transactions T_{1}, T_{2} and T_{3}in a relational database system:
R_{2}(Y), R_{1}(X), R_{3}(Z), R_{1}(Y), W_{1}(X), R_{2}(Z), W_{2}(Y), R_{3}(X), W_{3}(Z)
Consider the statements P and Q below:
P: S is conflictserializable.
Q: If T_{3}commits before T_{1}finishes, then S is recoverable.
Which one of the following choices is correct?
P is true and Q is false.


Both P and Q are false.


Both P and Q are true.


P is false and Q is true.

Question 21 Explanation:
Correct Answer: A
Question 21 Explanation:
Subscribe
Login
0 Comments