Oracle
1Z0-071 · Question #297
Which statement is true about the INTERSECT operator used in compound queries?
The correct answer is D. It processes NULLs in the selected columns. See the full explanation below for the reasoning.
Question
Which statement is true about the INTERSECT operator used in compound queries?
Options
- AINTERSECT is of lower precedence than UNION or UNION ALL.
- BMultiple INTERSECT operators are not possible in the same SQL statement.
- CIt ignores NULLs.
- DIt processes NULLs in the selected columns.
How the community answered
(37 responses)- A5% (2)
- B11% (4)
- C3% (1)
- D81% (30)
Community Discussion
No community discussion yet for this question.