-
Consider the following transaction involving two bank accounts x and y.
read(x); x: = x–50; write(x); read (y); y = y + 50; write(y)
The constraint that the sum of the accounts x and y should remain constant is that of
-
- Atomicity
- Consistency
- Isolation
- Durability
- Atomicity
Correct Option: B
The consistency property ensures that the database remains in a consistent state before the (start of the transaction and after the transaction is over. Here sum of the accounts x & y should remain same before & after execution of the given transactions which refers to the consistency of the sum.
