ITPEC FE Subject A October 2024 Question 22
Source exam: ITPEC FE Subject A October 2024Topic: Databases
ITPEC FE Subject A October 2024 — Question 22 of 60
ACID — Atomicity — a transaction either fully completes or is entirely rolled back.
The question asks which ACID property guarantees "all or nothing" behavior for transactions.
- •Atomicity — ensures a transaction is treated as a single unit: it either commits all changes or rolls back completely, as if nothing happened
- •Consistency — ensures the database moves from one valid state to another
- •Durability — ensures committed data survives system failures
- •Isolation — ensures concurrent transactions do not interfere with each other
Answer: `a) Atomicity`
Key rule: "Fully completes or revoked as if no processing took place" = Atomicity (all-or-nothing).
AI-generated — may contain errors
The original exam layout is preserved in the image so diagrams, formulas, tables, and code remain accurate.
This question comes from an official ITPEC past paper. ITPEC Practice is an independent study tool and is not affiliated with ITPEC. See the official FE past-paper collection or Report an issue.