Home » MCQs » Oracle MCQs » Oracle Operators MCQs

Which of the following statement is TRUE? (Oracle Clause MCQ 11)

11. Which of the following statement is TRUE?

1. Duplicates are removed by the UNION ALL operator but not by the UNION operator.
2. Duplicates are removed by the UNION operator but not by the UNION ALL operator.
3. Duplicates are removed by the UNION ALL operator.
4. Duplicates are not removed by the UNION operator.

Answer: B) Duplicates are removed by the UNION operator but not by the UNION ALL operator

Explanation:

Duplicates are removed by the UNION operator but not by the UNION ALL operator.