oracle 约束A constraint in a table is defined with the INITIAL
来源:学生作业帮 编辑:大师作文网作业帮 分类:英语作业 时间:2024/11/19 19:11:52
oracle 约束
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?(Choose two.)
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.
请高手解释下为何选择AD,
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?(Choose two.)
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.
请高手解释下为何选择AD,
因为有VALIDATE选项,所以会对表中原有的数据进行检查,所以A、B两个选项中A是正确的;
因为约束是 INITIALLY IMMEDIATE,所以不会在提交事务时才应用约束,所以C是错误的;
约束enable的过程中,禁止所有的DML操作,这是默认的特性
因为约束是 INITIALLY IMMEDIATE,所以不会在提交事务时才应用约束,所以C是错误的;
约束enable的过程中,禁止所有的DML操作,这是默认的特性
create table 表名( a ...,b...,...constraint 约束名 primary key(a,
英语翻译A "Qualified IPO" (“QIPO”) is defined as an initial publ
英语翻译A hockey ball is ‘flicked’ off the ground with initial v
翻译:Here is a table with the metal
英语翻译In accounting and auditing,internal control is defined a
英语翻译The Electronic Data Interchange(EDI) is simply defined a
( )a table in the room.
with a table cloth the table looks very nice
#[5] The living room is clean and tidy,with a dining table a
from ground level,a ball is thrown upward with an initial ve
in the midst of the wreck of papers a table shone,with plent
here is a table with the metals that react most at the top ,