Oracle
1Z0-071 · Question #272
Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)
The correct answer is A. INTERSECT ignores NULLs. E. Column names in each SELECT in the compound query can be different. See the full explanation below for the reasoning.
Question
Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)
Options
- AINTERSECT ignores NULLs.
- BReversing the order of the intersected tables can sometimes affect the output.
- CThe number of columns in each SELECT in the compound query can be different.
- DINTERSECT returns rows common to both sides of the compound query.
- EColumn names in each SELECT in the compound query can be different.
How the community answered
(22 responses)- A82% (18)
- B9% (2)
- C5% (1)
- D5% (1)
Community Discussion
No community discussion yet for this question.