Explanation:
It will be error generated because there are 2 child records in the EMPLOYEES table with department number you try to delete from the DEPARTMENTS table.
Incorrect Answers:
1: The row with department ID 40 will not be deleted because of the child records in the EMPLOYEES table.
3: Neither the row with department ID 40 will not be deleted not child records in the EMPLOYEES table will be deleted.
4: It will be error when you try to execute the DELETE statement, no rows will be deleted in the EMPLOYEES or the DEPARTMENTS tables.
5: It will be error when you try to execute the DELETE statement, no rows will be deleted in the EMPLOYEES or the DEPARTMENTS tables.
6: The statement fails because of constraint violation not because there are no columns specifies in the DELETE clause of the DELETE statement.u OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 240-245u Chapter 5: Creating Oracle Database Objects

---