OCP CBT Question 552

Please solve the following question.

You execute the following statement in Session A: ```sql SELECT employee_id, salary FROM employees WHERE department_id = 50 FOR UPDATE OF salary; ``` Immediately after this, in Session B, you try to execute: ```sql UPDATE employees SET salary = salary * 1.05 WHERE department_id = 50; ``` What is the most likely outcome of the `UPDATE` statement in Session B?

The UPDATE statement in Session B will immediately succeed.

The UPDATE statement in Session B will fail with a 'resource busy' or deadlock error.

The UPDATE statement in Session B will wait until Session A commits or rolls back its transaction.

The UPDATE statement in Session B will only update rows not selected by Session A.