In MS Access, which relationship layout constraint ensures that records cannot be deleted from a parent table if matching child records exist in a linked table? MCQ with Answer and Explanation
In MS Access, which relationship layout constraint ensures that records cannot be deleted from a parent table if matching child records exist in a linked table?
A. Referential Integrity
B. Data Validation constraints
C. Cascade Update property
D. Input Mask validation
Answer: Option A
Solution (By JKExamLibrary)
Enforcing Referential Integrity ensures that relationships between tables stay consistent, preventing orphan records by blocking deletions in a parent table when linked child rows exist.
No comments yet. Be the first to start the discussion!