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