Transactions
January 4, 2024Transactions
January 4, 2024Transactions
| Question 12 |
Consider the following transaction involving two bank account 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 |
Question 12 Explanation:
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.
Correct Answer: B
Question 12 Explanation:
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.