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) composite key
B) orphan
C) wildcard
D) duplicate key

Question

Quizplus · Accepted Answer

This is commonly referred to as an orphaned record. It occurs when a record in a child table references a record in a parent table that no longer exists. This can happen when a record in the parent table is deleted or when a child record is created without a matching parent record.

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