OCP CBT Question 548

Please solve the following question.

You have two tables, `departments` and `employees`, with `department_id` in `employees` being a foreign key referencing `department_id` in `departments`. The foreign key constraint is defined as `ON DELETE RESTRICT` (default behavior in Oracle if no `ON DELETE` clause is specified, effectively preventing deletion of parent rows if child rows exist). You execute: ```sql DELETE FROM departments WHERE department_id = 50; ``` What is the expected result if there are employees currently assigned to department_id 50?

All employees in department 50 will also be deleted.

The DELETE statement will succeed, but the employees in department 50 will have a NULL department_id.

The DELETE statement will fail with an ORA-02292 error.

The DELETE statement will succeed, and the foreign key constraint will be automatically disabled.