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. Cascade Update property
B. Data Validation constraints
C. Referential Integrity
D. Input Mask validation
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.
Explanation:
Design View allows the user to define or modify the underlying structure of database objects, such as field properties, query criteria, form layout, etc. Datasheet View is for data entry.
No comments yet. Be the first to start the discussion!