Which ACID property ensures that a transaction is all-or-nothing?

Study for the SQL Basics Test. Improve your knowledge with multiple choice questions and detailed explanations. Prepare effectively to master SQL concepts!

Atomicity is the property that ensures a transaction is all-or-nothing. It treats the entire set of operations as a single unit, so either every change is applied and the transaction commits, or if anything fails, none of the changes take effect and the system is rolled back to its previous state. This prevents partial updates and keeps the database from ending up in an inconsistent state. Consistency focuses on data validity constraints, isolation on how concurrent transactions interact, and durability on preserving committed changes after a failure. Therefore, the all-or-nothing behavior described is the hallmark of atomicity.