Oracle
1Z0-071 · Question #314
1Z0-071 Question #314: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #314. 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
- AEach SELECT statement in the compound query must have its own ORDER BY clause.
- BEach SELECT statement in the compound query can have its own ORDER BY clause.
- CColumn positions must be used in the ORDER BY clause.
- DThe first column in the first SELECT of the compound query with the UNION operator is used by
- EOnly column names from the first SELECT statement in the compound query are recognized.
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 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.