1Z0-071 practice question 29 of 35
Which two statements are true about outer Joins?
Full set: 326 questionsIn 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.
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.
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
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…
