In MS Access, which type of relationship prevents orphan records by ensuring that related records exist?
A. Cascade Delete
B. Referential Integrity
C. Composite Key
D. One-to-Many
Answer: Option B
Solution (By JKSSB Mock Tests)
Referential Integrity ensures that a record in a related table must have a matching key in the primary table. Cascade delete removes related records automatically.
No comments yet. Be the first to start the discussion!