【单项选择题】
Examine the data in the EMPLOYEES and DEPARTMENTS tables.<br /> EMPLOYEES<br /> LAST_NAME DEPARTMENT_ID SALARY<br /> Getz 10 3000<br /> Davis 20 1500<br /> Bill 20 2200<br /> Davis 30 5000<br /> Kochhar 5000<br /> DEPARTMENTS<br /> DEPARTMENT_ID DEPARTMENT_NAME<br /> 10 Sales<br /> 20 Marketing<br /> 30 Accounts<br /> 40 Administration<br /> You want to retrieve all employees, whether or not they have matching departments in the departments table.<br /> Which query would you use?（）<p> Examine the data in the EMPLOYEES and DEPARTMENTS tables.<br /> EMPLOYEES<br /> LAST_NAME DEPARTMENT_ID SALARY<br /> Getz 10 3000<br /> Davis 20 1500<br /> Bill 20 2200<br /> Davis 30 5000<br /> Kochhar 5000<br /> DEPARTMENTS<br /> DEPARTMENT_ID DEPARTMENT_NAME<br /> 10 Sales<br /> 20 Marketing<br /> 30 Accounts<br /> 40 Administration<br /> You want to retrieve all employees, whether or not they have matching departments in the departments table.<br /> Which query would you use?（）</p>
A、A. SELECT last_name, department_name FROM employees , departments(+);
B、B. SELECT last_name, department_name FROM employees JOIN departments(+);
C、C. SELECT last_name, department_name ON (e. department_ id = d. departments_id); FROM employees(+) e JOIN departments d
D、D. SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);
E、E. SELECT last_name, department_name FROM employees(+) , departments ON (e. department _ id = d. department _id);
F、F. SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e. department _ id = d. department _id);
查看正确答案
