单项选择题

A.A new partition function should be created B.You shou……

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 a SQL Server 2008 instance. There is a database named Dworks in the instance. The Dworks database has a table named Orderthings. The Orderthings table is partitioned on the OrderId column. The first partition contains integer values greater than 100,000, while the second partition contains integer values between 1 and 100,000. You have to add a new partition. The new partition should contain integer values greater than 200,000. What should you do? （）

A.A new partition function should be created
B.You should change the existing partition scheme
C.You should use a Merge clause to change the existing partition function
D.You should use a Split clause to change the existing partition function

<上一题目录下一题>

热门试题

单项选择题YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.YoumustmakesurethatallSQLServerinstancesareconsistentlyconfiguredfornamingconventions,securitysettings,forceindexcreationandavoidanceofdatafragmentation.Sowhatactionshouldyouperformtoachievethisgoal?（）

A.You should use the Database Engine Tuning Advisor.
B.In Microsoft SQL Server Management Studio, you should create a maintenance plan
C.You should use the SQL Server Configuration Manager
D.In Microsoft SQL Server Management Studio, you should create a policy

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

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