Which three are true regarding the use of outer joins? (Choose three.)

Question

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.

• A
  16% (4)
• B
  8% (2)
• C
  4% (1)
• D
  72% (18)

Explanation

You can use an outerjoin to see only the rows that do not meet the join condition. In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin. You cannot link a condition that is involved in an outerjoin to another condition by using the OR Incorrect Answers A: You can use IN operator in a condition that involves an outerjoin. B: You use (+) following the name of the column in the table without matching rows, but not on both sides of the WHERE condition to perform an outerjoin. C: You don't use (*) to define outerjoin operation.

No community discussion yet for this question.