Oracle Database SQL 12c 1z0-071 Exam Practice Test 1

© examsiri.com

Question : 38 of 50

Marks: +1, -0

Which statement is true regarding the INTERSECT operator?

The names of columns in all SELECT statements must be identical.
It ignores NULL values.
Reversing the order of the intersected tables alters the result.
The number of columns and data types must be identical for all SELECT statements in the query.

Go to Question:

Prev Question

Next Question