1Z0-047 · Question #5
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…
The correct answer is A. It would execute successfully and update the relevant data. See the full explanation below for the reasoning.
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
How the community answered
(18 responses)- A72% (13)
- B6% (1)
- C11% (2)
- D11% (2)
Community Discussion
No community discussion yet for this question.