Q. What is the use of Referential Integrity in MS Access?
-
(A)
It allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table
-
(B)
It does not allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table
-
(C)
It allow to enter a value in the Primary key field of a child table if that value exist in the Foreign key of the parent table
-
(D)
None of above
✅ Correct Answer: (A)
It allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table