【2020年8月】Oracle OCP 071考试新题(-13题)CUUG内部题库

【2020年8月】Oracle OCP 071考试新题(-13题)CUUG内部题库

Choose the best answer.

Examine this statement which returns the name of each employee and their manager:

SELECT e.last_name AS emp, m.1ast_name AS mgr

FROM employees e

JOIN managers m

ON e.manager_id = m.employee_id

ORDER BY emp;

You want to extend the query to include employees with no manager. What must you add before JOIN to do this?

A) LEFT OUTER

B) RIGHT OUTER

C) CROSS

D) FULL OUTER

2020年8月份Oracle OCP 071考试新题-13题)CUUG内部题库，钉钉群(35277291)Oracle金牌名师亲自题库解析