Test by Bikram | Databases | Test 1 | Question: 8

Question

The rule that a value of a foreign key must appear as a value of some specific table is called a

• A. Referential constraint
• B. Index
• C. Integrity constraint
• D. Functional dependency

Answer 1

The rule of referential integrity requires that every foreign-key value must appear as another table's primary key value.

References:

• http://www.personal.kent.edu/~jtalbott/chapter_22/chapter_22.html
• https://www.w3resource.com/sql/creating-and-maintaining-tables/foreign-key.php
• http://iete-elan.ac.in/SolQP/AC14.htm

The correct answer is $(A)$.