Which of the following statements about the FOREIGN KEY constraint is incorrect?
A) The constraint exists between two tables,called the parent table and the child table.
B) When the constraint exists,by default a record cannot be deleted from the parent table if matching entries exist in the child table.
C) The constraint can reference any column in another table,even a column that has not been designated as the primary key for the referenced table.
D) When the keywords ON DELETE CASCADE are included in the constraint definition,a corresponding child record will automatically be deleted when the parent record is deleted.

Question

Which of the following statements about the FOREIGN KEY constraint is incorrect?​
A) ​The constraint exists between two tables,called the parent table and the child table.
B) ​When the constraint exists,by default a record cannot be deleted from the parent table if matching entries exist in the child table.
C) ​The constraint can reference any column in another table,even a column that has not been designated as the primary key for the referenced table.
D) ​When the keywords ON DELETE CASCADE are included in the constraint definition,a corresponding child record will automatically be deleted when the parent record is deleted.

Quizplus · Accepted Answer

The FOREIGN KEY constraint must reference a column in another table that has been designated as the primary key for the referenced table.

Which of the Following Statements About the FOREIGN KEY Constraint