单项选择题

YouworkinacompanywhichisnamedWiikigoCorp.Thecompanyuses……

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, you migrate an application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance, and record the use of features which will be discontinued. What should you do? （）

A.The SQL Server 2008 Upgrade Advisor should be used
B.You should use a SQL server-side trace. The trace captures the Deprecation Announcement and Deprecation Final Support event classes
C.You should use the SQL Server Profiler. The profiler captures the SQL:BatchCompleted and Exception event classes
D.You should use a SQL server-side trace. The trace captures the SQL:BatchCompleted and Exception event classes.

<上一题目录下一题>

热门试题

单项选择题YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.Todayyounoticethatapplicationsthatrunontheserverhavepoorperformances.Youdoubtthatthishassomethingtodowithtablescans.YouhavetocapturetheappropriateinformationbyusinganappropriateWindowsSystemMonitorobject.Intheoptionsbelow,whichperformanceobjectshouldyouuse?（）

A.You should use SQLServer:Buffer Manager
B.You should use SQLServer:Memory Manager
C.You should use SQLServer:Databases
D.You should use SQLServer:Access Methods

单项选择题YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.TheserverhasaverylargedatabasenamedDB1.AnapplicationwhichisconstantlyavailableusesDB1.Nowyougetareportfromusers,inthereportuserscomplainthatserverhasapoorperformance.Asthetechnicalsupport,youhavetoimprovetheperformanceoftheapplicationbyusingtheDatabaseEngineTuningAdvisor.Besidesthis,youmustmakesurethattheactionofanalyzingtheworkloadwillnotaffecttheperformanceoftheproductionserver.Sowhatshouldyoudo?（）

A.On the local server, enable the XP_MSVER stored procedure
B.On the remote server, enable the XP_MSVER stored procedure.
C.On the production server, use the dta.exe utility along with an XML input file.
D.You should configure a test server that has a similar hardware configuration. Use the dta.exe utility on the test server along with an XML input file

单项选择题YouworkinaOrganizationwhichisnamedWiikigoCorp.TheOrganizationusesSQLServer2008.YouaretheadministratoroftheOrganizationdatabase.NowyouareinchargeofaSQLServer2008instance.Lookatthefollowingquery:SELECTs.*,i.*FROMSensitiveTblASsINNERJOINInsensitiveTblASiONi.OrganizationName=s.OrganizationNameYouusetheabovequerytojointwotablesonacolumnnamedOrganizationName.Thefollowingerrorisreturnedwhenyouexecutethequery. Msg468,Level16,State9,Line17Cannotresolvethecollationconflictbetween'SQL_Latin1_General_CP1_CS_AS'and'SQL_Latin1_General_CP1_CI_AS'intheequaltooperation. TheONclauseofthequeryhastobemodifiedsothatitcanperformacase-sensitivejoinsuccessfully.Whatshouldyoudo?（）

A.ON LOWER(i.OrganizationName) = LOWER(s.OrganizationName)
B.ON UPPER(i.OrganizationName) = UPPER(s.OrganizationName)
C.ON i.OrganizationName = s.OrganizationName COLLATE SQL_Latin1_General_CP1_CS_AS
D.ON i.OrganizationName = s.OrganizationName COLLATE SQL_Latin1_General_CP1_CI_AS

单项选择题YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasewhichisnamedSellingsintheinstance.TheSellingsdatabasecontainsatablenamedProductions.Thetableisusedtostoresinformationaboutalltypesofproducts.TheProductionstableisoftenqueriedbyusersonthebasisoftheRadioSizecolumn.TheRadioSizecolumncontainstheNULLvalueforallproductsotherthanRadios.Currentlynoindex existsontheRadionSizecolumn.AccordingtotherequirementofthecompanyCIO,youhavetooptimizethequeryperformanceandreducetheeffectonthediskspacetotheleast.Sowhatactionshouldyouperformtoachievethisgoal?（）

A.On the Products table, you should create a view.
B.On the RadioSize column, you should create a clustered index
C.On the RadioSize column, you should create a filtered index
D.On the RadioSize column, you should create a unique clustered index

单项选择题YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDworksintheinstance.TheDworksdatabasehasatable namedOrderthings.Accordingtothecompanyrequirement,youhavetoexportalldatafromtheOrderthingstabletoafile.Duringtheexport,youmustmakesurethatthedataexportprocessissavedforreuseandaMicrosoftOfficeOpenXMLdocumentformatisused.Whatshouldyoudo?（）

A.You should run the bulk copy program utility along with an output file and no format file
B.You should run the SQLCmd utility and save the output to a file
C.You should run the SQL Import and Export Data Wizard and save the output to a file.
D.You should run the bulk copy program utility along with a format file and an output file.