ACID is a set of properties that guarantee that database transactions are…

Concept

In a database, a transaction is a logical unit of work made up of one or more operations. The ACID properties are the four guarantees a transaction system must provide so that data stays valid even when errors, crashes, or power failures occur. ACID is an acronym: Atomicity, Consistency, Isolation, Durability.

Applying it to this item

The letter A in ACID stands for Atomicity. Atomicity means a transaction is treated as a single, indivisible "all-or-nothing" unit: either every operation inside it completes successfully and is committed, or — if any operation fails — the whole transaction is rolled back and the database is left exactly as it was before the transaction started. There is no partial result.

Example: a bank transfer debits one account and credits another. Atomicity guarantees that you can never end up with the debit applied but the credit lost — both happen, or neither does.

Why the other terms are not "A"

• Consistency — the C in ACID; a transaction moves the database from one valid state to another, preserving all rules and constraints.

• Isolation — the I in ACID; concurrent transactions do not interfere with one another, as if each ran alone.

• Durability — the D in ACID; once a transaction is committed, its effects survive any later system failure.

So among the choices, Atomicity is the property denoted by A; "Access", "Algorithm", and "Affiliation" are not part of the ACID model at all.