1Z0-007 · Question #54
EMPLOYEES and DEPARTMENTS data: On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID managers and refers to the EMPLOYEE_ID. On the DEPARTMENTS table DEPARTMENT_ID is the primary…
The correct answer is D. The statement fails because there is more than one row matching the employee name Smith. '=' is use in the statement and subquery will return more than one row. Employees table has 2 row matching the employee name Smith. The update statement will fail.
Question
EMPLOYEES and DEPARTMENTS data:
On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID managers and refers to the EMPLOYEE_ID. On the DEPARTMENTS table DEPARTMENT_ID is the primary key. Evaluate this UPDATE statement. UPDATE employees SET mgr_id = (SELECT mgr_id FROM employees WHERE dept_id= (SELECT department_id FROM departments WHERE department_name = 'Administration')), Salary = (SELECT salary FROM employees WHERE emp_name = 'Smith') WHERE job_id = 'IT_ADMIN'; What happens when the statement is executed?
Exhibit
Options
- AThe statement executes successfully, leaves the manager ID as the existing value, and changes the
- BThe statement executes successfully, changes the manager ID to NULL, and changes the salary to
- CThe statement executes successfully, changes the manager ID to NULL, and changes the salary to
- DThe statement fails because there is more than one row matching the employee name Smith.
- EThe statement fails because there is more than one row matching the IT_ADMIN job ID in the
- FThe statement fails because there is no 'Administration' department in the DEPARTMENTS table.
How the community answered
(45 responses)- A11% (5)
- B2% (1)
- C4% (2)
- D80% (36)
- E2% (1)
Explanation
'=' is use in the statement and subquery will return more than one row. Employees table has 2 row matching the employee name Smith. The update statement will fail.
Topics
Community Discussion
No community discussion yet for this question.