单项选择题

A.You should terminate and restart the MSFTESQL service……

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?（）

A.You should configure SQL Server VSS Writer
B.You should configure Distributed File System
C.You should configure SQL Server
D.You should configure SQL Server Full Text

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

A.You should install SQL Server 2008 as the default instance, and configure the new application to use the default instance
B.You should upgrade the SQL Server 2005 application to use SQL Server 2008
C.You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance
D.You should install SQL Server 2008 as a named instance, and make the new application use the new instance.

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

A.A policy should be created. The policy targets the name of the stored procedure that is evaluated on demand.
B.A policy should be created. The policy targets the name of the stored procedure that is evaluated on change.
C.A condition should be created. The condition targets the name of the stored procedure that is evaluated on change
D.A condition should be created. The condition targets the name of stored procedure that is evaluated on demand.

单项选择题YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.YouconfiguretheSQLServerinstancetousethe-T1222and-T1204traceflagsduringstartup.Youmustmakesurethatyourfailurerecoveryplanperformsbackupoftheuseofthetraceflags.Sowhatactionshouldyouperformtoachievethisgoal?（）

A.You should backup the master database
B.You should backup the default.trc file
C.You should backup the SQL Server registry hive.
D.You should backup the resource database

单项选择题YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisaSQLServer7.0database.YouupgradethedatabasetotheSQLServerinstance.Accordingtothecompanyrequirement,youmustmakesurethatsuspectpagescanbedetectedinthedatabase.Sowhatactionshouldyouperformtoachievethisgoal?（）

A.For the database, you should turn on the TRUSTWORTHY database option
B.For the database, the PAGE_VERIFY database option should be set to CHECKSUM
C.For the database, the database compatibility level option should be set to 10
D.For the model database, the PAGE_VERIFY database option should be set to TORN_PAGE_DETECTION.