Which two actions would you take to overcome this error?

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.
alter the foreign key constraint to include the cascade option

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

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

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

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

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