Question

A(n) FOREIGN KEY constraint can only reference a column in the parent table that has been designated as the primary key for that table.

A) True
B) False

Answer 1

The assertion that a FOREIGN KEY constraint can only reference a primary key in the parent table is false, as it can also reference any column with a UNIQUE constraint.

Step-by-step explanation:

The statement "A(n) FOREIGN KEY constraint can only reference a column in the parent table that has been designated as the primary key for that table." is False.

A FOREIGN KEY constraint in a database does not necessarily need to reference a primary key in the parent table; it can reference any column that has been defined as a UNIQUE key. The referenced column must be a candidate key, which means it could be a primary key or any column with a UNIQUE constraint that uniquely identifies each row in the table.