Home » Oracle » 1z0-071 v.2 » Which statement is true regarding the INTERSECT operator?
Which statement is true regarding the INTERSECT operator?
A. The names of columns in all SELECT statements must be identical.
B. It ignores NULL values.
C. Reversing the order of the intersected tables alters the result.
D. The number of columns and data types must be identical for all SELECT statements in the query.
Correct Answer: D
Explanation/Reference:
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.
References:
http://oraclexpert.com/using-the-set-operators/
Download Printable PDF. VALID exam to help you PASS.
|
|