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

© examsiri.com

Question : 28 of 57

Marks: +1, -0

Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

The output is sorted by the UNION ALL operator
The names of columns selected in each SELECT statement must be identical
The number of columns selected in each SELECT statement must be identical
Duplicates are eliminated automatically by the UNION ALL operator
NULLS are not ignored during duplicate checking

Go to Question:

Prev Question

Next Question