In a banking system, a transaction T1 transfers ₹300 from Account A to Account B. Balances are stored in a table Accounts(AccNo, Balance) with the constraint:
In a banking system, a transaction T1 transfers ₹300 from Account A to Account B. Balances are stored in a table Accounts(AccNo, Balance) with the constraint:
CHECK (Balance >= 0)
Suppose the following sequence occurs:
1. T1 deducts ₹300 from Account A.
2. System crashes before adding ₹300 to Account B.
3. The system restarts without recovery.
Which component of ACID has been compromised to the greatest extent in this case?
Show answerHide answer
Correct answer: (B) Atomicity