SQL Fundamentals

Basic Transactions: Interview

What makes a database transaction atomic? All statements in the transaction commit as one unit, or every uncommitted change is rolled back when a step fails. No

What makes a database transaction atomic?

All statements in the transaction commit as one unit, or every uncommitted change is rolled back when a step fails. No partial business operation becomes visible.

Use a money transfer to explain why partial success is unacceptable.