Oracle Database SQL — Question 106

Which statement is true about the INTERSECT operator used in compound queries?

Answer options

• A. It processes NULLs in the selected columns.
• B. It ignores NULLs.
• C. INTERSECT is of lower precedence than UNION or UNION ALL.
• D. Multiple INTERSECT operators are not possible in the same SQL statement.

Correct answer: A

Explanation

The correct answer, A, is true because the INTERSECT operator does consider NULL values when determining the result set. Option B is incorrect as INTERSECT does not ignore NULLs. Option C is false because INTERSECT actually has higher precedence than UNION or UNION ALL. Lastly, option D is incorrect since multiple INTERSECT operators can be used in the same SQL statement.