单项选择题
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There are queries that have an estimated execution cost less than 3. You intend to configure the instance, make it use a single thread for these queries. In the options below, which sp_configure configuration option should you set?()
A.You should set query governor cost limit
B.You should set cost threshold for parallelism
C.You should set priority boost
D.You should set precompute rank
相关考题
-
单项选择题
YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDB1intheinstance.DB1isavailabletoaWindowsgroupwhichisnamedWIIKIGO\Supervisors.AWindowsusernamedUser1isamemberoftheWIIKIGO\Supervisorsgroup.WIIKIGO\Supervisorsisamemberofthedb_ownerroleintheDB1database.YoumustmakesurethattheSQLServerinstanceisavailabletoUser1.IntheDB1database,whichTransact-SQLstatement(s)shouldyouexecute?()
A. DROP LOGIN "WIIKIGO\User1";
B. EXEC dbo.sp_droprolemember 'db_owner', 'WIIKIGO\User1';
C. EXEC dbo.sp_revokedbaccess 'WIIKIGO\User1';EXEC dbo.sp_revokelogin 'WIIKIGO\User1';
D. CREATE LOGIN "WIIKIGO\User1" FROM Windows;DENY CONNECT SQL TO "WIIKIGO\User1"; -
单项选择题
YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDB1intheinstance.DB1hasatablewhichisnamedTable01andastoredprocedurenamedProcedure01.Procedure01choosedatafromTable01byusingasp_executesqlTransact-SQLstatement.Youcompanysecurityrulesforbiduserstoaccesstablesdirectlyinanydatabase.Lookattheexceptionbelow:"Msg229,Level14,State5,Line1TheSELECTpermissionwasdeniedontheobject'Table01',database 'DB1',schema'dbo'."TheexceptionisraisedwhenProcedure01isexecutedbyusers.YoumustmakesurethateusercansuccessfullyexecuteProcedure1complyingwiththecompanyrules.Sowhatactionshouldyouperformtoachievethisgoal?()
A.You should execute the GRANT SELECT ON dbo.Table01 TO User1 Transact-SQL statement.
B.You should execute the GRANT EXECUTE ON dbo.Procedure1 TO User1 Transact-SQL statement.
C.You should alter Procedure01 and add the WITH EXECUTE AS OWNER option to its header
D.You should alter Procedure01 and add the EXECUTE AS USER = 'dbo' option immediately before the call to the sp_executesql stored procedure. -
单项选择题
YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisatextfilewhichisnamedSQL01.logontheE:drive.ASQLServerAgentjobexecutesevery2minutesandlogsinformationtothetextfile.Yougetareportfromuserssayingthattheseverdoesn'tmakeresponse.Asthetechnicalsupport,youcheckandfindthattheSQLServerAgentservicedoesnotrunandtheSQLServerAgentjobnolongerfunctions.YouhavetoidentifythereasonwhytheSQLServerAgentserviceisunresponsive.Intheoptionsbelow,whichlogshouldyoucheck?()
A.You should check SQL1.log
B.You should check SQLAGENT.OUT
C.You should check log_xx.trc
D.You should check ERRORLOG
