GATE | CS | 2021 | Set 2 | Databases | Transaction & Concurrency Control | Question 42

Last Updated :
Discuss
Comments

Let S be the following schedule of operations of three transactions T1, T2 and T3 in 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 T3 commits before T1 finishes, then S is recoverable.

Which one of the following choices is correct?

Both P and Q are true

P is true and Q is false

P is false and Q is true

Both P and Q are false

This question is part of this quiz :

Transactions and concurrency control,GATE CS 2021 | Set 2,DBMS GATE CS PYQ QUIZ,Transaction & Concurrency Control GATE CS PYQ Quiz
Tags:
DBMS Quiz
GATE
DBMS
GATE CS
Share your thoughts in the comments