OCP CBT Question 554

Please solve the following question.

The `employees` table has a `commission_pct` column that allows NULL values, but the `department_id` column is defined as `NOT NULL`. Examine the following statement: ```sql UPDATE employees SET commission_pct = NULL, department_id = NULL WHERE employee_id = 100; ``` Which statement describes the outcome if `employee_id = 100` exists?

The statement will succeed, setting both commission_pct and department_id to NULL.

The statement will succeed for commission_pct but fail for department_id with an ORA-01407 error.

The entire statement will fail with an ORA-01407 error due to the department_id update.

The statement will succeed if employee_id = 100 currently has a NULL department_id.