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 tableB.A

题目

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

相似考题

1.is, table, the, on, what__________________________________________________________________________?

2.emp表是雇员信息表,以下哪个变量可以存放emp表中的一条记录()A.v_record emp%type;B.v_record emp%recordtype;C.v_record emp%record_type;D.v_record emp%rowtype;E.v_record emp%row_type;

3.如何将变量v_row定义为emp表的记录类型()A.v_row emp%type；B.v_row emp%record；C.v_row emp%tabletype；D.v_row emp%rowtype；

4.AWebservicereturnsalistofsystemusersinthefollowingformat.Youneedtopopulateadrop－downmenuwiththeIDsandnamesoftheusersfromtheWebservice,intheorderprovidedbytheservice.Whichcodesegmentshouldyouuse?()A.$.ajax（{type："GET"，url：serviceURL，success：function（xml）{$.each（$（xml），function（i，item）{$（""）.attr（"value"，id）.text（tx）.appendTo（"#dropdown"）；}）；}}）；B.$.ajax（{type："GET"，url：serviceURL，success：function（xml）{$（xml）.find（"user"）.each（function（）{varid=$（this）.id；vartx=$（this）.name.text$（""）.attr（"value"，id）.text（tx）.appendTo（"#dropdown"）；}）；}}）；C.$.ajax（{type："GET"，url：serviceURL，success：function（xml）{$（xml）.find（"user"）.each（function（）{varid=$（this）.attr（"id"）；vartx=$（this）.find（"name"）.text（）；$（""）.attr（"value"，id）.text（tx）.appendTo（"#dropdown"）；}）；}}）；D.$.ajax（{type："GET"，url：serviceURL，success：function（xml）{xml.find（"user"）.each（function（node）{varid=$（node）.attr（"id"）；vartx=$（node）.find（"name"）.text（）；$（""）.attr（"value"，id）.text（tx）.appendTo（"#dropdown"）；}）；}}）；

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 tableB.A

题目

相似考题

更多“What type of constraint is used to ensure that each row inserted into the EMPLOYEE table w ”相关问题

相关内容