单项选择题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;