Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

Question

Options

• AThe data type group of each column returned by the second query must match the data type of
• BThe number, but not names, of columns must be identical for all SELECT statements in the
• CThe data type of each column returned by the second query must exactly match the data type of
• DThe names and number of columns must be identical for all SELECT statements in the query.
• EThe data type of each column returned by the second query must be implicitly convertible to the

• A
  76% (37)
• B
  14% (7)
• D
  4% (2)
• E
  6% (3)

No community discussion yet for this question.