Related questions

0 votes
1 answer
0 votes
0 answers
asked Jul 29, 2017 in MySQL by vidya (500 points)
0 votes
1 answer
asked Aug 10, 2017 in MySQL by anonymous
0 votes
1 answer
asked Aug 3, 2017 in MySQL by anonymous
0 votes
1 answer

Properties of Transactions

0 votes

Properties of Transactions

asked Aug 9, 2017 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, 2017 by anonymous
...