ITPEC FE Subject A April 2025 Question 18

Source exam: ITPEC FE Subject A April 2025Topic: Databases

ITPEC FE Subject A April 2025 — Question 18 of 60

DBMS Confidentiality — access rights management protects data confidentiality.

Confidentiality means only authorized users can view or access data. Among DBMS functions, managing data access rights directly enforces this.

  • •(a) Referential constraints — ensures integrity (foreign key consistency), not confidentiality
  • •(b) Transaction management — ensures integrity via ACID properties (atomicity, consistency)
  • •(d) Exclusive lock — ensures integrity / consistency during concurrent updates

Key rule: Map to the CIA triad:
- Confidentiality → access control, permissions
- Integrity → constraints, transactions, locks
- Availability → redundancy, backups

AI-generated — may contain errors

The original exam layout is preserved in the image so diagrams, formulas, tables, and code remain accurate.

Practice this exam

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.