单项选择题
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_SORTparametervalueswouldresultincase-insensitiveandaccent-insensitivebinarysorts?()
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 -
单项选择题
Automaticdataconversionwilloccurifwhichofthefollowinghappens?()
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 -
单项选择题
InadatabasewiththedatabasecharactersetofUS7ASCIIandanationalcharactersetofUTF-8,whichdatatypeswouldbecapableofstoringUnicodedatabydefault?()
A. VARCHAR2
B. CHAR
C. NVARCHAR2
D. CLOB
E. LONG
