Related questions

0 votes
0 answers
0 votes
1 answer
asked Aug 10 in MySQL by anonymous
0 votes
1 answer
asked Aug 3 in MySQL by anonymous
0 votes
1 answer

Properties of Transactions

0 votes

Properties of Transactions

asked Aug 9 in MySQL by anonymous

1 Answer

0 votes

Transactions have the following four standard properties, usually referred to by the acronym ACID −

  • Atomicity − This ensures that all operations within the work unit are completed successfully; otherwise, the transaction is aborted at the point of failure and previous operations are rolled back to their former state.

  • Consistency − This ensures that the database properly changes states upon a successfully committed transaction.

  • Isolation − This enables transactions to operate independently on and transparent to each other.

  • Durability − This ensures that the result or effect of a committed transaction persists in case of a system failure.

answered Aug 9 by anonymous
...