单项选择题

YouworkinacompanywhichusesSQLServer2008.Youaretheadmini……

YouworkinacompanywhichusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDB1intheinstance.TheDB1databaseincludesspatialdatatypes.OnDB1databse,youhavetoperformadatabaseconsistencychecktoincludethespatialindexes.Besidesthis,youmustmakesurethatyoucanreducetheeffectonthedatabaseconcurrencytotheleast.SowhichTransact-SQLstatementshouldyourun?（）
A.DBCCCHECKCATALOG(DB1);
B.DBCCCHECKALLOC(DB1)WITHTABLOCK;
C.DBCCCHECKDB(DB1)WITHTABLOCK,PHYSICAL_ONLY;
D.DBCCCHECKDB(DB1)WITHEXTENDED_LOGICAL_CHECKS;

A.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDB1intheinstance.TheDB1databaseincludesspatialdatatypes.OnDB1databse,youhavetoperformadatabaseconsistencychecktoincludethespatialindexes.Besidesthis,youmustmakesurethatyoucanreducetheeffectonthedatabaseconcurrencytotheleast.SowhichTransact-SQLstatementshouldyourun?（）
A.DBCCCHECKCATALOG(DB1);
B.DBCCCHECKALLOC(DB1)WITHTABLOCK;
C.DBCCCHECKDB(DB1)WITHTABLOCK,PHYSICAL_ONLY;
D.DBCCCHECKDB(DB1)WITHEXTENDED_LOGICAL_CHECKS;

<上一题目录下一题>

热门试题

单项选择题Yourcompanyhasamainofficeandthreebranchoffices.ThecompanyhasanActiveDirectoryforestthathasasingledomain.Eachofficehasonedomaincontroller.EachofficeisconfiguredasanActiveDirectorysite.AllsitesareconnectedwiththeDEFAULTIPSITELINKobject.Youneedtodecreasethereplicationlatencybetweenthedomaincontrollers.Whatshouldyoudo（）A.Decreasethecostbetweentheconnectionobjects.B.Decreasethereplicationintervalforallconnectionobjects.C.DecreasethereplicationintervalfortheDEFAULTIPSITELINKobject.D.DecreasethereplicationschedulefortheDEFAULTIPSITELINKobject.

A.ThecompanyhasanActiveDirectoryforestthathasasingledomain.Eachofficehasonedomaincontroller.EachofficeisconfiguredasanActiveDirectorysite.AllsitesareconnectedwiththeDEFAULTIPSITELINKobject.Youneedtodecreasethereplicationlatencybetweenthedomaincontrollers.Whatshouldyoudo（）
A.Decreasethecostbetweentheconnectionobjects.
B.Decreasethereplicationintervalforallconnectionobjects.
C.DecreasethereplicationintervalfortheDEFAULTIPSITELINKobject.
D.DecreasethereplicationschedulefortheDEFAULTIPSITELINKobject.

单项选择题YouareimplementinganASP.NETpage.ThepageincludesamethodnamedGetCustomerOrderDataSetthatreturnsaDataSet.TheDataSetincludesaDataTablenamedCustomerDetailsTableandaDataTablenamedOrderDetailsTable.YouneedtodisplaythedatainOrderDetailsTableinaDetailsViewcontrolnameddtlView.Whichcodesegmentshouldyouuse？（）A.dtlView.DataSource=GetCustomerOrderDataSet（）；dtlView.DataMember= OrderDetailsTable ；dtlView.DataBind（）；B.dtlView.DataSource=GetCustomerOrderDataSet（）；dtlView.DataSourceID= OrderDetailsTable ；dtlView.DataBind（）；C.dtlView.DataSource=GetCustomerOrderDataSet（）；dtlView.DataKeyNames=newstring[]{ OrderDetailsTable }；dtlView.DataBind（）；D.DataSetdataSet=GetCustomerOrderDataSet（）；dtlView.DataSource=newDataTable（ dataSet ， OrderDetailsTable ）；dtlView.DataBind（）；

