nerdexam
Oracle

1Z0-071 · Question #297

Which statement is true about the INTERSECT operator used in compound queries?

The correct answer is D. It processes NULLs in the selected columns. See the full explanation below for the reasoning.

Question

Which statement is true about the INTERSECT operator used in compound queries?

Options

  • AINTERSECT is of lower precedence than UNION or UNION ALL.
  • BMultiple INTERSECT operators are not possible in the same SQL statement.
  • CIt ignores NULLs.
  • DIt processes NULLs in the selected columns.

How the community answered

(37 responses)
  • A
    5% (2)
  • B
    11% (4)
  • C
    3% (1)
  • D
    81% (30)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice