搜题

【单选题】

The&ensp;SQL&ensp;Tuning&ensp;Advisor&ensp;configuration&ensp;has&ensp;default&ensp;settings&ensp;in&ensp;your&ensp;database&ensp;instance.&ensp;<br /> Which&ensp;recommendation&ensp;is&ensp;automatically&ensp;implemented&ensp;after&ensp;the&ensp;SQL&ensp;Tuning&ensp;Advisor&ensp;is&ensp;run&ensp;as&ensp;part&ensp;of&ensp;the&ensp;automatic&ensp;maintenance&ensp;task？（）

A、 statistics recommendations

B、 SQL Profile recommendations

C、 Index-related recommendations

D、 restructuring of SQL recommendations

查看正确答案

更多“ The&ensp;SQL&ensp;Tuning&ensp;Advisor&ensp;configuration&ensp;has&ensp;default&ensp;settings&ensp;in&ensp;your&ensp;database&ensp;instance.&ensp;<br /> Which&ensp;recommendation&ensp;is&ensp;automatically&ensp;implemented&ensp;after&ensp;the&ensp;SQL&ensp;Tuning&ensp;Advisor&ensp;is&ensp;run&ensp;as&ensp;part&ensp;of&ensp;the&ensp;automatic&ensp;maintenance&ensp;task？（）”相关的问题

第1题

[单选题] Your company has two SQL Server 2005 computers named SQL1 and SQL2. Transaction log shipping occurs from SQL1 to SQL2 by using default SQL Server Agent schedule settings. You need toreconfigure transaction log shipping to provide minimum latency on SQL2. What should you do?（）

A、&ensp;On&ensp;SQL1,&ensp;reschedule&ensp;the&ensp;transaction&ensp;log&ensp;backup&ensp;job&ensp;so&ensp;that&ensp;it&ensp;occurs&ensp;every&ensp;minute.&ensp;On&ensp;SQL2,&ensp;maintain&ensp;default&ensp;schedule&ensp;settings&ensp;for&ensp;both&ensp;the&ensp;log&ensp;shipping&ensp;copy&ensp;and&ensp;the&ensp;restore&ensp;jobs.&ensp; B、&ensp;On&ensp;SQL1,&ensp;change&ensp;the&ensp;schedule&ensp;type&ensp;for&ensp;the&ensp;transaction&ensp;log&ensp;backup&ensp;to&ensp;Start&ensp;automatically&ensp;when&ensp;SQL&ensp;Server&ensp;Agent&ensp;starts.&ensp;On&ensp;SQL2,&ensp;change&ensp;the&ensp;schedule&ensp;types&ensp;for&ensp;both&ensp;the&ensp;log&ensp;shipping&ensp;copy&ensp;and&ensp;the&ensp;restore&ensp;jobs&ensp;to&ensp;Start&ensp;automatically&ensp;when&ensp;SQL&ensp;Server&ensp;Agent&ensp;starts.&ensp; C、&ensp;On&ensp;SQL1,&ensp;maintain&ensp;default&ensp;schedule&ensp;settings&ensp;for&ensp;the&ensp;transaction&ensp;log&ensp;backup&ensp;job.&ensp;On&ensp;SQL2,&ensp;change&ensp;the&ensp;schedule&ensp;types&ensp;for&ensp;both&ensp;the&ensp;log&ensp;shipping&ensp;copy&ensp;and&ensp;the&ensp;restore&ensp;jobs&ensp;to&ensp;Start&ensp;automatically&ensp;when&ensp;SQL&ensp;Server&ensp;Agent&ensp;starts.&ensp; D、&ensp;On&ensp;SQL1,&ensp;reschedule&ensp;the&ensp;transaction&ensp;log&ensp;backup&ensp;job&ensp;so&ensp;that&ensp;it&ensp;occurs&ensp;every&ensp;minute.&ensp;On&ensp;SQL2,&ensp;reschedule&ensp;both&ensp;the&ensp;log&ensp;shipping&ensp;copy&ensp;and&ensp;the&ensp;restore&ensp;jobs&ensp;so&ensp;that&ensp;they&ensp;occur&ensp;every&ensp;minute.&ensp;