A.NETpage.ThepageincludesamethodnamedGetCustomerOrderDataSetthatreturnsaDataSet.TheDataSetincludesaDataTablenamedCustomerDetailsTableandaDataTablenamedOrderDetailsTable.YouneedtodisplaythedatainOrderDetailsTableinaDetailsViewcontrolnameddtlView.Whichcodesegmentshouldyouuse？（）
A.dtlView.DataSource=GetCustomerOrderDataSet（）；dtlView.DataMember="OrderDetailsTable"；dtlView.DataBind（）；
B.dtlView.DataSource=GetCustomerOrderDataSet（）；dtlView.DataSourceID="OrderDetailsTable"；dtlView.DataBind（）；
C.dtlView.DataSource=GetCustomerOrderDataSet（）；dtlView.DataKeyNames=newstring[]{"OrderDetailsTable"}；dtlView.DataBind（）；
D.DataSetdataSet=GetCustomerOrderDataSet（）；dtlView.DataSource=newDataTable（"dataSet"，"OrderDetailsTable"）；dtlView.DataBind（）；

单项选择题YourcompanyhasanActiveDirectorydomain.AllserversrunWindowsServer2008.YourcompanyusesanENterpriseRootcertificationauthority（CA）andanEnterpriseIntermediateCA.TheEnterpriseintermediateCAcertificateexpires.YouneedtodeployanewEnterpriseIntermediateCAcertificatetoallcomputersinthedomain.Whatshouldyoudo（）A.ImportthenewcertificateintotheIntermediateCertificationStoreontheEnterpriseRootCAserver.B.ImportthenewcertificateintotheIntermediateCertificationStoreontheEnterpriseIntermediateCAserver.C.ImportthenewcertificateintotheIntermediateCertificationStoreintheDefaultDomainControllersgroupobject.D.ImportthenewcertificateintotheIntermediateCertificationStoreintheDefaultDomaingrouppolicyobject.

A.AllserversrunWindowsServer2008.YourcompanyusesanENterpriseRootcertificationauthority（CA）andanEnterpriseIntermediateCA.TheEnterpriseintermediateCAcertificateexpires.YouneedtodeployanewEnterpriseIntermediateCAcertificatetoallcomputersinthedomain.Whatshouldyoudo（）
A.ImportthenewcertificateintotheIntermediateCertificationStoreontheEnterpriseRootCAserver.
B.ImportthenewcertificateintotheIntermediateCertificationStoreontheEnterpriseIntermediateCAserver.
C.ImportthenewcertificateintotheIntermediateCertificationStoreintheDefaultDomainControllersgroupobject.
D.ImportthenewcertificateintotheIntermediateCertificationStoreintheDefaultDomaingrouppolicyobject.

单项选择题Youneedtodeployaread－onlydomaincontroller（RODC）thatrunsWindowsServer2008.Whatistheminimalforestfunctionallevelthatyoushoulduse（）

A.WindowsServer2008
B.WindowsServer2003Interimmode
C.Windows2000Nativemode
D.WindowsServer2003Nativemode

单项选择题YournetworkconsistsofasingleActiveDirectorydomain.AllserversrunWindowsServer2008R2.AllclientcomputersrunWindows7.UsersstorealloftheirfilesintheirDocumentsfolder.Manyusersstorelargefiles.YouplantoimplementroaminguserprofilesforallusersbyusingGroupPolicy.Youneedtorecommendasolutionthatminimizestheamountoftimeittakesuserstologonandlogoffofthecomputersthatusetheroaminguserprofiles.Whatshouldyourecommend？（）A.ModifytheGroupPolicyobject（GPO）toincludefolderredirection.B.ModifytheGroupPolicyobject（GPO）toincludeBackgroundIntelligentTransferService（BITS）settings.C.Ontheserverthathoststheroaminguserprofiles，enablecachingontheprofilesshare.D.Onanyserver，installandconfiguretheBackgroundIntelligentTransferService（BITS）serverextensions.

A.AllserversrunWindowsServer2008R2.AllclientcomputersrunWindows7.UsersstorealloftheirfilesintheirDocumentsfolder.Manyusersstorelargefiles.YouplantoimplementroaminguserprofilesforallusersbyusingGroupPolicy.Youneedtorecommendasolutionthatminimizestheamountoftimeittakesuserstologonandlogoffofthecomputersthatusetheroaminguserprofiles.Whatshouldyourecommend？（）
A.ModifytheGroupPolicyobject（GPO）toincludefolderredirection.
B.ModifytheGroupPolicyobject（GPO）toincludeBackgroundIntelligentTransferService（BITS）settings.
C.Ontheserverthathoststheroaminguserprofiles，enablecachingontheprofilesshare.
D.Onanyserver，installandconfiguretheBackgroundIntelligentTransferService（BITS）serverextensions.