Which statement is true regarding the UNION operator?

Which statement is true regarding the UNION operator?
A. The number of columns selected in all SELECT statements need to be the same
B. Names of all columns must be identical across all SELECT statements
C. By default, the output is not sorted
D. NULL values are not ignored during duplicate checking

Download Printable PDF. VALID exam to help you PASS.

5 thoughts on “Which statement is true regarding the UNION operator?

  1. AD correct answers

    NULLs are not ignored during duplicate checking. Fact check below

    select NULL , 1 from dual
    UNION
    select NULL, 1 from dual;

Leave a Reply

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


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