ITPEC IP April 2021 Question 26
ITPEC IP April 2021 — Question 26 of 100
Exclusive control prevents conflicting simultaneous access and preserves data consistency. A DBMS locks the relevant record, table, or other resource so that incompatible operations by another transaction must wait until the lock is released.
Answer (c)
Why not others:
- normalization organizes table structure to reduce redundancy and anomalies
- deadlock is an undesirable circular waiting condition that locking can create
- restore recovers data from backups or logs after a failure
Key rule: Concurrency control coordinates overlapping transactions; exclusive locks prevent other transactions from making conflicting changes.
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.