（130）View the Exhibit and examine the data in the EMPLOYEES table:

You want to display all the employee names and their corresponding manager names. Evaluate the following query:

SELECT e.employee_name "EMP NAME", m.employee_name "MGR NAME" FROM employees e employees m

ON e.manager_id = m.employee_id;

Which JOIN option can be used in the blank in the above query to get the required output?

A. only inner JOIN

B. only FULL OUTER JOIN

C. only LEFT OUTER JOIN

D. only RIGHT OUTER JOIN

答案（C）

ITPub博客

OCP 1Z0-051-130