Lost update problem definition: is it when User A reads data that come from a partial (uncommitted) transaction of User B?

Difficulty: Easy

Correct Answer: Invalid statement

Explanation:


Introduction / Context:
Classic anomalies include dirty read, nonrepeatable read, phantom read, and lost update. Each has a precise definition. This question verifies whether you can accurately state what “lost update” means.


Given Data / Assumptions:

  • Dirty read: reading uncommitted data.
  • Nonrepeatable read: seeing a row change between two reads in the same transaction.
  • Lost update: two transactions update the same data; one overwrites the other without awareness.


Concept / Approach:
The statement provided describes a dirty or inconsistent read rather than a lost update. A lost update requires conflicting writes where one transaction’s update is effectively undone or overwritten by another committed update.


Step-by-Step Solution:
Compare definitions: “reads uncommitted” → dirty read; “overwritten writes” → lost update.The statement talks about User A reading data processed by part of User B’s transaction → that is dirty/inconsistent read.Therefore, this is not the lost update definition and the statement is invalid.


Verification / Alternative check:
Simulate two UPDATEs without proper isolation; observe last writer wins and one change is lost—this is the lost update scenario, not merely a read of uncommitted data.


Why Other Options Are Wrong:
Snapshot isolation actually prevents lost updates via write-write checks; equating with nonrepeatable read is incorrect.


Common Pitfalls:
Mixing up anomaly names; thinking any anomaly with two users is “lost update.”


Final Answer:
Invalid statement

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion