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
答案解析:有
微信扫一扫手机做题