Shell Database Tester Interview Questions and Answers

Union combines and removes duplicates, Union All combines without removing duplicates.

• Union combines result sets and removes duplicates

• Union All combines result sets without removing duplicates

• Union is slower than Union All as it involves removing duplicates

• Union requires sorting while Union All does not