ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-071 All Questions

View all questions & answers for the 1z0-071 exam
Go to Exam

Exam 1z0-071 topic 1 question 85 discussion

Actual exam question from Oracle's 1z0-071
Question #: 85
Topic #: 1
[All 1z0-071 Questions]

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

  • A. It must be an equijoin.
  • B. The ON clause must be used.
  • C. It must be an inner join.
  • D. It can be an outer join.
  • E. The ON clause can be used.
  • F. The query must use two different aliases for the table.
Show Suggested Answer Hide Answer
Suggested Answer: DEF 🗳️
by Leo1212 at Dec. 26, 2023, 7:55 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
kay000001
2 months, 2 weeks ago
Selected Answer: BDF
Answer is B, D, F. It cannot be E. 'On' clause Must be used.
upvoted 1 times
...
ShahedOdeh
3 months, 3 weeks ago
D , E and F
upvoted 1 times
...
yaya32
12 months ago
Selected Answer: DEF
DEF for me
upvoted 2 times
...
yanoolthecool
1 year ago
DEF, D says CAN
upvoted 1 times
Nico_Nikko
10 months, 2 weeks ago
It can never be an outer JOIN though, because you are JOINing Data with itsself it will always be as if you would use INTERSECT as all Data of 1 Table exists in the other. Therefore it must be an inner JOIN. Also regarding F, you can just give one of the tables an alias, the other one does not need one, while both have different names then, they technically do not have different aliases, which leads me to choose C and E. The rest seems wrong to me.
upvoted 1 times
...
...
Leo1212
1 year ago
Selected Answer: BCF
not sure why ain't like this
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago