单项选择题

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

<上一题目录下一题>

热门试题

单项选择题

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.

单项选择题

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.