ITPEC FE Morning October 2021 Question 28
ITPEC FE Morning October 2021 — Question 28 of 80
Transaction Support in DBMS — ensures atomicity of database operations.
The main purpose of transaction support is to guarantee that either all updates in a transaction are applied, or none are — this is the Atomicity property of ACID.
Why not others:
- (b) — describes access control / authorization, not transaction management
- (c) — describes a GUI front-end, unrelated to transactions
- (d) — describes a data dictionary / catalog for storing metadata
Key rule: Transaction support = ACID properties (Atomicity, Consistency, Isolation, Durability). The defining feature is "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.