11
AssignmentMultiple Choice

Designing a Relational Database

Question 11 • DRHS-Business and Tech BLOCK (07.4410030)

Why is it important for developers to be careful when using cascading deletes?

Answer
A
They may create orphaned records.
B
They may link to data in external databases.
C
They may delete more records than intended.
D
They may disconnect the bond between tables.

Explanation

A cascading delete automatically deletes related records when a parent record is deleted. If the relationship is broader than expected, deleting one record can also remove many dependent records, including ones the developer wanted to keep. That is why cascading deletes may delete more records than intended.

AI-written and checked against the verified answer.

Previous
Next