Which statement is true regarding the INTERSECT operator?

The correct answer is B. The number of columns and data types must be identical for all SELECT statements in the query. 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.

Using the SET Operators

Question

Options

AIt ignores NULL values
BThe number of columns and data types must be identical for all SELECT statements in the query
CThe names of columns in all SELECT statements must be identical
DReversing the order of the intersected tables the result

How the community answered

(37 responses)

A
3% (1)
B
73% (27)
C
16% (6)
D
8% (3)

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.

Topics

#INTERSECT operator#SET operators#column compatibility#NULL handling

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice