Valid 1z0-071 Dumps shared by EduDump.com for Helping Passing 1z0-071 Exam! EduDump.com now offer the newest 1z0-071 exam dumps, the EduDump.com 1z0-071 exam questions have been updated and answers have been corrected get the newest EduDump.com 1z0-071 dumps with Test Engine here:
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.)
Correct Answer: A,C,E
Using the ORDER BY Clause in Set Operations -The ORDER BY clause can appear only once at the end of the compound query. -Component queries cannot have individual ORDER BY clauses. -The ORDER BY clause recognizes only the columns of the first SELECT query. -By default, the first column of the first SELECT query is used to sort the output in an ascending order.
