Which statement is true regarding the INTERSECT operator?()
A:It ignores NULL values 
B:Reversing the order of the intersected tables alters the result 
C:The names of columns in all SELECT statements must be identical 
D:The number of columns and data types must be identical for all SELECT statements in the query 
出自:Oracle认证