View the Exhibit and examine the structures of the employees and departments tables. You want to update the employees table as follows:

Update only those employees who work in Boston or Seattle (locations

2900 and 2700).

Set department_id for these employees to the department_id

corresponding to London (location_id 2100).

Set the employees' salary in iocation_id 2100 to 1.1 times the

average salary of their department.

Set the employees' commission in iocation_id 2100 to 1.5 times the

average commission of their department. You issue the following command:

What is the outcome?

Question

View the Exhibit and examine the structures of the employees and departments tables. You want to update the employees table as follows:

2900 and 2700).

corresponding to London (location_id 2100).

average salary of their department.

average commission of their department. You issue the following command:

What is the outcome?

Accepted Answer

B. It executes successfully but does not give the correct result.

Answer

A. It executes successfully and gives the correct result.

Answer

C. It generates an error because a subquery cannot have a join condition in an update statement.

Answer

D. It generates an error because multiple columns (SALARY, COMMISSION) cannot be specified together in

View the Exhibit and examine the structures of the employees and departments tables. You want to update the employees table as follows: - Update only those employees who work in Boston or Seattle…