A UNION of two or more queries is valid provided the queries meet which of the following conditions? (Choose 3)

  1. All select lists in the UNION must have the same number of expressions

  2. Corresponding columns must have the same column names

  3. Corresponding columns must be of the same datatype or the server must be able to implicitly convert them

  4. Corresponding columns must be in the same order


Correct Option: A,C,D

Find more quizzes: