Oracle Exam 1Z0-071 Topic 7 Question 5 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 5
Topic #: 7

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?

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

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

CIt executes successfully and gives the desired update.

DIt executes successfully but does not give the desired update.

Show Suggested Answer

Suggested Answer: D

by Marjory at May 04, 2022, 02:17 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!