Which statement is true regarding the output of the SQL statement?

Prev Question
Next Question

Evaluate the following SQL statement:
SELECT 2 col1,’y’ col2
FROM dual
UNION
SELECT 1,’x’
FROM dual UNION
SELECT 3,NULL
FROM dual
ORDER BY 2;

Which statement is true regarding the output of the SQL statement?

A.
It would execute and the order of the values in the first column would be 3, 2, 1.

B.
It would execute and the order of the values in the first column would be 1, 2, 3.

C.
It would not execute because the column alias name has not been used in the ORDER BY clause.

D.
It would not execute because the number 2 in the ORDER BY clause would conflict with the value 2 in the first SELECT statement.

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *