<<< Previous question <<< Question ID#0249.md >>> Next question >>>
You work as a Database Administrator for Dolliver Inc. The company uses an Oracle database. The database contains two tables, named Employees and Departments. You want to retrieve all matched and unmatched rows from both the tables. Which of the following types of joins will you use to accomplish this?
- A) FULL OUTER JOIN
- B) LEFT OUTER JOIN
- C) CROSS JOIN
- D) RIGHT OUTER JOIN
Answer
Answer: A