OCP-1Z0-051-V9.02-130题

130. View the Exhibit and examine the data in theEMPLOYEES table:

You want to display all the employee names and their corresponding manager names.

Evaluate the following query:

SQL> 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 abovequery to get the required output? 

A. o nly inner JOIN

B. only FULL OUTER JOIN

C. only LEFT OUTER JOIN

D. only RIGHT OUTER JOIN

Answer:C

答案解析：

1、left join :select e.employee_name "EMP NAME",e.employee_id EMNUM,m.employee_name "MGR NAME",m.employee_id MGNUM from employees e left join employees m

on e.employee_id = m.manager_id; 

    上面的SQL语句中，e代表员工表，而m代表经理表，连接条件e.manager_id= m.employee_id,也就是以员工表的员工为基准，找出他们各自的经理。

    e.employee_id = m.manager_id和e.manager_id = m.employee_id一样的。

2、right join :select e.employee_name "EMP NAME",e.employee_id EMNUM,m.employee_name "MGR NAME",m.employee_id MGNUM from employees e right join employees m

on e.manager_id = m.employee_id;