What is the purpose of the SQL CASCADE option in a foreign key constraint?

A. Automatically updates the foreign key value in the child table if the referenced key is updated

B. Automatically deletes the foreign key value in the child table if the referenced key is deleted

C. Automatically inserts a new foreign key value in the child table if the referenced key is inserted

D. Automatically modifies the foreign key value in the child table if the referenced key is modified

Correct Answer is :

B. Automatically deletes the foreign key value in the child table if the referenced key is deleted