A. It ensures that all the related records will be deleted from parent table is deleted
B. None of these
C. It is used to delete all the records of tables in a database
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.
