A(n)________ is a foreign key in one table that does not have a matching value in the primary key field of a related table.
A)duplicate key
B)wildcard
C)composite key
D)orphan

Question

Quizplus · Accepted Answer

An orphan is a foreign key in one table that does not have a matching value in the primary key field of a related table. This can occur when a record in the parent table is deleted without also deleting the related records in the child table, leaving them without a proper relationship to any record in the parent table.

A(n)________ Is a Foreign Key in One Table That Does