搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【多选题】

A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled. What are the two effects of this command？（）

A、It fails if any existing row violates the constraint.

B、It does not validate the existing data in the table.

C、It enables the constraint to be enforced at the end of each transaction.

D、It prevents insert， update， and delete operations on the table while the constraint is in the process of being enabled.

查看正确答案
更多“A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled. What are the two effects of this command？（）”相关的问题
第1题
[] Which two statements are true about the primary key constraint in a table？ （）

A、A.It is not possible to disable the primary key constraint.  B、B.It is possible to have more than one primary key constraint in a single table.  C、C.The primary key constraint can be referred by only one foreign key constraint.  D、D.The primary key constraint can be imposed by combining more than one column.  E、E.The non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.  

点击查看答案
第2题
[单选题] Which syntax turns an existing constraint on?（）

A、ALTER TABLE table_name ENABLE constraint_name;  B、ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint _ name;  C、ALTER TABLE table_name ENABLE CONSTRAINT constraint _ name;  D、ALTER TABLE table_name TURN ON CONSTRAINT constraint _ name;  

点击查看答案
第3题
[单选题] Which syntax turns an existing constraint on? （）

A、ALTER TABLE table_name ENABLE constraint_name;  B、ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint _ name;  C、ALTER TABLE table_name ENABLE CONSTRAINT constraint _ name;  D、ALTER TABLE table_name TURN ON CONSTRAINT constraint _ name;  

点击查看答案
第4题
[] Which syntax turns an existing constraint on?（）

A、A. ALTER TABLE table_name ENABLE constraint_name;  B、B. ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint_name;  C、C. ALTER TABLE table_name ENABLE CONSTRAINT constraint_name;  D、D. ALTER TABLE table_name STATUS ENABLE CONSTRAINT constraint_name;  E、E. ALTER TABLE table_name TURN ON CONSTRAINT constraint_name;  

点击查看答案
第5题
[单选题] Which one of the following parameters must be specified when exporting objects that has integrity constraints referencing objects that are currently being accessed by other users？（）

A、IGNORE=Y  B、DIRECT=Y  C、CONSISTENT=Y  D、BUFFER=Y  

点击查看答案
第6题
[多选题] Which three statements correctly describe the functions and use of constraints? （）

A、Constraints provide data independence.  B、Constraints make complex queries easy.  C、Constraints enforce rules at the view level.  D、Constraints enforce rules at the table level.  E、Constraints prevent the deletion of a table if there are dependencies.  F、Constraints prevent the deletion of an index if there are dependencies.  

点击查看答案
第7题
[多选题] Which three statements correctly describe the functions and use of constraints? （）

A、Constraints provide data independence.  B、Constraints make complex queries easy.  C、Constraints enforce rules at the view level.  D、Constraints enforce rules at the table level.  E、Constraints prevent the deletion of a table if there are dependencies.  F、Constraints prevent the deletion of an index if there are dependencies.  

点击查看答案
第8题
[多选题] Which three statements correctly describe the functions and use of constraints? （）

A、Constraints provide data independence.  B、Constraints make complex queries easy.  C、Constraints enforce rules at the view level.  D、Constraints enforce rules at the table level.  E、Constraints prevent the deletion of a table if there are dependencies.  F、Constraints prevent the deletion of an index if there are dependencies.  

点击查看答案
第9题
[多选题] Which two statements about creating constraints are true? （）

A、Constraint names must start with SYS_C  B、All constraints must be defines at the column level  C、Constraints can be created after the table is created  D、Constraints can be created at the same time the table is created  E、Information about constraints is found in the VIEW_CONSTRAINTS dictionary view  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服