点击查看答案

第2题

[单选题] You are a database administrator of two SQL Server 2005 computers named SQL1 and SQL2. You have a Microsoft .NET application that has been modified so that it now accesses a database on SQL2 in addition to SQL1. You do not want the user application to connect directly to SQL2. You need to enable the data retrieval from SQL2 while maintaining the ability to assign different permissions to different users who use the .NET application. What should you do？（）

A、Change&ensp;the&ensp;.NET&ensp;application&ensp;to&ensp;define&ensp;a&ensp;new&ensp;server&ensp;connection&ensp;to&ensp;SQL2. B、Configure&ensp;a&ensp;linked&ensp;server&ensp;on&ensp;SQL1&ensp;to&ensp;point&ensp;to&ensp;SQL2. C、Configure&ensp;a&ensp;linked&ensp;server&ensp;on&ensp;SQL2&ensp;to&ensp;point&ensp;to&ensp;SQL1. D、Change&ensp;the&ensp;stored&ensp;procedures&ensp;called&ensp;by&ensp;the&ensp;.NET&ensp;application&ensp;to&ensp;include&ensp;the&ensp;OPENXML&ensp;command.

点击查看答案

第3题

[单选题] Your&ensp;application&ensp;must&ensp;access&ensp;data&ensp;that&ensp;is&ensp;located&ensp;on&ensp;two&ensp;SQL&ensp;Server&ensp;2005&ensp;computers.&ensp;One&ensp;of&ensp;these&ensp;servers&ensp;is&ensp;named&ensp;SQL1&ensp;and&ensp;the&ensp;other&ensp;is&ensp;SQL2.&ensp;You&ensp;have&ensp;permissions&ensp;to&ensp;create&ensp;a&ensp;stored&ensp;procedure&ensp;on&ensp;SQL1&ensp;to&ensp;support&ensp;your&ensp;application.&ensp;However，on&ensp;SQL2&ensp;you&ensp;only&ensp;have&ensp;permissions&ensp;to&ensp;select&ensp;data.&ensp;You&ensp;write&ensp;the&ensp;stored&ensp;procedure&ensp;on&ensp;SQL1.&ensp;The&ensp;stored&ensp;procedure&ensp;accesses&ensp;SQL2&ensp;by&ensp;using&ensp;the&ensp;OPENQUERY&ensp;Transact-SQL&ensp;statement.&ensp;However,the&ensp;query&ensp;fails&ensp;when&ensp;executed.You&ensp;need&ensp;to&ensp;troubleshoot&ensp;the&ensp;cause&ensp;of&ensp;the&ensp;error. What&ensp;should&ensp;you&ensp;do？（）

A、Join&ensp;the&ensp;two&ensp;servers&ensp;by&ensp;using&ensp;the&ensp;four-part&ensp;syntax&ensp;of&ensp;server.database.schema.table. B、Reference&ensp;SQL2&ensp;by&ensp;using&ensp;an&ensp;alias. C、Add&ensp;SQL2&ensp;as&ensp;a&ensp;remote&ensp;server&ensp;to&ensp;SQL1. D、Add&ensp;SQL2&ensp;as&ensp;a&ensp;linked&ensp;server&ensp;to&ensp;SQL1.

点击查看答案

第4题

[单选题] Which statement is true when you run the SQL Tuning Advisor with limited scope？（）

