Which two statements are true regarding the UNION and UNION ALL operators?

Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)
A. The output is sorted by the UNION ALL operator
B. The names of columns selected in each SELECT statement must be identical
C. The number of columns selected in each SELECT statement must be identical
D. Duplicates are eliminated automatically by the UNION ALL operator
E. NULLS are not ignored during duplicate checking

Download Printable PDF. VALID exam to help you PASS.

One thought on “Which two statements are true regarding the UNION and UNION ALL operators?

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.