OCP CBT Question 546

Please solve the following question.

Examine the following SQL statements: ```sql UPDATE employees SET salary = (SELECT salary FROM employees WHERE employee_id = 100) WHERE department_id = 90; ``` Which statement describes the outcome of this DML operation?

All employees in department 90 will have their salary set to the current salary of the employee with employee_id 100.

The statement will fail if employee_id 100 does not exist in the employees table.

Only the employee with employee_id 100 will have their salary updated if they are in department 90.

The statement will increase the salary of employees in department 90 by the salary of employee_id 100.