Test Index

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

© examsnet.com

Question : 7

Total: 50

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