Which of the following keywords must have been included during the creation of a FOREIGN KEY constraint to allow a row from the parent table to be deleted,even if it is referenced by a row in the child table?
A) CASCADE
B) AUTO REMOVE
C) ON DELETE CASCADE
D) none of the above

Question

Which of the following keywords must have been included during the creation of a FOREIGN KEY constraint to allow a row from the parent table to be deleted,even if it is referenced by a row in the child table?​
A) ​CASCADE
B) ​AUTO REMOVE
C) ​ON DELETE CASCADE
D) ​none of the above

Quizplus · Accepted Answer

The keyword "ON DELETE CASCADE" must be included during the creation of a FOREIGN KEY constraint to allow a row from the parent table to be deleted, even if it is referenced by a row in the child table. This means that when a row in the parent table is deleted, all the referencing rows in the child table will also be deleted automatically. This ensures referential integrity in the database. The other options (A) CASCADE and (B) AUTO REMOVE are not valid keywords in SQL for this purpose.

Which of the Following Keywords Must Have Been Included During