ITPEC IP October 2025 Question 29
ITPEC IP October 2025 — Question 29 of 100
Prevent inconsistencies when multiple programs access the same data concurrently — this is the purpose of exclusive control.
Locks coordinate overlapping transactions so that one transaction cannot interfere with another's critical update. Without suitable concurrency control, lost updates, dirty reads, and other anomalies can leave results inconsistent.
Answer (d)
Why not others:
- (a) describes integrity protection in a broad security sense
- (b) describes data independence between programs and stored structures
- (c) describes authorization and access control based on confidentiality
Key rule: Exclusive control manages simultaneous operations for transactional consistency; authorization decides who may access the data.
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 IP past-paper collection or Report an issue.