ITPEC IP October 2022 Question 26
ITPEC IP October 2022 — Question 26 of 100
Exclusive control prevents conflicting simultaneous access and preserves database consistency. A DBMS uses locks or equivalent concurrency-control mechanisms so incompatible operations on the same data do not proceed at the same time. Other transactions wait or follow controlled isolation rules.
Answer (c)
Why not others:
- normalization restructures tables to reduce redundancy and anomalies
- deadlock is an undesirable state in which transactions wait for one another
- restore recovers data from backups or recovery information
Key rule: Concurrency control coordinates simultaneous transactions; exclusive locks prevent competing updates to protected 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.