Oracle
1Z0-082 · Question #41
1Z0-082 Question #41: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-082 to reveal the answer and full explanation for question #41. The question stem and answer options stay visible for context.
Question
Examine this SQL statement: 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, any one of which can complete the query successfully. (Choose three.)
Options
- AORDER BY "Last Name"
- BORDER BY 2, 1
- CORDER BY 2, cust_id
- DORDER BY CUST_NO
- EORDER BY "CUST_NO"
Unlock 1Z0-082 to see the answer
You've previewed enough free 1Z0-082 questions. Unlock 1Z0-082 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.