Oracle
1Z0-082 · Question #62
Which three statements are true about a self join? (Choose three.)
The correct answer is B. The query must use two different aliases for the table D. It must be an inner join E. The ON clause can be used. See the full explanation below for the reasoning.
SQL and PL/SQL
Question
Which three statements are true about a self join? (Choose three.)
Options
- AThe ON clause must be used
- BThe query must use two different aliases for the table
- CIt must be an equijoin
- DIt must be an inner join
- EThe ON clause can be used
- FIt can be an outer join
How the community answered
(27 responses)- A4% (1)
- B81% (22)
- C11% (3)
- F4% (1)
Topics
#self join#table aliases#inner join#outer join
Community Discussion
No community discussion yet for this question.