ocp 053 第461题

461.The NLS_SORT parameter sets the default sort method for which of the following
operations?(Choose all that apply.)
A. WHERE clause
B. ORDER BY clause
C. BETWEEN clause
D. NLSSORT function
E. NLS_SORT function

原答案Answer:AD

个人认为应该选:ABC

NLS_SORT may affect many operations. The supported operations that are sensitive to collating sequence are:

• MIN, MAX

• BETWEEN

• =, <>, >, >=, <, <=

• DISTINCT

• CASE

• GROUP BY

• HAVING

• ORDER BY

• IN

• LIKE

The NLSSORT Function

The NLSSORT function enables you to use any linguistic sort for an ORDER BY clause. It replaces a character string with the equivalent sort string used by the linguistic sort mechanism so that sorting the replacement strings produces the desired sorting sequence. For a binary sort, the sort string is the same as the input string.

The kind of linguistic sort used by an ORDER BY clause is determined by the NLS_SORT session parameter, but it can be overridden by explicitly using the NLSSORTfunction.

Example 9-1 specifies a German sort with the NLS_SORT session parameter.

Example 9-1 Specifying a German Sort with the NLS_SORT Session Parameter

ALTER SESSION SET NLS_SORT = GERMAN;
SELECT * FROM table1
     ORDER BY column1;

Example 9-2 Specifying a French Sort with the NLSSORT Function

This example first sets the NLS_SORT session parameter to German, but the NLSSORT function overrides it by specifying a French sort.

ALTER SESSION SET NLS_SORT = GERMAN;
SELECT * FROM table1
     ORDER BY NLSSORT(column1, 'NLS_SORT=FRENCH');

参考：

http://docs.oracle.com/cd/E11882_01/timesten.112/e21643/attribute.htm#TTREF179

http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch9sql.htm#NLSPG441