Which two actions would you take to overcome this error?

Exhibit: 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: 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.)

A.
first, delete rows from the EMPLOYEES table for department id 30 and then delete the
rows from the DEPARTMENTS table for department id 30

B.
first, delete all of the rows from EMPLOYEES table and then delete the rows from the
DEPARTMENTS table for department id 30

C.
first, drop the DEPARTMENTS table and then delete the rows from the EMPLOYEES
table

D.
first, drop the EMPLOYEES table and then delete the rows from the DEPARTMENTS
table

E.
alter the foreign key constraint to include the cascade option

F.
alter the foreign key constraint to include the on delete cascade option



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Dhanushka

Dhanushka

NO EXHIBI