Home » MCQs » Oracle MCQs » Oracle Operators MCQs

By contrast, UNION ALL does not ____ duplicate rows between several SELECT statements, which is what sets it apart from the UNION operator

9. By contrast, UNION ALL does not ____ duplicate rows between several SELECT statements, which is what sets it apart from the UNION operator.

1. Add
2. Update
3. Remove
4. None

Answer: C) Remove

Explanation:

By contrast, UNION ALL does not remove duplicate rows between several SELECT statements, which is what sets it apart from the UNION operator.