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?
A.
It executes successfully and gives the correct result.
B.
It executes successfully but does not give the correct result.
C.
It generates an error because a subquery cannot have a join condition in an update
statement.
D.
It generates an error because multiple columns (SALARY, COMMISSION) cannot be
specified together in an update statement.