单项选择题

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

单项选择题

What can you determine about the following linguistic sorts based only on their names？（）
1. GERMAN
2. FRENCH_M

A. 1 is a monolingual sort.
B. 2 is a monolingual sort.
C. 1 is case insensitive.
D. Both 1 and 2 are case insensitive.
E. Case sensitivity is unknown.