OCP-1Z0-052-V8.02-10题
来源:互联网 发布:淘宝团队 编辑:程序博客网 时间:2024/05/17 00:17
10. Examine the following statement that is used to modify the constraint on the SALES table:
SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE;
Which three statements are true regarding the above command? (Choose three.)
A.The constraint remains valid.
B.The index on the constraint is dropped.
C.It allows the loading of data into the table using SQL *Loader.
D.New data conforms to the constraint, but existing data is not checked
E.It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
Answer: ABC
答案解析:
参考:http://blog.csdn.net/rlhua/article/details/12251961
这道题,可用排除法来做,D:属于ENABLE NOVALIDATE,E,不能对已存在的数据做update
所以,只能选择ABC
简单来讲,DISABLE 和ENABLE 是针对新增的数据是否符合约束,NOVALIDATE 和VALIDATE是针对已经存在的数据是否符合约束。
题中是DISABLE VALIDATE即是针对新增的数据可以不符合约束,但是已经存在的数据要满足约束。
可以使用排除法,D是属于.ENABLENOVALIDATE
E,不能修改已经存在数据,错误。
C正确,是因为对新增的数据不限制,没有约束。
A正确,是因为DISABLE VALIDATE对现有的数据还有约束。
B呢?
约束条件状态
You can specify that a constraint is enabled (ENABLE
) or disabled (DISABLE
). If a constraint is enabled, data is checked as it is entered or updated in the database, and data that does not conform to the constraint is prevented from being entered. If a constraint is disabled, then data that does not conform can be allowed to enter the database.
Additionally, you can specify that existing data in the table must conform to the constraint (VALIDATE
). Conversely, if you specifyNOVALIDATE
, you are not ensured that existing data conforms.
An integrity constraint defined on a table can be in one of the following states:
ENABLE
,VALIDATE
ENABLE
,NOVALIDATE
DISABLE
,VALIDATE
DISABLE
,NOVALIDATE
- OCP-1Z0-052-V8.02-10题
- OCP-1Z0-052-V8.02-1题
- OCP-1Z0-052-V8.02-91题
- OCP-1Z0-052-V8.02-92题
- OCP-1Z0-052-V8.02-80题
- OCP-1Z0-052-V8.02-81题
- OCP-1Z0-052-V8.02-82题
- OCP-1Z0-052-V8.02-79题
- OCP-1Z0-052-V8.02-77题
- OCP-1Z0-052-V8.02-23题
- OCP-1Z0-052-V8.02-72题
- OCP-1Z0-052-V8.02-157题
- OCP-1Z0-052-V8.02-156题
- OCP-1Z0-052-V8.02-155题
- OCP-1Z0-052-V8.02-29题
- OCP-1Z0-052-V8.02-110题
- OCP-1Z0-052-V8.02-165题
- OCP-1Z0-052-V8.02-171题
- Java高手真经系列电子书 + Java典型应用彻查1000例系列电子书
- Position定位:relative | absolute
- 黑马程序员---java基础概述
- KMP muban
- kmp算法之next数组
- OCP-1Z0-052-V8.02-10题
- 摩登年代(魔力一点点)】【高清1280版HD-RMVB.国语中英双字】【2013最新徐峥喜剧大片
- 学习笔记之javaweb基础:JSP的HelloWorld及其运行原理
- Linux下norflash驱动编写方法
- Java序列化和克隆--对象深度拷贝
- 二分搜索的时间复杂度O(logN)如何得到
- [OGRE]基础教程来三发:来谈一谈摄像机吧
- Java从零单排Round2----Java概述
- VS2010一键配置cocos2d-x开发,帅呆了