Exam 1z0-071 Topic 9 Question 242 Discussion

Actual exam question for Oracle's 1z0-071 exam
Question #: 242
Topic #: 9

Examine the structure of the EMPLOYEEStable:

There is a parent/child relationship between EMPLOYEE_IDand MANAGER_ID.
You want to display the name, joining date, and manager for all employees. Newly hired employees are yet to be assigned a department or a manager. For them, 'No Manager' should be displayed in the MANAGERcolumn.
Which SQL query gets the required output?
SELECT e.last_name, e.hire_date, NVL(m.last_name, 'No Manager') Manager

A. FROM employees e NATURAL JOIN employees m
ON (e.manager_id = m.employee_id). B. FROM employees e JOIN employees m
ON (e.manager_id = m.employee_id);
SELECT e.last_name, e.hire_date, NVL(m.last_name, 'No Manager') Manager C. FROM employees e LEFT OUTER JOIN employees m
ON (e.manager_id = m.employee_id);
SELECT e.last_name, e.hire_date, NVL(m.last_name, 'No Manager') Manager D. FROM employees e RIGHT OUTER JOIN employees m
ON (e.manager_id = m.employee_id);
SELECT e.last_name, e.hire_date, NVL(m.last_name, 'No Manager') Manager

Comments

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business