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 conflict-serializable. Q: If T 3 commits before T 1 finishes, then S is recoverable. Which one of the following choices is correct?

Correct Answer is : P is true and Q is false.

GATE Computer Science (CS) 2021 Shift 2 Solved Paper

Question : 42 of 65

Marks: +1, -0

Let S be the following schedule of operations of three transactions T₁, T₂ and T₃ in a relational database system:
R₂(Y), R₁(X), R₃(Z), R₁(Y), W₁(X), R₂(Z), W₂(Y), R₃(X), W₃(Z)
Consider the statements P and Q below:
P: S is conflict-serializable.
Q: If T₃ commits before T₁ 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 true.
P is false and Q is true.
Both P and Q are false.

Validate

Go to Question:

Prev Question

Next Question