You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?（）..

第1题

[] You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously. Dim ar As IAsyncResult = cmd.BeginExecuteReader() You need to execute a method named DoWork() that takes one second to run while the SQL query is executing. DoWork() must run as many times as possible while the SQL query is executing. Which code segment should you use?（） You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously. Dim ar As IAsyncResult = cmd.BeginExecuteReader() You need to execute a method named DoWork() that takes one second to run while the SQL query is executing. DoWork() must run as many times as possible while the SQL query is executing. Which code segment should you use?（）

A、A.
B.
C.
D.

点击查看答案

第2题

[单选题] View the Exhibit to examine the Automatic SQL Tuning result details.Which action would you suggest for the selected SQL statement in the Exhibit?（）

A、Accept the recommended SQL profile. B、Collect statistics for the related objects. C、Run the Access Advisor for the SQL statement. D、Run the Segment Advisor for recommendations.

点击查看答案

第3题

[单选题] You work with a newly created database. Presently, there is no application load on the database instance.You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.What action must you take to achieve this?（）

A、Run Segment Advisor B、Run the SQL Tuning Advisor (STA) C、Run the Automatic Workload Repository (AWR) report D、Run the SQL Access Advisor with a hypothetical workload

点击查看答案

第4题

[单选题] You work with a newly created database. Presently, there is no application load on the database instance.You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.What action must you take to achieve this?（）

A、Run Segment Advisor B、Run the SQL Tuning Advisor (STA) C、Run the Automatic Workload Repository (AWR) report D、Run the SQL Access Advisor with a hypothetical workload

点击查看答案

第5题

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

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

点击查看答案

第6题

[单选题] You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously.IAsyncResult ar = cmd.BeginExecuteReader（　）;You need to execute a method named Do Work（　） that takes one second to run while the SQL query is executing. DoWork（　） must run as many times as possible while the SQL query is executing. Which code segment should you use? （）

A、while（ar.AsyncWaitHandle==null）{DoWork（）；}dr=cmd.EndExecuteReader（ar）； B、while（!ar.IsCompleted）{DoWork（）；}dr=cmd.EndExecuteReader（ar）； C、while（Thread.CurrentThread.ThreadState==ThreadState.Running）{DoWork（）；}dr=cmd.EndExecuteReader（ar）； D、while（!ar.AsyncWaitHandle.WaitOne（））{DoWork（）；}dr=cmd.EndExecuteReader（ar）；

点击查看答案

第7题

[单选题] You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance？（）

A、run Segment Advisor B、run SQL Tuning Advisor on top SQL statements C、run the Automatic Workload Repository （AWR） report D、run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements

点击查看答案

第8题

[单选题] You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously.Dim ar As IAsyncResult = cmd.BeginExecuteReader（　）You need to execute a method named DoWork（　） that takes one second to run while the SQL query is executing. DoWork（　） must run as many times as possible while the SQL query is executing. Which code segment should you use?（）

A、While ar.AsyncWaitHandle Is Nothing DoWork()End Whiledr = cmd.EndExecuteReader(ar) B、While Not ar.IsCompleted DoWork()End Whiledr = cmd.EndExecuteReader(ar) C、While T hread.CurrentThread.ThreadState = ThreadState.Running DoWork()End Whiledr = cmd.EndExecuteReader(ar) D、While Not ar.AsyncWaitHandle.WaitOne() DoWork()End Whiledr = cmd.EndExecuteReader(ar)

点击查看答案

第9题

[单选题] You are a network administrator for your company. All servers run Windows Server 2003. You manage a file server named Server8. You need to create a performance baseline for Server8 by using Performance Logs and Alerts. You need to store the performance data in an existing Microsoft SQL Server database on another computer. You create a new counter log, and you select SQL Database as the log file format. When you attempt to save your changes, you receive an error message stating that you must select a data source name. You examine the configuration of the SQL Logs, as shown in the following dialog box. You need to configure the counter log to use a SQL database. What should you do? （）

A、Use the relog command-line utility to configure a connection to your SQL database. B、Use Add or Remove programs to install Connection Point Services. Configure a connection to your SQL database. C、Use the logman command-line utility with the create switch to configure a connection to your SQL database. D、Use Data Sources (ODBC) to configure a connection to your SQL database.

点击查看答案

You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?（）

请使用微信扫码支付