Which statement is true regarding the INTERSECT operator?
A.
The names of columns in all SELECT statements must be identical
B.
Reversing the order of the intersected tables the result
C.
It ignores NULL values
D.
The number of columns and data types must be identical for all SELECT statements in
the query
Debatable “…identical for all SELECT statements in”
Can’t I have a subquery with “select ‘abc’ from dual” as a column constant value?
D.