Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Question 189

Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION?

Column positions must be used in the ORDER BY clause.

Only column names from the first SELECT statement in the compound query are recognized.

Each SELECT statement in the compound query must have its own ORDER BY clause.

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.

Each SELECT statement in the compound query can have its own ORDER BY clause.

Correct Answer: A, B

When using the ORDER BY clause with a SQL statement containing a SET operator such as UNION, column positions must be used, or column names from the first SELECT statement in the compound query are recognized. This ensures that the result set is ordered effectively as the ORDER BY clause does not support individual sorting for each SELECT statement within the compound query. Therefore, options A and B are true.

Discussion

yaya32Options: BD

BD correct!