Relational databases typically use ACID (Atomicity, xe "consistency"Consistency, Isolation, Durability) transactions. Which of the following ACID attributes is described by: "ensures that the database is modified only if all of a transaction's steps are successful?"
A) Atomicity
B) Consistency
C) Isolation
D) Durability

Question

Quizplus · Accepted Answer

Atomicity refers to the property of a transaction where all the steps within the transaction are treated as a single unit of work. If any of the steps fail, the entire transaction is rolled back, leaving the database unchanged. Therefore, Atomicity ensures that the database is modified only if all of a transaction's steps are successful.

Relational Databases Typically Use ACID (Atomicity, Xe "Consistency"Consistency, Isolation, Durability)