ocp考试题库下载：11g-v9.02-051-130题
来源：优技教育
ocp考试题库下载：11g-v9.02-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
精华阅读