Exam 1z0-071 All QuestionsBrowse all questions from this exam
Question 216

Which two are true about self joins? (Choose two.)

    Correct Answer: A, D

    Self joins can indeed use different types of joins such as INNER JOIN and LEFT JOIN. This allows for flexible querying depending on the needs of the analysis. Additionally, self joins require the use of table aliases to differentiate between the instances of the same table within the query. This is crucial to avoid confusion and maintain clarity in the SQL statements.

Discussion
yaya32Options: AD

AD is correct

lucemqyOptions: AD

AD is correct