A、Access&ensp;path&ensp;analysis&ensp;is&ensp;not&ensp;performed&ensp;for&ensp;the&ensp;SQL&ensp;statements. B、SQL&ensp;structure&ensp;analysis&ensp;is&ensp;not&ensp;performed&ensp;for&ensp;the&ensp;SQL&ensp;statements. C、SQL&ensp;Profile&ensp;recommendations&ensp;are&ensp;not&ensp;generated&ensp;for&ensp;the&ensp;SQL&ensp;statements. D、The&ensp;staleness&ensp;and&ensp;absence&ensp;of&ensp;the&ensp;statistics&ensp;are&ensp;not&ensp;checked&ensp;for&ensp;the&ensp;objects&ensp;in&ensp;the&ensp;query&ensp;supplied&ensp;to&ensp;the&ensp;SQL&ensp;Tuning&ensp;Advisor.

点击查看答案

第5题

[多选题] Which two statements are true regarding the SQL Repair Advisor？（）

A、&ensp;The&ensp;SQL&ensp;Repair&ensp;Advisor&ensp;can&ensp;be&ensp;invoked&ensp;to&ensp;tune&ensp;the&ensp;performance&ensp;of&ensp;the&ensp;regressed&ensp;SQL&ensp;statements. B、&ensp;The&ensp;SQL&ensp;Repair&ensp;Advisor&ensp;can&ensp;be&ensp;invoked&ensp;even&ensp;when&ensp;the&ensp;incident&ensp;is&ensp;not&ensp;active&ensp;for&ensp;a&ensp;SQL&ensp;statement&ensp;crash. C、&ensp;The&ensp;SQL&ensp;Repair&ensp;Advisor&ensp;is&ensp;invoked&ensp;by&ensp;the&ensp;Health&ensp;Monitor&ensp;when&ensp;it&ensp;encounters&ensp;the&ensp;problematic&ensp;SQL&ensp;statement. D、&ensp;The&ensp;DBA&ensp;can&ensp;invoke&ensp;the&ensp;SQL&ensp;Repair&ensp;Advisor&ensp;when&ensp;he&ensp;or&ensp;she&ensp;receives&ensp;an&ensp;alert&ensp;generated&ensp;when&ensp;a&ensp;SQL statement&ensp;crashes&ensp;and&ensp;an&ensp;incident&ensp;is&ensp;created&ensp;in&ensp;the&ensp;ADR.

点击查看答案

第6题

[单选题] You&ensp;run&ensp;the&ensp;SQL&ensp;Tuning&ensp;Advisor&ensp;（STA）&ensp;to&ensp;tune&ensp;a&ensp;SQL&ensp;statement&ensp;that&ensp;is&ensp;part&ensp;of&ensp;a&ensp;fixed&ensp;SQL&ensp;plan&ensp;baseline.&ensp;The&ensp;STA&ensp;generates&ensp;a&ensp;SQL&ensp;profile&ensp;for&ensp;the&ensp;SQL&ensp;statement，which&ensp;recommends&ensp;that&ensp;you&ensp;accept&ensp;the&ensp;profile.&ensp; Which&ensp;statement&ensp;is&ensp;true&ensp;when&ensp;you&ensp;accept&ensp;the&ensp;suggested&ensp;SQL&ensp;profile？（）&ensp;&ensp;

A、&ensp;The&ensp;tuned&ensp;plan&ensp;is&ensp;not&ensp;added&ensp;to&ensp;the&ensp;SQL&ensp;plan&ensp;baseline. B、&ensp;The&ensp;tuned&ensp;plan&ensp;is&ensp;added&ensp;to&ensp;the&ensp;fixed&ensp;SQL&ensp;plan&ensp;baseline&ensp;as&ensp;a&ensp;fixed&ensp;plan. C、&ensp;The&ensp;tuned&ensp;plan&ensp;is&ensp;added&ensp;to&ensp;the&ensp;fixed&ensp;SQL&ensp;plan&ensp;baseline&ensp;as&ensp;a&ensp;nonfixed&ensp;plan. D、&ensp;The&ensp;tuned&ensp;plan&ensp;is&ensp;added&ensp;to&ensp;a&ensp;new&ensp;nonfixed&ensp;SQL&ensp;plan&ensp;baseline&ensp;as&ensp;a&ensp;nonfixed&ensp;plan.

点击查看答案

第7题

