Question

When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):

(a) Transitive Dependency

(b) Insertion Anomaly

(c) Referential Integrity Constraint

(d) Normal Form

Answer 1

Right answer is (c) Referential Integrity Constraint

For explanation I would say: Referential Integrity is set of constraints applied to foreign key which prevents entering a row in child table for which you don’t have any corresponding row in parent table i.e. entering NULL or invalid foreign keys.