单选题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

题目

单选题

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 check constraint on the EMPLOYEE table

A unique constraint on the EMPLOYEE table WORKDEPT column

A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE table

A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?()

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.

参考答案：C

第2题：

What type of constraint can be used to ensure that, in any given row in a table, the value of one column never exceeds the value of another column?()

A.Check

B.Range

C.Referential

D.Informational

参考答案：A

第3题：

What type of extinguisher should be used for an electric fire? ________

A.CO2

B.Form

C.Water

D.Water and Form

正确答案：A

第4题：

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

第5题：

What OSPF LSA is used to support MPLS-traffic Engineering ？（）

A、External LSA （Type 5 ）
B、Opaque LSA （Type 9 ）
C、Opaque LSA （Type 10 ）
D、Opaque LSA （Type 11 ）
E、NSSA LSA （Type 7 ）

正确答案:C

第6题：

Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?()

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

参考答案：D

第7题：

When selecting a Network Interface Card (NIC), which of the following factors need to be considered?()

A. The type of application used on the network

B. The type of system bus used by the computers

C. The type of memory installed in each computer

D. The type of media used in the network topology

E. The type of protocols used in the network

F. The physical layout of the network hosts

参考答案：B, D, F

第8题：

Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?()

A.Unique

B.Check

C.Referential

D.Informational

参考答案：B

第9题：

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

正确答案:A,D

第10题：

When selecting a Network Interface Card (NIC), which of the following factors need to be considered?（）

A、The type of application used on the network
B、The type of system bus used by the computers
C、The type of memory installed in each computer
D、The type of media used in the network topology
E、The type of protocols used in the network
F、The physical layout of the network hosts

正确答案:B,D,F

What type of constraint is used to ensure that each row inse

题目

相似问题和答案

更多相关问题

相关内容