Which of the following is TRUE about CASCADE delete rule?

A.
Enforces the presence of a parent row for every child after all the referential constraints are
applied.

B.
Implies that deleting a row in parent table automatically deletes any related rows in dependent
table.

C.
Ensures that deletion of a row in parent table sets values of foreign key in any dependent row
to null (if null able).

D.
Prevents any row in parent table from being deleted if any dependent rows are found.

Explanation: