Oracle
1Z0-061 · Question #24
1Z0-061 Question #24: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #24. The question stem and answer options stay visible for context.
Question
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?
Exhibits
Options
- AIt executes successfully and gives the correct result.
- BIt executes successfully but does not give the correct result.
- CIt generates an error because a subquery cannot have a join condition in an update statement.
- DIt generates an error because multiple columns (SALARY, COMMISSION) cannot be specified together in
Unlock 1Z0-061 to see the answer
You've previewed enough free 1Z0-061 questions. Unlock 1Z0-061 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.