OCP 11g认证考试题库：051-130题

OCP 11g认证考试题库：051-130题，完整题库请点击这里联系老师咨询了解

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:

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 above query 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

试题解析：

显示所有employee names和对应的manager names

此处e代表员工表，而m代表管理人员表，所有只有左连接才能显示 all the employee names