in Databases edited by
241 views
0 votes
0 votes

In a databse system, let TS(T1) and TS(T2) be the timestamps of transactions T1 and T2 respectively. W-t(X) denotes the largest timestamp of any transaction that executed write(X) successfully and R-t(X) denotes the largest timestamp of any transaction that executed read(X) successfully. Which of the following is False?

  1.  If transaction T₁ issues read(X) operation and TS(T) < W-t(X) then T₁ is rolled back.
  2. If transaction T₁ issues read(X) operation and TS(T₁)> W-t(X) then write operation is executed.
  3. If transaction T₁ issues write(X) operation and TS(T₁) < W-t(X) then T₁ is rolled back
  4. All of the above.

PS: Ans given as B

in Databases edited by
241 views

Please log in or register to answer this question.

Related questions