[单选题] 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. You configure the SQL Server instance to use the -T1222 and -T1204 trace flags during startup. You must make sure that your failure recovery plan performs backup of the use of the trace flags. So what action should you perform to achieve this goal? （）

A、You&ensp;should&ensp;backup&ensp;the&ensp;master&ensp;database B、You&ensp;should&ensp;backup&ensp;the&ensp;default.trc&ensp;file C、You&ensp;should&ensp;backup&ensp;the&ensp;SQL&ensp;Server&ensp;registry&ensp;hive. D、You&ensp;should&ensp;backup&ensp;the&ensp;resource&ensp;database&ensp;

点击查看答案

第8题

[单选题] TestKing.com&ensp;has&ensp;two&ensp;SQL&ensp;Server&ensp;2005&ensp;computers&ensp;named&ensp;SQL1&ensp;and&ensp;SQL2.&ensp;Transaction&ensp;log&ensp;shipping&ensp;occurs&ensp;from&ensp;SQL1&ensp;to&ensp;SQL2&ensp;by&ensp;using&ensp;default&ensp;SQL&ensp;Server&ensp;Agent&ensp;schedule&ensp;settings. You&ensp;need&ensp;to&ensp;reconfigure&ensp;transaction&ensp;log&ensp;shipping&ensp;to&ensp;provide&ensp;minimum&ensp;latency&ensp;on&ensp;SQL2. What&ensp;should&ensp;you&ensp;do？（）

A、On&ensp;SQL1，&ensp;reschedule&ensp;the&ensp;transaction&ensp;log&ensp;backup&ensp;job&ensp;so&ensp;that&ensp;it&ensp;occurs&ensp;every&ensp;minute.&ensp;On&ensp;SQL2，&ensp;maintain&ensp;default&ensp;schedule&ensp;settings&ensp;for&ensp;both&ensp;the&ensp;log&ensp;shipping&ensp;copy&ensp;and&ensp;the&ensp;restore&ensp;jobs. B、On&ensp;SQL1，change&ensp;the&ensp;schedule&ensp;type&ensp;for&ensp;the&ensp;transaction&ensp;log&ensp;backup&ensp;to&ensp;Start automatically&ensp;when&ensp;SQL&ensp;server&ensp;Agent&ensp;starts.&ensp;On&ensp;SQL2，&ensp;change&ensp;the&ensp;schedule&ensp;types&ensp;for&ensp;both&ensp;the&ensp;log&ensp;shipping&ensp;copy&ensp;and&ensp;the&ensp;restore&ensp;jobs&ensp;to&ensp;Start&ensp;automatically&ensp;when&ensp;SQL&ensp;Server&ensp;gent&ensp;starts. C、On&ensp;SQL1，&ensp;maintain&ensp;default&ensp;schedule&ensp;settings&ensp;for&ensp;the&ensp;transaction&ensp;log&ensp;backup&ensp;job.&ensp;On&ensp;SQL2，&ensp;change&ensp;the&ensp;schedule&ensp;types&ensp;for&ensp;both&ensp;the&ensp;log&ensp;shipping&ensp;copy&ensp;and&ensp;the&ensp;restore&ensp;jobs&ensp;to&ensp;Start&ensp;automatically&ensp;when&ensp;SQL&ensp;server&ensp;Agent&ensp;starts. D、On&ensp;SQL1，&ensp;reschedule&ensp;the&ensp;transaction&ensp;log&ensp;backup&ensp;job&ensp;so&ensp;that&ensp;it&ensp;occurs&ensp;every&ensp;minute.&ensp;On&ensp;SQL2，&ensp;reschedule&ensp;both&ensp;the&ensp;log&ensp;shipping&ensp;copy&ensp;and&ensp;the&ensp;restore&ensp;jobs&ensp;so&ensp;that&ensp;they&ensp;occur&ensp;every&ensp;minute.

点击查看答案

第9题

[单选题] You are maintaining the PROD database of NetFx Corporation. You set the value of the SQL_TRACE parameter to TRUE. What will be the impact of this setting？（）

