Home » MCQs » SQL MCQs » SQL SET Operators MCQs

What is TRUE about UNION ALL Operator?

5. What is TRUE about UNION ALL Operator?

1. The results of both queries are combined with this operator.
2. After performing the UNION ALL operation, duplicate rows will not be removed.
3. Both A and B
4. None of the above

Answer: C) Both A and B

Explanation:

In the case of UNION ALL Operator –

1. The results of both queries are combined with this operator.
2. After performing the UNION ALL operation, duplicate rows will not be removed.