Q61 Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)
- (A). Column names in each SELECT in the compound query can be different
- (B). The number of columns in each SELECT in the compound query can be different
- (C). Reversing the order of the intersected tables can sometimes affect the output
- (D). INTERSECT returns rows common to both sides of the compound query
- (E). INTERSECT ignores NULLs
Answer: A,D
https://www.oracletutorial.com/oracle-basics/oracle-intersect/