black

MCITP(70-431)

登录

多项选择题

Your company uses SQL Server 2005. Users report that report execution is slow. You investigate and discover that some queries do not use optimal execution plans. You also notice that some optimizer statistics are missing and others are out of date. You need to correct the problem so that reports execute more quickly. Which two Transact-SQL statements should you use?()

A. DBCC CHECKTABLE 
B. ALTER INDEX REORGANIZE 
C. UPDATE STATISTICS 
D. CREATE STATISTICS 
E. DBCC SHOW_STATISTICS 
F. DBCC UPDATEUSAGE

相关考题

单项选择题 A support engineer reports that inserting new sales transactions in a SQL Server 2005 database results in an error. You investigate the error. You discover that in one of the databases, a developer has accidentally deleted some data in a table that is critical for transaction processing. The database uses the full recovery model. You need to restore the table. You need to achieve this goal without affecting the availability of other data in the database.  What should you do?()

单项选择题 YouconfigureanewSQLServer2005computertouseTCP/IPwithalldefaultsettings.Yourcorporatepolicyrequiresthateachserveruseafirewall.YoufindthatyoucanconnecttotheSQLServerinstancefromthelocalcomputer.However,clientcomputerscannotconnecttotheSQLServerinstance.Youneedtoidentifythemostlikelycauseoftheconnectionissues.Whatshouldyoudofirst?()

单项选择题 YourcompanyhastwoSQLServer2005computersnamedSQL1andSQL2.AuserinyourcompanynamedEricwritesmanyadhocqueriesagainstthecompanydatabases.ErichasaccesstotheCustomerdatabaseonSQL1.HedoesnothaveaccesstotheSalesdatabaseonSQL2.YouneedtoensurethatEriccanwritequeriesthatjoininformationfrombothservers.Whatshouldyoudofirst?()

All Rights Reserved 版权所有©考试题库网(kstiku.com)

备案号:湘ICP备14005140号-3

经营许可证号:湘B2-20140064