OCP-1Z0-053-V12.02-469题
来源:互联网 发布:淘宝神笔编辑器 编辑:程序博客网 时间:2024/04/27 22:51
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
NLS_SORT
The NLS_SORT
attribute indicates which collating sequence to use for linguistic comparisons. It accepts the values listed in "Supported Linguistic Sorts." All these values can be modified to do case-insensitive sorts by appending _CI
to the value. To perform accent-insensitive and case-insensitive sorts, append _AI
to the value.
For materialized views and cache groups, TimesTen recommends that you explicitly specify the collating sequence using the NLSSORT
SQL function rather than using this attribute in the connection string or DSN definition.
Operations involving character comparisons support linguistic case-sensitive collating sequences. Case-insensitive sorts may affect DISTINCT
value interpretation.
NLS_SORT
may affect many operations. The supported operations that are sensitive to collating sequence are:
MIN
,MAX
BETWEEN
=
,<>
,>
,>=
,<
,<=
DISTINCT
CASE
GROUP BY
HAVING
ORDER BY
IN
LIKE
Only BINARY
sort is supported with the TIMESTEN8
character set.
NLS_SORT
settings other than BINARY
may have significant performance impact on character operations.
Note:
Primary key indexes are always based on theBINARY
collating sequence. Use of non-BINARY NLS_SORT
equality searches cannot use the primary key index- OCP-1Z0-053-V12.02-469题
- OCP-1Z0-053-V12.02-679题
- OCP-1Z0-053-V12.02-591题
- OCP-1Z0-053-V12.02-590题
- OCP-1Z0-053-V12.02-552题
- OCP-1Z0-053-V12.02-551题
- OCP-1Z0-053-V12.02-549题
- OCP-1Z0-053-V12.02-548题
- OCP-1Z0-053-V12.02-234题
- OCP-1Z0-053-V12.02-584题
- OCP-1Z0-053-V12.02-595题
- OCP-1Z0-053-V12.02-184题
- OCP-1Z0-053-V12.02-59题
- OCP-1Z0-053-V12.02-676题
- OCP-1Z0-053-V12.02-667题
- OCP-1Z0-053-V12.02-660题
- OCP-1Z0-053-V12.02-580题
- OCP-1Z0-053-V12.02-323题
- 关于Android中Dialog点击屏幕外失去焦点消失的问题
- myeclipse下手动配置多个同版本的tomcat
- C++之运算符重载(1)
- 第一手知识——切身体验
- android 获取手机IMSI码 双卡双待手机
- OCP-1Z0-053-V12.02-469题
- Vmware10下安装Mac OS X Mountain Lion(10.8.5)
- 利用IAR Timeline工具测试delay函数执行时间
- POJ 3254 Corn Fields
- thrift Drools
- 线性代数导论32——基变换和图像压缩
- AAC 文件解析及解码流程
- springmvc中Model ModelAndView ModelMap Map 的理解
- 数据结构与算法系列-树-数的基本概念