• Description: Oracle Database SQL Expert
• Passing Score: 0%
• Practice Test - Number of questions: 169 questions
• Simulation Test - Number of questions: 169 questions
• Simulation Test Duration: 120 minutes
• Has explanations: No

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?

Answer(s)

1. It would execute and the order of the values in the first column would be 3, 2, 1.
2. It would execute and the order of the values in the first column would be 1, 2, 3.
3. It would not execute because the column alias name has not been used in the ORDER BYclause.
4. It would not execute because the number 2 in the ORDER BY clause would conflict with thevalue 2 in the first SELECT statement.

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