Oracle
1Z0-071 · Question #339
Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)
The correct answer is C. 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.
Question
Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)
Options
- AThe output is sorted by the UNION ALL operator
- BThe names of columns selected in each SELECT statement must be identical
- CThe number of columns selected in each SELECT statement must be identical
- DDuplicates are eliminated automatically by the UNION ALL operator
- ENULLS are not ignored during duplicate checking
How the community answered
(45 responses)- A7% (3)
- B2% (1)
- C78% (35)
- D13% (6)
Community Discussion
No community discussion yet for this question.