Oracle
1Z0-146 · Question #157
In SQL*Plus, you issued this command: DELETE FROM dept WHERE dept_id = 901; You received an integrity constraint error because a child record was found. What could you do to make the statement…
The correct answer is A. Delete the child records first. See the full explanation below for the reasoning.
Question
In SQL*Plus, you issued this command:
DELETE FROM dept WHERE dept_id = 901; You received an integrity constraint error because a child record was found. What could you do to make the statement execute?
Options
- ADelete the child records first.
- BYou cannot make the command execute.
- CAdd the FORCE keyword to the command.
- DAdd the CONSTRAINTS CASCADE option to the command.
How the community answered
(29 responses)- A72% (21)
- B14% (4)
- C3% (1)
- D10% (3)
Community Discussion
No community discussion yet for this question.