IBM认证考试

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
参考答案和解析
正确答案:D
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

What term is used to describe the process where one frame is placed into a different type of frame?()

A. Framing

B. De-encapsulation

C. Encapsulation

D. De-framing

E. None of the above


参考答案：C

第2题：

What term is used to describe the process where one frame is placed into a different type of frame?（）

  • A、Framing
  • B、De-encapsulation
  • C、Encapsulation
  • D、De-framing
  • E、None of the above

正确答案:C

第3题：

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

A.CO2

B.Form

C.Water

D.Water and Form


正确答案：A

第4题：

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

第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题：

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

第7题：

You are a senior network administrator at TestKing, and while performing thepassword recovery procedure on your 2500 series Cisco router, you type in thefollowing command:o/r 0x2142What is the purpose of this command?（）

  • A、It is used to restart the router.
  • B、It is used to bypass the configuration in NVRAM.
  • C、It is used to enter ROM Monitor mode.
  • D、It is used to view the lost password.
  • E、It is used to save the changes to the configuration.

正确答案:B

第8题：

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

第9题：

What does the FREQ column show when running the tprof option?（）

  • A、 Total amount of Ticks used by all users 
  • B、 Total amount of Ticks used by all processes 
  • C、 Total amount of Ticks used by a specific user 
  • D、 Total amount of Ticks used by a specific type of process

正确答案:D

第10题：

Which of the following database objects can be used to raise an error if a table is updated?（）

  • A、Package
  • B、Trigger
  • C、Stored Procedure
  • D、Informational Constraint

正确答案:B

更多相关问题
相关内容