Computer scienceFundamentalsSQL and DatabasesDBMSMySQLData Definition Language

FOREIGN KEY constraint

Theory

Referential actions

Report a typo

Match the referential actions with what they do.

Match the items from left and right columns
CASCADE
SET NULL
RESTRICT
SET DEFAULT
Sets the foreign key in the child table to default value.
Sets the foreign key in the child table to NULL.
Rejects the delete or update operation for the parent table.
Automatically deletes or updates the matching rows in the child table.
___

Create a free account to access the full topic