Oracle
1Z0-071 · Question #19
1Z0-071 Question #19: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #19. The question stem and answer options stay visible for context.
Question
Evaluate the following SQL statement: SQL> SELECT cust_id, cust_last_name "Last Name" FROM customers WHERE country_id = 10 UNION SELECT cust_id CUST_NO, cust_last_name FROM customers WHERE country_id = 30; Which ORDER BY clause are valid for the above query? (Choose all that apply.)
Options
- AORDER BY 2,1
- BORDER BY CUST_NO
- CORDER BY 2, cust_id
- DORDER BY "CUST_NO"
- EORDER BY "Last Name"
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 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.