B. It is used to delete all the records of tables in a database
C. It ensures that all the related records will be deleted from parent table is deleted
D. It repeats the recent delete operation to all the records of current table
Explanation
The Cascade Delete option is a database feature that automatically deletes all related records in a child table when a record is deleted from a parent table.
This helps maintain data consistency and integrity by ensuring that all related data is removed when a primary record is deleted.
