Detailed explanation and options for the selected question.
What is the purpose of the CASCADE DELETE operation in a database?
A.
To automatically delete related records
B.
To remove all records from a table
C.
To delete specific rows based on a condition
D.
To modify a table structure
Explanation:
CASCADE DELETE automatically removes related records in child tables when a record in the parent table is deleted. It does not remove all records or modify the table structure.