1z0-071 Oracle Database 12c SQL 第62题 INTERSECT交叉查询

Q62. Which statement is true regarding the INTERSECT operator?
A. It ignores NULL values.
B.The number of columns and data types must be identical for all SELECT statements in the query.
C. The names of columns in all SELECT statements must be identical. 

D. Reversing the order of the intersected tables alters the result.

Correct Answer: B
Explanation/Reference:
References:
http://oraclexpert.com/using-the-set-operators/