J
Oracle 1Z0-071 Exam
Prepare Oracle 1Z0-071 Exam Questions
Question No 1:
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. (Choose three.)
A. ORDER BY "Last name"
B. ORDER BY 2, cust_id
C. ORDER BY CUST_NO
D. ORDER BY 2,1
E. ORDER BY "CUST_NO"
Answer: A,B,D
See More Questions
Information About Oracle 1Z0-071 Exam
Vender: Oracle
Exam Code: 1Z0-071
Exam Name: Oracle Database SQL
Number Of Questions: 318
Certification Name: Oracle Database
Exam Language: English
Questions Type: MCQs
Material Format: PDF & Web Practice Test Software