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

Question

Options

• AThe number, but not names, of columns must be identical for all SELECT statements in the
• BThe data type of each column returned by the second query must be implicitly convertible to the
• CThe data type group of each column returned by the second query must match the data type
• 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 exactly match the data type of

• A
  17% (8)
• B
  4% (2)
• C
  70% (33)
• D
  9% (4)

No community discussion yet for this question.