Database Fundamentals — Question 69

You delete rows in a table named Order. The corresponding rows in the OrderItem table are automatically deleted. This process is an example of a/an:

Answer options

• A. Inherited delete
• B. Cascade delete
• C. Functional delete
• D. Waterfall delete
• E. Domino delete

Correct answer: B

Explanation

The correct answer is B, Cascade delete, as it describes the automatic deletion of related records in a foreign key relationship when the primary record is deleted. The other options, such as Inherited delete, Functional delete, Waterfall delete, and Domino delete, do not accurately represent this behavior in database management.