What is the difference between UNION and UNION ALL in SQL?

Question Explain

This question evaluates knowledge of set operations and their performance implications.