ITPEC FE Morning October 2019 Question 27
ITPEC FE Morning October 2019 — Question 27 of 80
DBMS Data Confidentiality — access rights management protects data confidentiality.
Confidentiality means ensuring only authorized users can access data.
Among DBMS functions:
- Access rights management → confidentiality (controls who can read/write data)
- Referential constraints → integrity (ensures valid foreign key references)
- Transaction management → integrity (ACID properties, atomicity)
- Exclusive locks → integrity (concurrency control, prevents dirty reads)
Key rule: Confidentiality = access control; Integrity = constraints + transactions + locks.
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.