CAF-3 · Chapter 2 · Question 12 of 15
When attempting to delete a vendor from the company's ERP system, an accountant receives an error message stating: "Cannot delete vendor. Active purchase orders are still linked to this vendor ID." This control enforces:
Test yourself: pick an answer
Reveal answer & explanation
Correct answer: A) Referential Integrity
Explanation
Referential integrity maintains valid relationships between tables using Foreign Keys, ensuring that parent records (like a vendor) cannot be deleted if child records (like pending orders) are still linked to them
More Data Classification MCQs
- Q14A cloud service provider installs temperature sensors, fire suppression systems, and backup generators in its data center to ensure…
- Q15A financial institution stores its highly restricted customer transaction data on its own physical servers to maintain maximum security…
- Q1The CEO of a multinational bank establishes a vision to migrate 80% of their customer data to a secure cloud environment by 2028 to…
- Q2An IT manager at a retail chain drafts a new password policy requiring all employees to use 12-character passwords and updates the…
- Q3A junior data analyst runs a daily script to identify and flag any missing customer email addresses in the company's CRM system. This…