Oracle
1Z0-146 · Question #157
1Z0-146 Question #157: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-146 to reveal the answer and full explanation for question #157. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-146 to see the answer
You've previewed enough free 1Z0-146 questions. Unlock 1Z0-146 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.