单项选择题
A.You should use the http.sys listener to install the SSRS instance.
B.You should configure the SSRS database, make it use Native mode
C.You should configure the SSRS database, make it use SharePoint integrated mode
D.You should use the Internet Information Services default Web site to install the SSRS instance
单项选择题 YouworkinacompanywhichusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.Therearequeriesthathaveanestimatedexecutioncostlessthan3.Youintendtoconfiguretheinstance,makeituseasinglethreadforthesequeries.Intheoptionsbelow,whichsp_configureconfigurationoptionshouldyouset?()
单项选择题 YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDB1intheinstance.DB1isavailabletoaWindowsgroupwhichisnamedWIIKIGO\Supervisors.AWindowsusernamedUser1isamemberoftheWIIKIGO\Supervisorsgroup.WIIKIGO\Supervisorsisamemberofthedb_ownerroleintheDB1database.YoumustmakesurethattheSQLServerinstanceisavailabletoUser1.IntheDB1database,whichTransact-SQLstatement(s)shouldyouexecute?()
单项选择题 YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDB1intheinstance.DB1hasatablewhichisnamedTable01andastoredprocedurenamedProcedure01.Procedure01choosedatafromTable01byusingasp_executesqlTransact-SQLstatement.Youcompanysecurityrulesforbiduserstoaccesstablesdirectlyinanydatabase.Lookattheexceptionbelow:"Msg229,Level14,State5,Line1TheSELECTpermissionwasdeniedontheobject'Table01',database 'DB1',schema'dbo'."TheexceptionisraisedwhenProcedure01isexecutedbyusers.YoumustmakesurethateusercansuccessfullyexecuteProcedure1complyingwiththecompanyrules.Sowhatactionshouldyouperformtoachievethisgoal?()