Oracle Database Administration I — Question 59

Which three statements are true about a self join? (Choose three.)

Answer options

• A. The ON clause must be used
• B. The query must use two different aliases for the table
• C. It must be an equijoin
• D. It must be an inner join
• E. The ON clause can be used
• F. It can be an outer join

Correct answer: B, E, F

Explanation

The correct answers B, E, and F highlight that a self join can use two different aliases, the ON clause is optional, and it can also be an outer join. Options A, C, and D are incorrect because the ON clause is not mandatory, a self join does not have to be an equijoin, and it is not restricted to only inner joins.