A. SELECT last_name, department_name FROM employees , departments(+); B. SELECT last_name, department_name FROM employees JOIN departments (+); C. SELECT last_name, department_name FROM employees(+) e JOIN departments d ON... more
A. SELECT last_name, department_name FROM employees , departments(+); B. SELECT last_name, department_name FROM employees JOIN departments (+); C. SELECT last_name, department_name FROM employees(+) e JOIN departments d ON (e.department_id = d.department_id); D. SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id); E. SELECT last_name, department_name FROM employees(+) , departments ON (e.department_id = d.department_id); F. SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e.department_id = d.department_id); Answer: F Explanation: Answer F is correct. This query shows correct syntax to retrieve all employees, whether or not they have matching departments in the department table. Oracle9i extends its compliance with ANSI/ISO by supporting that standard's requirements for outer join syntax and semantics. Incorrect Answers A: This query uses "+" to create outer join as it was in Oracle8i, but it requires also usage of WHERE clause in SELECT statement. B: The JOIN clause cannot be used with in conjunction with "+": syntax is incorrect.
