OCP认证051考试题库：11g-v9.02-第156题

OCP认证051考试题库：11g-v9.02-第156题，完整题库请点击这里联系老师咨询了解

156. 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 clauses are valid for the above query? (Choose all that apply.)

A. ORDER BY 2,1

B. ORDER BY CUST_NO

C. ORDER BY 2,cust_id

D. ORDER BY "CUST_NO"

E. ORDER BY "Last Name"

Answer: ACE

试题解析：

ORDER BY 后面可以跟数字，可以完全一摸一样的列名,经过union后，字段名根据第一个查询语句显示，变为cust_id和Last Name。