1Z0-071 practice question 29 of 35

Which two statements are true about outer Joins?

Full set: 326 questions
Answer options
A: The outer join operator (+) can be used on both sides of the join condition in an outer join.
B: An outer join is used to retrieve only the rows that do not meet the join condition.
C: The IN operator cannot be used in a condition that Involves an outer join.
D: A condition representing an outer join cannot be linked to another condition using the or logical operator. Correct answer
E: The outer join operator (+) is used next to the column of the table without the matching rows. Correct answer
Correct Answer:
D. A condition representing an outer join cannot be linked to another condition using the or logical operator.; E. The outer join operator (+) is used next to the column of the table without the matching rows.
Explanation

In Oracle's proprietary outer join syntax using the (+) operator, strict rules apply. The (+) operator must be placed next to the column from the table that might have missing rows (the "deficient" side). Additionally, conditions containing the outer join operator cannot be combined with OR operators, as this would violate the outer join semantics and result in an ORA-01719 error.

Why Incorrect

A. The (+) operator cannot appear on both sides - this causes ORA-01468 error.
B. Outer joins retrieve all matching rows PLUS non-matching rows from one table.
C. The IN operator can be used with outer joins when properly formatted.

References

1. Oracle Database SQL Language Reference 12c, "Joins" section, specifically "Oracle Join Operator" subsection

2. Oracle Database 12c: SQL Fundamentals, Oracle University courseware, Module on "Displaying Data from Multiple Tables"

3. "Oracle Database SQL Language Reference 19c", Section 9 "SQL Queries and Subqueries", Outer Join restrictions

4. Oracle Support Document ID 68979.1 "ORA-01719 When Using OR with Outer Join"

5. Oracle Database Concepts 12c, Chapter 7 "SQL", Join Conditions section

Scroll to Top