YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.Nowyouareinchargeoftwoinstancesbothofwhichrunonthesamecomputer.OneisaSQLServer2008instance;anotherisaSQLServer2005instance.ThereisadatabasenamedDB1intheSQLServer2008instance.DB1usestheFulltextindexes.Severalrecordsthatincludetheword"root"areaddedtoDB1.AnemptyresultsetisreturnedwhentheFulltextindexisqueriedfortheword"root."Youmustmakesurethequerycanreturnrecordsthatcontaintheword"root".Whatshouldyoudo?（）A.You should terminate and restart the MSFTESQL service B.You should rebuild the full-text index C.The word "root" should be added to the stop list D.The word "root" should be added to the thesaurus file

单项选择题

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of two instances both of which run on the same computer. One is a SQL Server 2008 instance; another is a SQL Server 2005 instance. There is a database named DB1 in the SQL Server 2008 instance. DB1 uses the Fulltext indexes. Several records that include the word "root" are added to DB1. An empty resultset is returned when the Fulltext index is queried for the word "root." You must make sure the query can return records that contain the word "root". What should you do?（）

A.You should terminate and restart the MSFTESQL service
B.You should rebuild the full-text index
C.The word "root" should be added to the stop list
D.The word "root" should be added to the thesaurus file

相关考题

单项选择题 YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.You aretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.NowyourcompanyCIOassignsatasktoyou.ThecompanyCIOwantsyoutoconfigureFILESTREAMdataandthetworequirementsbelowmustbemet:youmustenableFILESTREAMforfileI/Ostreamingaccess;remoteclientcomputersmustbeabletohavestreamingaccesstoFILESTREAMdata.YoumustmakesurethatFILESTREAMdataisenabled.Whichserviceshouldyouconfigure?（）

单项选择题 ouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.Nowforanewapplication,aSQLServer2008instancehastobeinstalledonanexistingserver.TheservercontainsadefaultSQLServer2005instance.YourcompanyCIOwantstheircorrespondingcertifiedthird-partyapplicationscanaccesstobothdatabaseinstances.Thecompanyassignsthistasktoyou.Youmustachievethisbyusingaslittledatabaseadministrativeeffortaspossible,andneverchangetheexistingapplicationenvironments.Whatshouldyoudo?（）

单项选择题 YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.Accordingtothecompanyrequirement,thenamesofalluser-definedstoredproceduresmustcontaintheprefixusp_onallinstances.Besidesthis,youmustmakesurethatstoredproceduresthatdonotcontainthisprefixcannotbecreatedbyyou.Whatshouldyoudo?（）

备案号：湘ICP备14005140号-3

经营许可证号：湘B2-20140064

MCTS(70-432)