单选题Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?（）A UniqueB CheckC ReferentialD Informational

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

A.Package

B.Trigger

C.Stored Procedure

D.Informational Constraint

A. It executes successfully but partition pruning cannot happen for this partition key.

B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.

C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.

D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.

A.Define the column MAINID as NOT UPDATABLE

B.Define the column MAINID as a PRIMARY KEY

C.Define the column MAINID as a FOREIGN KEY

D.Define an UPDATE trigger on table TABLEX

A.Unique

B.Check

C.Referential

D.Informational

A.Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.

B.Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).

C.Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.

D.Define column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.

A. UNIQUE

B. NOT NULL

C. CHECK

D. PRIMARY KEY

E. FOREIGN KEY

A.Check

B.Range

C.Referential

D.Informational