1Z0-071 practice question 20 of 35
Which two are true about self joins?
Full set: 326 questionsA self-join is a join of a table to itself. To distinguish between the two instances of the table in the query, table aliases are mandatory to avoid ambiguous column references. Since a self-join is fundamentally a join operation, it can be performed using any standard join type, such as INNER JOIN or any of the OUTER JOIN variations (LEFT, RIGHT, FULL), depending on the desired logic for handling matching and non-matching rows.
A. Self-joins are not always equijoins; they can use non-equijoin conditions (e.g., >, <, BETWEEN) to compare rows within the same table.
B. The NOT EXISTS operator is not a requirement for a self-join; it is a subquery operator used for different logical checks.
C. A self-join, like any other join, requires a join condition to relate the rows from the two instances of the table.
F. The EXISTS operator is not a requirement for a self-join. It is a subquery operator.
1. Oracle Database SQL Language Reference, 19c, "joinclause". The documentation defines a self-join: "A self join is a join of a table to itself. This table appears twice in the FROM clause and is followed by table aliases that qualify column names in the join condition."
2. Oracle Database Concepts, 19c, "Joins". The chapter on joins explains the different types, including inner and outer joins, which are applicable to any join scenario, including self-joins.
Keep practicing
Take the free 1Z0-071 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-071 practice questions
- Question 2Which three statements are true about single row functions?
- Question 3Which statement executes successfully?
- Question 4Which two are true about transactions in the Oracle Database?
- Question 6Which two are true about external tables that use the ORACLE _DATAPUMP access driver?
- Question 9Which statement will execute successfully?
- Question 10Examine this statement: CREATE TABTE orders (sarial_no NUMBER UNIQUE, order_id NUMBER PRI…
