单项选择题

Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement？（）

A. NLS_LANG
B. NLS_COMP
C. NLS_SORT
D. None of the above

相关考题

WhichofthefollowingNLS_SORTparametervalueswouldresultin...

单项选择题Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts？（）

A. NLS_SORT = BINARY
B. NLS_SORT = BINARY_AI
C. NLS_SORT = BINARY_CI
D. NLS_SORT = BINARY_AI_CI
E. Binary sorts are case insensitive and accent insensitive by default

Automaticdataconversionwilloccurifwhichofthefollowingha...

单项选择题Automatic data conversion will occur if which of the following happens？（）

A. The client and server have different NLS_LANGUAGE settings
B. The client and server character sets are not the same，and the database character set is not a strict superset of the client character set
C. The client and server are in different time zones
D. The client requests automatic data conversion
E. The AUTO_CONVERT initialization parameter is set to TRUE

InadatabasewiththedatabasecharactersetofUS7ASCIIandanat...

单项选择题In a database with the database character set of US7ASCII and a national character set of UTF-8， which datatypes would be capable of storing Unicode data by default？（）

A. VARCHAR2
B. CHAR
C. NVARCHAR2
D. CLOB
E. LONG

1Z0-053

Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement？（）