Oracle
1Z0-047 · Question #10
1Z0-047 Question #10: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #10. The question stem and answer options stay visible for context.
Question
Evaluate the following SQL statement: SELECT 2 col1,ycol2 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?
Options
- AIt would execute and the order of the values in the first column would be 3,2,1.
- BIt would execute and the order of the values in the first column would be 1,2,3.
- CIt would not execute because the column alias name has not been used in the ORDER BY clause.
- DIt would not execute because the number 2 in the ORDER BY clause would conflict with the value 2
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 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.