Oracle

1Z0-082 · Question #49

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

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

SQL and PL/SQL

Question

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

Options

AMultiple INTERSECT operators are not possible in the same SQL statement
BIt processes NULLs in the selected columns
CINTERSECT is of lower precedence than UNION or UNION ALL
DIt ignores NULLs

How the community answered

(44 responses)

A
7% (3)
B
75% (33)
C
14% (6)
D
5% (2)

Topics

#INTERSECT operator#set operators#NULL handling#compound queries

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-082 Practice