Oracle
1Z0-082 · Question #70
1Z0-082 Question #70: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-082 to reveal the answer and full explanation for question #70. The question stem and answer options stay visible for context.
Question
Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)
Options
- AColumn positions must be used in the ORDER BY clause
- BOnly column names from the first SELECT statement in the compound query are recognized
- CThe first column in the first SELECT of the compound query with the UNION operator is used by
- DEach SELECT statement in the compound query must have its own ORDER BY clause
- EEach SELECT statement in the compound query can have its own ORDER BY clause
Unlock 1Z0-082 to see the answer
You've previewed enough free 1Z0-082 questions. Unlock 1Z0-082 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.