DELETE FROM dept WHERE dept_id = 901; The above delete statement throws an integrity constraint error because a child record was found. What could we do to make the statement execute?
Answer options
A
Delete the child records first.
B
Use DROP TABLE instead.
C
Use TRUNCATE instead.
D
Add a NOT NULL constraint.
Correct answer: Delete the child records first.
Detailed Solution & Conceptual Analysis
This question has been retained as-is due to its unique context.
Key Engineering Takeaway
In Database Management, understanding the underlying mechanics of Database Management is critical for writing performant, bug-free production code and passing rigorous technical architecture reviews.