View the exhibit and examine the structures of the EMPLOYEES and DEPARTMENTS tables You want to update 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 location_id 2100 to 1.1 times the average salary of their department. Set the employees' commission in location_id 2100 to 1.5 times the average commission of their department You issue the following command: What is outcome?

Correct Answer is : It executes successfully but does not give the desired update

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

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

It executes successfully and gives the desired update

It executes successfully but does not give the desired update

Oracle Database SQL 12c 1z0-071 Exam Practice Test 1

Question : 7 of 50

Marks: +1, -0

View the exhibit and examine the structures of the EMPLOYEES and DEPARTMENTS tables

You want to update 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 location_id 2100 to 1.1 times the average salary of their department.
Set the employees' commission in location_id 2100 to 1.5 times the average commission of their department

You issue the following command:

What is outcome?

It generates an error because multiple columns (SALARY, COMMISSION) cannot be specified together in an UPDATE statement.
It generates an error because a subquery cannot have a join condition in a UPDATE statement.
It executes successfully and gives the desired update
It executes successfully but does not give the desired update

Go to Question:

Prev Question

Next Question