A、&ensp;The&ensp;SQL&ensp;trace&ensp;facility&ensp;will&ensp;generate&ensp;the&ensp;performance&ensp;statistics&ensp;for&ensp;all&ensp;the&ensp;SQL&ensp;statements&ensp;for&ensp;an&ensp;instance&ensp;and&ensp;write&ensp;them&ensp;in&ensp;the&ensp;USER_DUMP_DEST&ensp;directory. B、&ensp;The&ensp;SQL&ensp;trace&ensp;facility&ensp;will&ensp;generate&ensp;the&ensp;performance&ensp;statistics&ensp;for&ensp;all&ensp;the&ensp;SQL&ensp;statements&ensp;for&ensp;a&ensp;session&ensp;and&ensp;write&ensp;them&ensp;in&ensp;the&ensp;USER_DUMP_DEST&ensp;directory. C、&ensp;The&ensp;SQL&ensp;trace&ensp;facility&ensp;will&ensp;generate&ensp;the&ensp;performance&ensp;statistics&ensp;for&ensp;all&ensp;the&ensp;SQL&ensp;statements&ensp;for&ensp;an&ensp;instance&ensp;and&ensp;write&ensp;them&ensp;in&ensp;the&ensp;BACKGROUND_DUMP_DEST&ensp;directory. D、&ensp;The&ensp;SQL&ensp;trace&ensp;facility&ensp;will&ensp;generate&ensp;the&ensp;performance&ensp;statistics&ensp;for&ensp;all&ensp;the&ensp;SQL&ensp;statements&ensp;for&ensp;a&ensp;session&ensp;and&ensp;write&ensp;them&ensp;in&ensp;the&ensp;BACKGROUND_DUMP_DEST&ensp;directory.

点击查看答案

第10题

[] You&ensp;work&ensp;in&ensp;a&ensp;company&ensp;which&ensp;is&ensp;named&ensp;Wiikigo&ensp;Corp.&ensp;The&ensp;company&ensp;uses&ensp;SQL&ensp;Server&ensp;2008.&ensp;You&ensp;are&ensp;the&ensp;administrator&ensp;of&ensp;the&ensp;company&ensp;database.&ensp;Now&ensp;you&ensp;are&ensp;in&ensp;charge&ensp;of&ensp;a&ensp;SQL&ensp;Server&ensp;2008&ensp;instance.&ensp;You&ensp;configure&ensp;the&ensp;SQL&ensp;Server&ensp;instance&ensp;to&ensp;use&ensp;the&ensp;-T1222&ensp;and&ensp;-T1204&ensp;trace&ensp;flags&ensp;during&ensp;startup.&ensp;You&ensp;must&ensp;make&ensp;sure&ensp;that&ensp;your&ensp;failure&ensp;recovery&ensp;plan&ensp;performs&ensp;backup&ensp;of&ensp;the&ensp;use&ensp;of&ensp;the&ensp;trace&ensp;flags.&ensp; So&ensp;what&ensp;action&ensp;should&ensp;you&ensp;perform&ensp;to&ensp;achieve&ensp;this&ensp;goal?（）&ensp;&ensp; You&ensp;work&ensp;in&ensp;a&ensp;company&ensp;which&ensp;is&ensp;named&ensp;Wiikigo&ensp;Corp.&ensp;The&ensp;company&ensp;uses&ensp;SQL&ensp;Server

A、A.You&ensp;should&ensp;backup&ensp;the&ensp;master&ensp;database B、B.You&ensp;should&ensp;backup&ensp;the&ensp;default.trc&ensp;file&ensp; C、C.You&ensp;should&ensp;backup&ensp;the&ensp;SQL&ensp;Server&ensp;registry&ensp;hive.&ensp; D、D.You&ensp;should&ensp;backup&ensp;the&ensp;resource&ensp;database&ensp;

点击查看答案

账号：登录

答题记录

我的收藏

我的题库

客服

TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服