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 current table
• C. It ensures that all the related records will be deleted automatically when the record from parent table is deleted.
• D. It is used to delete all the records of related tables in a database