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. Input Mask validation
B. Data Validation constraints
C. Referential Integrity
D. Cascade Update property
Answer: Option C
Solution (By JKSSB Mock Tests)
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!