Oracle
1Z0-007 · Question #40
1Z0-007 Question #40: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-007 to reveal the answer and full explanation for question #40. The question stem and answer options stay visible for context.
Question
Which three are true regarding the use of outer joins? (Choose three.)
Options
- AYou cannot use IN operator in a condition that involves an outerjoin.
- BYou use (+) on both sides of the WHERE condition to perform an outerjoin.
- CYou use (*) on both sides of the WHERE condition to perform an outerjoin.
- DYou use an outerjoin to see only the rows that do not meet the join condition.
- EIn the WHERE condition, you use (+) following the name of the column in the table without matching
- FYou cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.
Unlock 1Z0-007 to see the answer
You've previewed enough free 1Z0-007 questions. Unlock 1Z0-007 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.