多选题A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLEcommand with the ENABLE VALIDATE option to enable the constraint that was disabled. What are the twoeffects of this command（）AIt fails if any existing

题目

多选题

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

It fails if any existing row violates the constraint.

It does not validate the existing data in the table.

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

It prevents insert， update， and delete operations on the table while the constraint is in the process of beingenabled

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

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;

参考答案：C

第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 STATUS ENABLE CONSTRAINT constraint_name;
E、ALTER TABLE table_name TURN ON CONSTRAINT constraint_name;

正确答案:C

第3题：

You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?()

A. ALTER TABLE students ADD PRIMARY KEY _ id;

B. ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);

C. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;

D. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

E. ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

参考答案：D

第4题：

您需要从方案中的雇员表中删除EMP_FK_DEPT约束条件。应使用哪条语句（）

A、DROP CONSTRAINT EMP_FK_DEPT FROM雇员
B、DELETE CONSTRAINT EMP_FK_DEPT FROM雇员
C、ALTER TABLE雇员DROP CONSTRAINT EMP_FK_DEPT
D、ALTER TABLE雇员REMOVE CONSTRAINT EMP_FK_DEPT

正确答案:C

第5题：

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 beingenabled

正确答案:A,D

第6题：

删除PRIMARYKEY约束条件及其所有依赖约束条件的语法是什么（）

A、ALTER TABLE table_name DROP CONSTRAINT constraint_name CASCADE
B、ALTER TABLE table_name DROP CONSTRAINT FOREIGN KEY CASCADE
C、DROP CONSTRAINT table_name（constraint_name）
D、ALTER TABLE table_name DROP CONSTRAINT constraint_name

正确答案:A

第7题：

In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）

A、if a table is not in a cluster
B、if a table has an active trigger
C、if a table has an encrypted
D、if a table has a column of data type LONG defined on it
E、if a table has a referential integrity constraint defined on it

正确答案:B,C,E

第8题：

Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?()

A. ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;

B. ALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;

C. ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn NOT NULL;

D. ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn IS NOT NULL;

E. ALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL;

F. ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name NOT NULL;

参考答案：C

第9题：

What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）

A、A check constraint on the EMPLOYEE table
B、A unique constraint on the EMPLOYEE table WORKDEPT column
C、A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE table
D、A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table

正确答案:D

第10题：

Which two statements are true about the primary key constraint in a table？（）

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

正确答案:D,E

A constraint in a table is defined with the INITIALLY IMMEDI

题目

相似问题和答案

更多相关问题

相关内容