Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

The correct answer is B. The number of columns selected in each SELECT statement must be identical E. NULLS are not ignored during duplicate checking. See the full explanation below for the reasoning.

SQL and PL/SQL

Question

Options

ADuplicates are eliminated automatically by the UNION ALL operator
BThe number of columns selected in each SELECT statement must be identical
CThe names of columns selected in each SELECT statement must be identical
DThe output is sorted by the UNION ALL operator
ENULLS are not ignored during duplicate checking

How the community answered

(25 responses)

A
4% (1)
B
76% (19)
C
16% (4)
D
4% (1)

Topics

#UNION#UNION ALL#set operators#duplicate elimination

Community Discussion

No community discussion yet for this question.

Full 1Z0-082 Practice