Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION?
A.
Column positions must be used in the ORDER BY clause.
B.
Only column names from the first SELECT statement in the compound query are recognized.
C.
Each SELECT statement in the compound query must have its own ORDER BY clause.
D.
The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause.
E.
Each SELECT statement in the compound query can have its own ORDER BY clause.
This section is not available anymore. Please use the main Exam Page.1z0-071 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
kay000001
8 months, 1 week agoyaya32
1 year, 5 months ago