OCP 11g认证题库详解：1Z0-051-065题
最新学讯：近期OCP认证正在报名中，因考试人员较多请尽快报名获取最近考试时间，报名费用请联系在线老师，甲骨文官方认证，报名从速！
我要咨询OCP 11g认证题库详解：1Z0-051-065题，完整题库请点击这里联系老师咨询了解
65. View the Exhibit and examine the structure of the CUSTOMERS table.
You have been asked to produce a report on the CUSTOMERS table showing the customers details
sorted in descending order of the city and in the descending order of their income level in each city.
Which query would accomplish this task?
A. SELECT cust_city, cust_income_level, cust_last_name
FROM customers
ORDER BY cust_city desc, cust_income_level DESC ;
B. SELECT cust_city, cust_income_level, cust_last_name
FROM customers
ORDER BY cust_income_level desc, cust_city DESC;
C. SELECT cust_city, cust_income_level, cust_last_name
FROM customers
ORDER BY (cust_city, cust_income_level) DESC;
D. SELECT cust_city, cust_income_level, cust_last_name
FROM customers
ORDER BY cust_city, cust_income_level DESC;
Answer: A
试题解析：
根据题意：sorted in descending order of the city and in the descending order of their income level in each city.
是按照城市的降序来排列，并且在每个城市中按照income level的降序来排列。
即先 cust_city desc再cust_income_level DESC
