D. It can be an outer join.
True: A self join can indeed be an outer join. For example, you can use a left outer join or a right outer join when joining a table to itself, allowing you to retain unmatched rows from one of the instances of the table.
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.
This section is not available anymore. Please use the main Exam Page.1z0-071 Exam Questions
Log in to ExamTopics
Sign in:
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.
826cb95
4 days, 15 hours agokay000001
6 months, 1 week agoShahedOdeh
7 months, 2 weeks agoyaya32
1 year, 3 months agoyanoolthecool
1 year, 4 months agoNico_Nikko
1 year, 1 month agoLeo1212
1 year, 4 months ago