YouareplanningtoimportcustomerdatafromtheCustomertableandtheCountrytableinyourSQLServer2000databaseintoaSQLServer2005database.Youwanttoensurethatduringtheimportprocess,eachvalueintheCountryCodecolumnoftheCustomertablehasacorrespondingrecordintheCountryCodecolumnintheCountrytableoftheSQLServer2005database.Youdefineaforeignkeybetweenthesetwotables.Thus,referentialintegritywillguaranteethattheimportroutinefailsifthereareanyrecordswhereaCountryCodevaluedoesnotexistintheCountrytablebutdoesexistintheCustomertable.YouneedtoensurethattheimportprocessdoesnotfailifrecordsareencounteredthatdonotexistintheCountrytable.Whatshouldyoudo?()
YouareplanningtoimportcustomerdatafromtheCustomertableandtheCountrytableinyourSQLServer2000databaseintoaSQLServer2005database.Youwanttoensurethatduringtheimportprocess,eachvalueintheCountryCodecolumnoftheCustomertablehasacorrespondingrecordintheCountryCodecolumnintheCountrytableoftheSQLServer2005database.Youdefineaforeignkeybetweenthesetwotables.Thus,referentialintegritywillguaranteethattheimportroutinefailsifthereareanyrecordswhereaCountryCodevaluedoesnotexistintheCountrytablebutdoesexistintheCustomertable.YouneedtoensurethattheimportprocessdoesnotfailifrecordsareencounteredthatdonotexistintheCountrytable.
Whatshouldyoudo?()
相关考题:
《公务员平时考核办法(试行)》规定,公务员平时考核由其所在机关组织实施,作为加强公务员日常管理的重要抓手,党委(党组)承担考核工作(),组织(人事)部门承担具体() 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.
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?()
在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灯长亮