ITPEC FE Subject A October 2025 Question 22
Source exam: ITPEC FE Subject A October 2025Topic: Databases
ITPEC FE Subject A October 2025 — Question 22 of 60
ACID — Isolation property — transactions execute without affecting each other.
ACID properties in transaction management:
- •Atomicity — transaction is either fully completed or fully revoked (all-or-nothing)
- •Consistency — only valid data is written to the database; constraints are preserved
- •Isolation — concurrent transactions do not interfere with each other
- •Durability — once committed, data is permanently stored even after system failure
Why not others:
- (a) "Data is written permanently" — describes Durability
- (b) "Only valid data" — describes Consistency
- (c) "Fully completed or revoked" — describes Atomicity
Key rule: Each ACID letter maps to exactly one guarantee. Isolation = transactions are independent of each other.
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.