单项选择题

A.A policy should be created. The policy targets the na……

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. According to the company requirement, the names of all user-defined stored procedures must contain the prefix usp_ on all instances. Besides this, you must make sure that stored procedures that do not contain this prefix cannot be created by you. What should you do?（）

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.

单项选择题YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDB1intheinstance.OnDB1,quitefewloggedoperationsareperformed.NowaccordingtotherequirementofthecompanyCIO,youmustvalidatethatthedatabasecanberestoredtoaspecificpointintime.Sowhatactionshouldyouperformtoachievethisgoal?（）

A.You should verify that the simple recovery model is used by the database.
B.You should verify that the full recovery model is used by the database.
C.You should verify that the checksum page verify option is used by the database.
D.You should verify that the bulk-logged recovery model is used by the database.

单项选择题YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.Thereisacomputerwhichhostsseveralapplicationsinyourcompany.Theinstancerunsonthecomputer.AjobnamedDiliveryListiscreatedbyyou.Thisjobrequiresafiletobewrittentoafileserver.Butbecausethejobcannotaccessthefileserver,itfailstorun.YouintendtoconfiguretheSQLServerAgentservicesothatonlytheSQLServerAgentservicehasreadandwriteaccesstothefileserver.Whichaccounttypeshouldyouuse?（）

A.You should use local Service account
B.You should use network Service account
C.You should use domain account
D.You should use local System account