Which of the following will be a consequence of defining the column IDCOL2 in TABLE2 as a foreign key referencing the primary key (IDCOL1) of TABLE1?（）A、DB2 will no longer allow updating the value of IDCOL1 in TABLE1.B、When inserting a row in TABLE2, the only values that DB2 will allow for IDCOL2 are the existing values of IDCOL1.C、When inserting a row in TABLE2, DB2 will only allow foreign values for IDCOL2, that is values which do not exist in IDCOL1.D、When a SELECT statement joins TABLE1 with TABLE2, DB2 will automatically add the condition TABLE1.IDCOL1=TABLE2.IDCOL2 if not specified in the statement.

网友您好，请在下方输入框内输入要搜索的题目：

题目内容（请给出正确答案）

Which of the following will be a consequence of defining the column IDCOL2 in TABLE2 as a foreign key referencing the primary key (IDCOL1) of TABLE1?（）

A、DB2 will no longer allow updating the value of IDCOL1 in TABLE1.
B、When inserting a row in TABLE2, the only values that DB2 will allow for IDCOL2 are the existing values of IDCOL1.
C、When inserting a row in TABLE2, DB2 will only allow foreign values for IDCOL2, that is values which do not exist in IDCOL1.
D、When a SELECT statement joins TABLE1 with TABLE2, DB2 will automatically add the condition TABLE1.IDCOL1=TABLE2.IDCOL2 if not specified in the statement.

参考答案

更多 “Which of the following will be a consequence of defining the column IDCOL2 in TABLE2 as a foreign key referencing the primary key (IDCOL1) of TABLE1?（）A、DB2 will no longer allow updating the value of IDCOL1 in TABLE1.B、When inserting a row in TABLE2, the only values that DB2 will allow for IDCOL2 are the existing values of IDCOL1.C、When inserting a row in TABLE2, DB2 will only allow foreign values for IDCOL2, that is values which do not exist in IDCOL1.D、When a SELECT statement joins TABLE1 with TABLE2, DB2 will automatically add the condition TABLE1.IDCOL1=TABLE2.IDCOL2 if not specified in the statement.” 相关考题

考题 Which of the following is not an AVL tree?A．B．C．D．

查看答案

考题 Which of the following sounds is a voiced bilabial stop?

查看答案

考题 Which of the following phonetic symbol is not right?

查看答案

考题 Which of the following is a performance optimization technology?（）A、QoSB、TrunkingC、SpanningD、VoIP

查看答案

考题 Which of the following is BEST for providing network security?（）A、FirewallB、DMZC、SwitchD、IDS

查看答案

考题 Which of the following utilities are used to choose which programs run at startup？（）A、SFCB、SETDEBUGC、MSCONFIGD、REGEDIT

查看答案

考题 Which of the following commands will be run at a command prompt to determine which WindowsOS is running on the computer?（）A、VERB、Device ManagerC、VERIFYD、SET

查看答案

考题单选题Which of the following technologies can improve convergence time following a link failure in a serviceprovider network？（）A MPLS TE FRB MPLS VPNC BFDD RSVPE VPLSF SNMP

查看答案

考题单选题Which of the following is not a wind（）.A GrowlerB NortherC LevanterD Mistral

查看答案

考题单选题Which of the following is a hybrid network topology used for fault tolerance, in which all computersMUST connect to each other?（）A StarB RingC BusD Mesh

查看答案

热门标签

网友您好， 请在下方输入框内输入要搜索的题目：

网友您好，请在下方输入框内输入要搜索的题目：