Transactions Flashcards
1
Q
What are the ACID Properties?
A
Atomicity
Consistency
Isolation
Durability
2
Q
Atomicity
A
Either all operations of the transaction are properly reflected in the databases or none are (All or nothing)
3
Q
Consistency
A
Execution of a transaction preserves the consistency of the database
4
Q
Isolation
A
If multiple transactions occur, each one must be unaware of other executing transactions
5
Q
Durability
A
After a successful transaction, the changes made to the database persist.. even if there are system failures