Question

Referential integrity constraints are also called as _________

(a) Functional dependencies

(b) Subset dependencies

(c) Superset dependencies

(d) Primary dependencies

I got this question by my college director while I was bunking the class.

The question is from Integrity Constraints topic in section Intermediate and Advanced Sql of RDBMS

Answer 1

Correct choice is (b) Subset dependencies

The best explanation: Referential integrity constraints are also called as subset dependencies. It is called so because the set of foreign key values in r1 of r2 must be a subset of the set of primary key values in r2.