Which of the Following Statements About the FOREIGN KEY Constraint

question 118

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.

---

Definitions:

Cases

Instances or occurrences of a particular disease or condition being studied.

Measured Variables

Variables in an experiment or observational study that are quantified or recorded by the researcher.

Units

Basic quantities or components that serve as a standard of measurement in scientific observations or calculations.

Boxplots

A standardized way of displaying the distribution of data based on a five-number summary: minimum, first quartile, median, third quartile, and maximum.