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 the result
Explanation:
INTERSECT Returns only the rows that occur in both queries result sets, sorting them and
removing duplicates.
The columns in the queries that make up a compound query can have different names, but the
output result set will use the names of the columns in the first query.
B. Datatype don’t have to be identical, but same datatype.
It ignores null values, right?
It does not ignore the null values. A Null value will be included