Transactions

A transaction is a unit of work.

Databases use the concept of atomic transactions i.e. “all or none”: either all transactions occur or none occur. This helps ensure consistency.

All transactions get committed by default (one can also use the commit command). A transaction can be undone using the rollback command.