-
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
-
Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table? （）
A . CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) NOT NULL CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);
B . CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));
C . CREATE TABLE EMP (empno NUMBER(4) ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));
D . CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno))
-
Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue regarding the above command（）
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.
-
Which four are valid Oracle constraint types? （）
A . CASCADE
B . UNIQUE
C . NONUNIQUE
D . CHECK
E . PRIMARY KEY
F . CONSTANT
G . NOT NULL
-
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
-
Which SQL statement defines a FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）
A . CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);
B . CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));
C . CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));
D . CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp_deptno_fk REFERENCES dept (deptno))
-
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（）
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.
-
You need to create a column that allows you to createa unique constraint. Which two column definitions should you choose?（）
A . nvarchar（100） NULL
B . nvarchar（max） NOT NULL
C . nvarchar（100） NOT NULL
D . nvarchar（100） SPARSE NULL
-
Which of the following is true of an index used to support a UNIQUE constraint?（）
A . It must have the UNIQUE attribute.
B . It cannot be created explicitly by the user.
C . It must have the UNIQUE and CLUSTER attributes.
D . It must have the UNIQUE WHERE NOT NULL attribute.
-
限制理论（TOC，Theoryof Constraint）的主要关注领域是（）.
A . 顾客需求
B . 价值流
C . 准时交付
D . 消除流程中的“瓶颈”
-
Which statement explicitly names a constraint? （）
A . ALTER TABLE student_grades ADD FOREIGN KEY (student_id) REFERENCES students (student_id);
B . ALTER TABLE student_grades ADD CONSTRAINT NAME = student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);
C . ALTER TABLE student_grades ADD CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);
D . ALTER TABLE student grades ADD NAMED CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);
E . ALTER TABLE student grades ADD NAME student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id)
-
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.
-
Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）
A .https://assets.asklib.com/images/image2/2018080115165365786.jpg
B .https://assets.asklib.com/images/image2/2018080115165818527.jpg
C .https://assets.asklib.com/images/image2/2018080115170192388.jpg
D .https://assets.asklib.com/images/image2/2018080115170459610.jpg
-
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
-
Evaluate the CREATE TABLE statement： CREATE TABLE products （product_id NUMBER （6） CONSTRAINT prod_id_pk PRIMARY KEY， product_name VARCHAR2 （15））； Which statement is true regarding the PROD_ID_PK constraint？（）
A . It would be created only if a unique index is manually created first.
B . It would be created and would use an automatically created unique index.
C . It would be created and would use an automatically created nonunique index.
D . It would be created and remains in a disabled state because no index is specified in the command.
-
禁用约束时出现下列错误：ORA-02297：cannot disable constraint-dependencies exist。这个错误是由于禁止下列哪个约束造成的？（）
A . 检查约束
B . 非NULL约束
C . 外键约束
D . 惟一约束
-
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 TABLEcommand with the ENABLE VALIDATE option to enable the constraint that was disabled. What are the twoeffects 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 beingenabled
-
Women’s garment such as corset shows the constraint the society enforces on women.
-
更改“成绩表”为列“column_b”设置“UNIQUE”约束。 ALTER TABLE 成绩表 ADD column_b VARCHAR(20) NULL CONSTRAINT b_unique UNIQUE
-
Which of the following was NOT a constraint on one's choice of soulmate in the old days'？
<img src='https://img2.soutiyun.com/ask/uploadfile/2436001-2439000/253158a2d5d9a232a634dcaa173c0f86.gif' />
-
Which of the following was NOT a constraint On one's choice of soulmate in the old days？
<img src='https://img2.soutiyun.com/ask/uploadfile/2535001-2538000/b08c2540fa5e0e672e743fd89dc0d413.gif' />
-
跨期预算约束（inter-temporal budget constraint)
跨期预算约束(inter-temporal budget constraint)
-
用户执行一条INSERT语句，但是这条语句执行失败，并且得到错误消息“ORA- 02291: integrity constraint （HR. EMP__DEPT FK） violated - （ORA-02291：违反完整性约束【HR. EMP__DEPT__FK】——在在父表中发现外键： 下列（）叙述是正确的
A．这个事务会被回滚
B．这条语句会被回滚
C．在父表中发现父键之前，必须在父表上创建一个索引
D．以上叙述都正确
