ACID Transaction Properties

Database theory's definition of a transaction states:

• Atomic Transactions are atomic, meaning that the SQL statements contained in a transaction make up a single unit of work.
• Consistent Transactions ensure that the database state remains consistent, meaning that the database is in a consistent state when a transaction begins and that it ends in another consistent state when the transaction finishes.
• Isolated Separate transactions should not interfere with each other.
• Durable Once a transaction has been committed, the database changes are preserved, even if the machine on which the database software is running crashes later.

Referenced from Oracle 11g SQL by Jason Price

1. Committing and Rolling Back a Transaction
2. Starting and Ending a Transaction
3. Savepoints
4. ACID Transaction Properties