In ACID, what does atomicity guarantee for a transaction?
- All its changes apply, or none do
- Other sessions never see it run
- Its data survives a power cut
- Its rows always satisfy all constraints
Atomicity makes the transaction all-or-nothing; durability, isolation and consistency are the other letters.
Play SQL & Databases ▸