该博客讨论了在Oracle数据库中ALTER TABLE语句用于修改约束的命令，特别是`ALTER TABLE MODIFY CONSTRAINT DISABLE VALIDATE`。这个命令允许加载数据到表中而不验证约束，但新的数据仍需符合约束。它解释了DISABLE和ENABLE以及VALIDATE和NOVALIDATE的区别，并指出该命令不会删除约束的索引，且不影响现有数据的约束检查。
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.
最低0.47元/天 解锁文章
扫一扫
354
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
