Home » MCQs » MariaDB MCQs

Which MariaDB operator is used to combine the result sets of two or more SELECT statements without removing duplicate records?

34. Which MariaDB operator is used to combine the result sets of two or more SELECT statements without removing duplicate records?

1. UNION
2. UNION ALL
3. INTERSECT
4. None of the above

Answer: B) UNION ALL

Explanation:

The UNION ALL operator is used to combine the result sets of two or more SELECT statements without removing duplicate records.