Question:
Difference between UNION and UNION ALL:

Option A):
UNION returns only unique records from both tables. UNION ALL returns all records from both tables.
Option B):
UNION ALL is no longer supported in sql server 2000 onward.
Option C):
Both are similar

Correct Answer is Option A):
UNION returns only unique records from both tables. UNION ALL returns all records from both tables.