In which case would you use a FULL OUTER JOIN?

Question

Options

• ABoth tables have NULL values.
• BYou want all unmatched data from one table.
• CYou want all matched data from both tables.
• DYou want all unmatched data from both tables.
• EOne of the tables has more data than the other.
• FYou want all matched and unmatched data from only one table.

• B
  4% (1)
• C
  9% (2)
• D
  83% (19)
• F
  4% (1)

Explanation

Oracle9i also makes it possible for you to easily execute a full outer join, including all records from the tables that would have been displayed if you had used both LEFT OUTER JOIN or RIGTH OUTER JOIN clauses. Incorrect Answers A: You will not use a FULL OUTER JOIN if both tables have NULL values. B: You will not use a FULL OUTER JOIN if you want all unmatched data from one table. Only LEFT OUTER JOIN or RIGTH OUTER JOIN needs to be used. C: You want all unmatched, not matched, data from both tables. E: It is not a criterion to use a FULL OUTER JOIN if one of the tables has more data than the F: You want all unmatched, not matched data or a combination of matched and unmatched data, from both tables, not one table.

No community discussion yet for this question.