Exam 1z0-882 topic 1 question 21 discussion

Actual exam question from Oracle's 1z0-882

Question #: 21
Topic #: 1

A table (t1) contains 1000 random integer values in the first column (col1).The random values are in the range of 0-1000.
Examine this query:
SELECT col1 FROM t1 WHERE col1 <=100 UNION
SELECT col1 FROM t1 WHERE col1 >=900 ORDER BY col1 DESC
What is the expected output?

A. A list of all values, including duplicates, sorted in descending order in the ranges of 0-100 and 900-1000
B. A list of all random unsorted values, including duplicates, in the range of 0-100 followed by the list of all values, including in the range of 900-1000 sorted in descending order
C. A list of unique random values in the range of 0-100 followed by the list of unique values in the range of 900-1000 sorted in descending order
D. A list of all unique values sorted in descending order within the ranges of 0-100 and 900-1000

Show Suggested Answer

Suggested Answer: B 🗳️

by Lara at Feb. 14, 2019, 8:37 a.m.