Oracle
1Z0-061 · Question #215
1Z0-061 Question #215: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #215. The question stem and answer options stay visible for context.
Question
EMPLOYEES and DEPARTMENTS data: EMPLOYEES DEPARTMENTS 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?
Exhibits
Options
- AThe statement executes successfully, leaves the manager ID as the existing value, and changes
- BThe statement executes successfully, changes the manager ID to NULL, and changes the salary
- CThe statement executes successfully, changes the manager ID to NULL, and changes the salary
- 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.
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.