Question discussion

Transactions T1: Read(A), A=A+10, Write(A) and T2: Read(A), A=A*2, Write(A) execute concurrently, both starting with A=50, in the order: T1…

526Medium DSSSB TGT Computer Science 0 replies
Transactions T1: Read(A), A=A+10, Write(A) and T2: Read(A), A=A*2, Write(A) execute concurrently, both starting with A=50, in the order: T1-Read(A), T2-Read(A), T1-Write(A), T2-Write(A). What is the final value of A, and is this a lost-update scenario?
  • AFinal A=60; not a lost update
  • BFinal A=100; a lost update (T1's update is lost)
  • CFinal A=110; no anomaly
  • DFinal A=100; no anomaly, since the final value is correct
Correct answer: B

Discussion 0

Nobody has replied yet. Start the discussion!