If you omit the ____ parameter,you cannot delete a row from the parent table,if it has related children in other tables.
A) ON DELETE
B) CASCADE
C) DEFER
D) SET NULL

Question

Quizplus · Accepted Answer

The ON DELETE parameter specifies what to do with related records in child tables when a record is deleted from the parent table. If it is omitted, the database will not allow the record in the parent table to be deleted if there are related records in the child tables. Therefore, A is the best choice because it is directly related to deleting a row from the parent table. CASCADE, DEFER, and SET NULL are related to handling related records in child tables when a record in the parent table is updated or deleted, but they do not address the issue of preventing deletion of the parent record.

If You Omit the ____ Parameter,you Cannot Delete a Row