Oracle
1Z0-071 · Question #231
1Z0-071 Question #231: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #231. 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 Identify three ORDER BY clauses either one of which can complete the query.
Options
- AORDER BY "Last name"
- BORDER BY 2, cust_id
- CORDER BY CUST_NO
- DORDER BY 2, 1
- EORDER BY "CUST_NO"
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.