Oracle
1Z0-071 · Question #308
Which two statements are true about a self join? (Choose two.)
The correct answer is C. It can be an inner join. E. The join key column must have an index. See the full explanation below for the reasoning.
Question
Which two statements are true about a self join? (Choose two.)
Options
- AIt can be a left outer join.
- BIt must be a full outer join.
- CIt can be an inner join.
- DIt must be an equijoin.
- EThe join key column must have an index.
How the community answered
(42 responses)- A14% (6)
- B2% (1)
- C79% (33)
- D5% (2)
Community Discussion
No community discussion yet for this question.