Oracle
1Z0-047 · Question #5
1Z0-047 Question #5: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #5. The question stem and answer options stay visible for context.
Question
View the Exhibit and examine the data in EMPLOYEES and DEPARTMENTS tables. In the EMPLOYEES table EMPLOYEE_ID is the PRIMARY KEY and DEPARTMENT_ID is the FOREIGN KEY. In the DEPARTMENTS table DEPARTMENT_ID is the PRIMARY KEY. Evaluate the following UPDATE statement: UPDATE employees a SET department_id = (SELECT department_id FROM departments WHERE location_id = '2100'), (salary, commission_pct) = (SELECT 1.1AVG(salary), 1.5AVG(commission_pct) FROM employees b WHERE a.department_id = b.department_id) WHERE first_name||' '||last_name = 'Amit Banda'; What would be the outcome of the above statement?
Exhibit
Options
- AIt would execute successfully and update the relevant data.
- BIt would not execute successfully because there is no LOCATION_ID 2100 in the DEPARTMENTS
- CIt would not execute successfully because the condition specified with the concatenation operator
- DIt would not execute successfully because multiple columns (SALARY,COMMISSION_PCT)cannot
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 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.