Oracle
1Z0-146 · Question #81
In which situation should you use an outer join query?
The correct answer is D. The employee table column corresponding to the region table column contains null values for rows. See the full explanation below for the reasoning.
Question
In which situation should you use an outer join query?
Options
- AThe employee table has two columns that correspond.
- BThe employee and region tables have corresponding columns.
- CThe employee and region tables have no corresponding columns.
- DThe employee table column corresponding to the region table column contains null values for rows
How the community answered
(23 responses)- A4% (1)
- B9% (2)
- C17% (4)
- D70% (16)
Community Discussion
No community discussion yet for this question.