Multiple choice technology databases

Choose the correct statements about the union clause in ASE (Choose 2)

  1. Duplicate rows are removed from the result set by default

  2. ASE evaluates a statement containing union operators from left to right

  3. Order by and group by clauses are not allowed in a union query

  4. The into clause can be used only in the first query
Reveal answer Fill a bubble to check yourself
A,B,D Correct answer
Explanation

In ASE, UNION removes duplicate rows by default (A), evaluates left-to-right (B), and allows INTO clause only in the first query to specify the result table (D). ORDER BY and GROUP BY are allowed (C is false).

Keep practicing — related questions