Question discussion

Transactions T1 (timestamp 10) and T2 (timestamp 20) run under basic timestamp ordering. T2 has already read the data item X. Now T1 issues…

2190Medium DSSSB TGT Computer Science 0 replies 1 views
0

Transactions T1 (timestamp 10) and T2 (timestamp 20) run under basic timestamp ordering. T2 has already read the data item X. Now T1 issues write(X). What happens?

  • AT1's write is allowed and X is updated
  • BT1 is rolled back and restarted with a new timestamp
  • CT2 is rolled back
  • DT1 waits until T2 commits
Correct answer: B

Explanation

A write by a transaction older than the latest reader (10 < 20) would invalidate that read, so basic timestamp ordering aborts the writer T1.

Discussion 0

Nobody has replied yet. Start the discussion!