A ________ is used to limit the possible values of a foreign key.
A)composite key
B)surrogate key
C)functional dependency
D)referential integrity constraint
E)normal form

Question

Quizplus · Accepted Answer

Referential integrity constraints are used to limit the possible values of a foreign key, ensuring that it only references a valid row in the related table. This helps to maintain database consistency and accuracy. A composite key is a combination of two or more columns that uniquely identifies a row in a table. A surrogate key is a system-generated unique identifier that is used instead of natural keys. Functional dependency refers to the relationship between two attributes in a table, where one attribute determines the value of another attribute. Normal form is a set of rules that a table must conform to in order to minimize data redundancy and improve data integrity.

A ________ Is Used to Limit the Possible Values of a Foreign