单项选择题
Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?()
A. All objects in the database
B. Tables owned by SYS and SYSTEM
C. Data dictionary tables
D. NCHAR columns
E. CHAR columns
相关考题
-
单项选择题
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.
