Multiple choice technology databases

Which of the following will automatically order the result.

  1. Union All

  2. Distinct

  3. Unique

  4. Intersect

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The INTERSECT operator in SQL automatically sorts the final result set to eliminate duplicates and find common rows. UNION ALL, DISTINCT, and UNIQUE do not inherently guarantee sorted order.