469.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.
Answer: B
参考:
http://docs.oracle.com/cd/E11882_01/timesten.112/e21643/attribute.htm#TTREF179
以下哪一个国家语言支持排序参数值会导致不区分大小写与不区分重音二态排序?
The _AI suffix implies that an accent-insensitive sort will be performed. Accent-insensitive sorts are also case insensitive by default. The _CI suffix implies that a case-insensitive sort will be performed, but it will not be accent insensitive. Specifying both suffixes (_AI_ CI) is illegal.
_AI 后缀意味着将执行不区分重音排序,不区分重音排序是默认情况下不区分大小写。
_CI 后缀意味着将执行不区分大小写的排序,但它不会是不区分重音。
同时指定后缀(_AI_ CI)是非法的。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/81227/viewspace-2124208/
,如需转载,请注明出处,否则将追究法律责任。