1Z0-007 · Question #13
1Z0-007 Question #13: Real Exam Question with Answer & Explanation
The correct answer is C. SELECT e.employee_id "Emp_id", e.emp_name "Employee",. This statement lists the ID, name, and salary of the employee, and the ID and name of the employee's manager, for all the employees who have a manager and earn more than 4000 Incorrect Answers A: This statement does not check does employee have a manager or not, so it will not pr
Question
Exhibit
Options
- ASELECT employee_id "Emp_id", emp_name "Employee",
- BSELECT e.employee_id "Emp_id", e.emp_name "Employee",
- CSELECT e.employee_id "Emp_id", e.emp_name "Employee",
- DSELECT e.employee_id "Emp_id", e.emp_name "Employee",
- ESELECT e.employee_id "Emp_id", e.emp_name "Employee",
Explanation
This statement lists the ID, name, and salary of the employee, and the ID and name of the employee's manager, for all the employees who have a manager and earn more than 4000 Incorrect Answers A: This statement does not check does employee have a manager or not, so it will not provide B: Usage of "e.mgr_id = m.mgr_id" condition is wrong to achieve required result. D: This statement uses "m.mgr_id" to show manager's manager, not employ's manager. E: Usage of "WHERE E.employee_id = m.employee_id" condition is wrong to achieve required result.
Community Discussion
No community discussion yet for this question.