Oracle
1Z0-082 · Question #100
Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)
The correct answer is A. Column names in each SELECT in the compound query can be different E. INTERSECT ignores NULLs. See the full explanation below for the reasoning.
SQL and PL/SQL
Question
Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)
Options
- AColumn names in each SELECT in the compound query can be different
- BThe number of columns in each SELECT in the compound query can be different
- CReversing the order of the intersected tables can sometimes affect the output
- DINTERSECT returns rows common to both sides of the compound query
- EINTERSECT ignores NULLs
How the community answered
(30 responses)- A83% (25)
- B3% (1)
- C10% (3)
- D3% (1)
Topics
#INTERSECT operator#compound queries#set operators#NULL handling
Community Discussion
No community discussion yet for this question.