The ON DELETE ____ setting tells Oracle 10g that when a parent row is deleted,all the related child rows are also deleted.
A) DEFER
B) CASCADE
C) SET NULL
D) UPDATE

Question

Quizplus · Accepted Answer

The CASCADE option tells Oracle 10g to automatically delete all related child rows when a parent row is deleted. This ensures data integrity and prevents orphaned child rows from being left behind. The DEFER option allows the deletion of the parent row to be deferred until all referencing foreign keys have been deleted or set to NULL. The SET NULL option sets all referencing foreign key values to NULL when the parent row is deleted. The UPDATE option updates all referencing foreign key values to a specified value when the parent row is updated.

The ON DELETE ____ Setting Tells Oracle 10g That When