Oracle
1Z0-882 · Question #98
1Z0-882 Question #98: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #98. 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 range from 1 to 1000. You execute this query: SELECT col1 FROM t1 WHERE col1< 100 UNION SELECT col1 FROM t1 WHERE col1 BETWEEN 100 and 200 UNION ALL SELECT col1 FROM t1 WHERE col 1 >=900 What is the output?
Options
- AA list of unique values within the ranges of 1-200 and 900-1000
- BA list of unique values within the range of 1-200 and a list of all values, including duplicates, on
- CA list of all values , including duplicates, in the range of 1-200 and a list of unique values in the
- DA list of all values, including duplicates, in the ranges of 1-200 and 900-1000
- EAn error, because mixing UNION and UNION ALL in the same query is not permitted
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.