OCP 11g认证题库详解：1Z0-051-069题

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空值最后排序，不符合题意。