ON DELETE ____ instructs Oracle 10g to set the value of the foreign key column in the related child rows to null instead of deleting the rows.
A) DEFER
B) CASCADE
C) SET NULL
D) UPDATE

Question

Quizplus · Accepted Answer

The ON DELETE SET NULL option instructs Oracle 10g to set the value of the foreign key column in the related child rows to null instead of deleting the rows. This is useful when you want to keep the child rows in the database but break the relationship between the parent and child rows. The other options (DEFER, CASCADE, UPDATE) do not fit this scenario.

ON DELETE ____ Instructs Oracle 10g to Set the Value