Oracle
1Z0-047 · Question #215
1Z0-047 Question #215: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #215. 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_jd = (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_jd = 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 table.
- CIt would not execute successfully because the condition specified with the concatenation operator is
- DIt would not execute successfully because multiple columns (SALARY,COMMISSION_PCT)cannot be
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.