单项选择题

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

单项选择题

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