ocp 11g認證題庫詳解：1Z0-051-069題
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢ocp 11g認證題庫詳解：1Z0-051-069題，完整題庫請點擊這里聯系老師咨詢了解
69. You need to generate a list of all customer last names with their credit limits from the CUSTOMERS
table. Those customers who do not have a credit limit should appear last in the list.
Which two queries would achieve the required result? (Choose two.)
A. SELECT cust_last_name, cust_credit_limit
FROM customers
ORDER BY cust_credit_limit DESC ;
B. SELECT cust_last_name, cust_credit_limit
FROM customers
ORDER BY cust_credit_limit;
C. SELECT cust_last_name, cust_credit_limit
FROM customers
ORDER BY cust_credit_limit NULLS LAST;
D. SELECT cust_last_name, cust_credit_limit
FROM customers
ORDER BY cust_last_name, cust_credit_limit NULLS LAST;
Answer: BC
試題解析：
對于升序排序，空值顯示在最后，對于降序排序，則顯示在最前面
who do not have a credit limit should appear last in the list
題目要求空值在最后面
要么升序排列，要么指定nulls last
D先按照cust_last_name排序，在按照 cust_credit_limit空值最后排序，不符合題意。
