Oracle
1Z0-882 · Question #32
1Z0-882 Question #32: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #32. The question stem and answer options stay visible for context.
Question
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?
Options
- AA list of all values, including duplicates, sorted in descending order in the ranges of 0-100 and
- BA list of all random unsorted values, including duplicates, in the range of 0-100 followed by the list
- CA list of unique random values in the range of 0-100 followed by the list of unique values in the
- DA list of all unique values sorted in descending order within the ranges of 0-100 and 900-1000
Unlock 1Z0-882 to see the answer
You've previewed enough free 1Z0-882 questions. Unlock 1Z0-882 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.