1Z0-052 · Question #222
View the Exhibit to see the structure of the EMPLOYEES and DEPARTMENTS tables. Your organization plans to dissolve the department with department ID 30. You execute the following command to delete row
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #222. The question stem and answer options stay visible for context.
Question
View the Exhibit to see the structure of the EMPLOYEES and DEPARTMENTS tables. Your organization plans to dissolve the department with department ID 30. You execute the following command to delete rows from the DEPARTMENTS table:
SQL>delete from DEPARTMENTS where DEPT_ID = 30; The command fails and displays the following error:
ERROR at line 1:
ORA-02292: integrity constraint (HR.SYS_C005374) violated - child record found Which two actions would you take to overcome this error? (Choose two.)
Exhibit
Options
- Aalter the foreign key constraint to include the cascade option
- Balter the foreign key constraint to include the on delete cascade option
- Cfirst, drop the EMPLOYEES table and then delete the rows from the DEPARTMENTS table
- Dfirst, drop the DEPARTMENTS table and then delete the rows from the EMPLOYEES table
- Efirst, delete all of the rows from EMPLOYEES table and then delete the rows from the
- Ffirst, delete rows from the EMPLOYEES table for department id 30 and then delete the rows from
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 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.