Oracle
1Z0-071 · Question #149
Which two are the minimal requirements for a self-join? (Choose two.)
The correct answer is C. There must be a condition on which the self-join is performed. E. The table used for the self-join must have two different alias names in the query. See the full explanation below for the reasoning.
Question
Which two are the minimal requirements for a self-join? (Choose two.)
Options
- AOnly equijoin conditions may be used in the query.
- BOuter joins must not be used in the query.
- CThere must be a condition on which the self-join is performed.
- DNo other condition except the self-join may be specified.
- EThe table used for the self-join must have two different alias names in the query.
How the community answered
(63 responses)- A3% (2)
- B11% (7)
- C79% (50)
- D6% (4)
Community Discussion
No community discussion yet for this question.