A and D are the correct answers
A- SELF JOIN can be an INNER JOIN, as it uses the same principles as INNER JOIN to perform comparisons or find relationships between rows in the same table.
D- It is recommended to create indexes on the join columns to optimize queries with Self Join
I think this is true because we can use other join conditions and not necessarily an equality join (=).
You can also use any outer join to join the same table. (most probably using a non-equijoin operator)
in a self join the table is join with itself. Equijoin is the most common join used.
upvoted 1 times
...
...
...
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.
Rafafm
2 months, 4 weeks agoauwia
1 year, 6 months agomamadu
1 year, 6 months agoDarkseid1231
1 year, 6 months agoauwia
1 year, 6 months agoDarkseid1231
1 year, 6 months ago