Which of the Following Statements About the FOREIGN KEY Constraint

Multiple Choice

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.