ACID

Question 1

Atomicity

Answer 1

Transaction must be processed in its entirety or not at all

Question 2

Consistency

Answer 2

Transaction must maintain the referential integrity rules between linked tables

Question 3

Isolation

Answer 3

Simultaneous exections of transactions should lead to the same result as if they were executed sequentially

Question 4

Durability

Answer 4

Once a transaction has been executed it will remain so.