YouareplanningtoimportcustomerdatafromtheCustomertableandtheCountrytableinyourSQLServer2000databaseintoaSQLServer2005database.Youwanttoensurethatduringtheimportprocess,eachvalueintheCountryCodecolumnoftheCustomertablehasacorrespondingrecordintheCountryCodecolumnintheCountrytableoftheSQLServer2005database.Youdefineaforeignkeybetweenthesetwotables.Thus,referentialintegritywillguaranteethattheimportroutinefailsifthereareanyrecordswhereaCountryCodevaluedoesnotexistintheCountrytablebutdoesexistintheCustomertable.YouneedtoensurethattheimportprocessdoesnotfailifrecordsareencounteredthatdonotexistintheCountrytable.Whatshouldyoudo?()

YouareplanningtoimportcustomerdatafromtheCustomertableandtheCountrytableinyourSQLServer2000databaseintoaSQLServer2005database.Youwanttoensurethatduringtheimportprocess,eachvalueintheCountryCodecolumnoftheCustomertablehasacorrespondingrecordintheCountryCodecolumnintheCountrytableoftheSQLServer2005database.Youdefineaforeignkeybetweenthesetwotables.Thus,referentialintegritywillguaranteethattheimportroutinefailsifthereareanyrecordswhereaCountryCodevaluedoesnotexistintheCountrytablebutdoesexistintheCustomertable.YouneedtoensurethattheimportprocessdoesnotfailifrecordsareencounteredthatdonotexistintheCountrytable.

Whatshouldyoudo?()


相关考题:

在以下的4项条件中,()对项目经理最重要。 A.管理经验B.谈判技巧C.所受的技术方面的教育D.与其他人一起工作的能力

《公务员平时考核办法(试行)》规定,公务员平时考核由其所在机关组织实施,作为加强公务员日常管理的重要抓手,党委(党组)承担考核工作(),组织(人事)部门承担具体() A.主体责任B.监督责任C.管理责任D.工作责任

You are creating a templated Web control for use in your Web application. You need to add the Web control to your Web application pages without compiling your control into a .dll file.What should you do?()A. Ensure that the Web control inherits from the WebControl class.B. Ensure that the Web control inherits from the Control class.C. Ensure that the Web control inherits from the CompositeControl class.D. Ensure that the Web control inherits from the UserControl class.

Ipconfig/renew命令可以() A.重新向DHCP申请一个IP地址B.更新ip地址和mac地址的映射表C.更新路由信息D.更新TCP/IP连接状态信息

YourecentlycreatedacomplexresourceplannamedDB_PLANthathastwosubplansnamedOLTP_PLANandDSS_PLAN.TheOLTP_PLANandDSS_PLANsubplansareallotted70percentand30percentofthetotalCPUresources,respectively.TheOLTP_PLANsubplanallocates35percentoftheavailableCPUresourcestoaresourceconsumergroupnamedACCT_CLERKS.Accordingtothe OLTP_PLANsubplan,theremaining65percentoftheavailableCPUresourcesisallocatedtoasecondresourceconsumergroupnamedMKT_CLERKS.TheCPUresourcesavailabletotheDSS_PLANsubplanaredividedintotworesourceconsumergroupsnamedMKT_MANAGERSandFIN_MANAGERS.TheMKT_MANAGERSgroupreceives65percentoftheavailableCPUresources,andtheFIN_MANAGERSgroupreceives35percentoftheavailableCPUresources.WhatpercentageofactualCPUresourceswilltheresourceconsumergroup,MKT_CLERKS,receive,iftheDSS_PLANsubplandoesNOTconsumeanyCPUresources?()

在我国社会主义法律的渊源中,法律是由()制定的。 A.全国人大及其常委会B.国务院C.国务院所属的部委D.地方人大和地方政府

在route-policy的if-Match字句中,有以下命令,可以用于所有路由协议的是() A. if-match as-path aspath-list-numB. if-match community community-list-numC. if-match interface type numberD. if-match ip next-hop \{acl-number | ip-prefix ip-prefix-name}

当要对RBS2202的IDB进行修改时,DXU必须在什么状态、有何现象()。 A.DXU必须在LOCAL状态,DXU的LOCAL灯快闪B.DXU必须在LOCAL状态,DXU的LOCAL灯长亮C.DXU必须在REMOTE状态,DXU的LOCAL灯快闪D.DXU必须在REMOTE状态,DXU的LOCAL灯长亮