Which ACID property ensures that all operations in a database transaction are completed successfully, or none of them are applied at all?
Subject: Database Systems
Topic: Database Normalization
Options:
- Option A: Consistency
- Option B: Isolation
- Option C: Durability
- Option D: Atomicity
Correct Answer:
Option D: Atomicity
Explanation:
Atomicity is the 'all-or-nothing' property, ensuring that if any operation inside a transaction fails, the entire transaction is rolled back.