搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【多选题】

You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process?（）

A、the SQL text SQL

B、the execution plan

C、the execution context

D、the execution frequency

E、the system change number (SCN)

查看正确答案
更多“You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process?（）”相关的问题
第1题
[单选题] Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements. What would you do with these SQL statements?（）

A、Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.  B、Capture the plans from the previous version using STS and then load them into the stored outline.  C、Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB).  D、Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.  

点击查看答案
第2题
[单选题] 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.  

点击查看答案
第3题
[单选题] 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.  

点击查看答案
第4题
[单选题] You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? （）

A、to minimize plan regression due to the use of a new optimizer version  B、to completely avoid the use of new plans generated by a new optimizer version  C、to prevent plan capturing when the SQL statement is executed after the database upgrade  D、to keep the plan in the plan history so that it can be used when the older version of the optimizer is used  

点击查看答案
第5题
[单选题] You are designing a plan to migrate Microsoft SQL Server 2008 databases to SQL Azure. You do not plan to migrate the SQL Server databases to SQL Server 2008 R2.   You need to recommend an approach for performing bulk data transfers from the SQL Server databases to SQL Azure.  What should you recommend？（）

A、 Use the bcp utility.  B、 Use the dta utility.  C、 Use the SQL Server Import and Export Wizard.  D、 Attach each SQL Server database to SQL Azure.  

点击查看答案
第6题
[单选题] 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.  

点击查看答案
第7题
[] The following parameter are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You want to manage the SQL plan evolution task manually. Examine the following steps: 1. Set the evolve task parameters. 2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function. 3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function. 4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function. 5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function. Identify the correct sequence of steps:（） The following parameter are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You want to manage the SQL plan evolution task manually. Examine the following steps: 1. Set the evolve task para

A、A.2，4，5  B、B.2，1，4，3，5  C、C.1，2，3，4，5  D、D.1，2，4，5  

点击查看答案
第8题
[单选题] Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets （STS） from the previous version. After changing the  OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer， you observed performance regression for a few SQL statements.  What would you do with these SQL statements？（）

A、 Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.  B、 Capture the plans from the previous version using STS and then load them into the stored outline.  C、 Capture the plans from the previous version using STS and then load them into SQL Management Base （SMB）  D、 Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.  

点击查看答案
第9题
[多选题] The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are performed by the optimizer in this scenario?（）

A、The optimizer adds the new plan to the plan history.  B、The optimizer selects the new plan for the execution of the SQL statement.  C、The optimizer adds the new plan to the SQL plan baseline as an accepted plan.  D、The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.  E、The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

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