Zend
ZF-100-500 · Question #54
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…
The correct answer is C. FULL OUTER JOIN. See the full explanation below for the reasoning.
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?
Options
- ARIGHT OUTER JOIN
- BLEFT OUTER JOIN
- CFULL OUTER JOIN
- DCROSS JOIN
How the community answered
(44 responses)- A5% (2)
- B2% (1)
- C84% (37)
- D9% (4)
Community Discussion
No community discussion yet for this question.