PrepAway - Latest Free Exam Questions & Answers

What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the W

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?

PrepAway - Latest Free Exam Questions & Answers

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

One Comment on “What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the W


Leave a Reply