What Cascade Delete option is used for?

a. it is used to delete all the records of all tables in a database
b. It repeats the recent delete operation to all the records of the current table
c. It ensures that all the related records will be deleted automatically when the record from parent table is deleted.
d. None of these