Home » MCQs » Oracle MCQs » Oracle Intersect and Minus Operators MCQs

INTERSECT Operators return the results of multiple SELECT statements in Oracle

2. INTERSECT Operators return the results of multiple SELECT statements in Oracle.

1. expression1, expression2, ... expression_n
2. table1, table2
3. Conditions
4. All of the above

Answer: D) All of the above

Explanation:

The parameters in the syntax of Oracle INTERSECT Operator -

1. expression1, expression2, ... expression_n
2. table1, table2
3. Conditions