Oracle
1Z0-007 · Question #54
1Z0-007 Question #54: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-007 to reveal the answer and full explanation for question #54. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-007 to see the answer
You've previewed enough free 1Z0-007 questions. Unlock 1Z0-007 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.