ocp 11g認證題庫詳解：1Z0-051-068題，完整題庫請點擊這里聯(lián)系老師咨詢了解

68. Which statement is true regarding the default behavior of the ORDER BY clause?

A. In a character sort, the values are case- sensitive.

B. NULL values are not considered at all by the sort operation.

C. Only those columns that are specified in the SELECT list can be used in the ORDER BY clause.

D. Numeric values are displayed from the maximum to the minimum value if they have decimal positions.

Answer: A

試題解析：

A對，在字符排序中，是區(qū)分大小寫的。

B錯，對于升序排序，空值顯示在最后，對于降序排序，則顯示在最前面。即NULL是被考慮的

C錯，可以指定不在select列中的字段來排序。

D錯，不管是否小數(shù)，都是按照數(shù)值的大小來升序或降序排列。