Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window？（）A、 generating the SQL profileB、 testing and accepting the SQL profileC、 generating a list of candidate SQLs for tuningD、 adding tuned SQL plans into the SQL plan baselineE、 tuning each SQL statement in the order of importance F、 generating baselines that include candidate SQLs for tuning
Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window？（）
- A、 generating the SQL profile
- B、 testing and accepting the SQL profile
- C、 generating a list of candidate SQLs for tuning
- D、 adding tuned SQL plans into the SQL plan baseline
- E、 tuning each SQL statement in the order of importance
- F、 generating baselines that include candidate SQLs for tuning
相关考题：
Which three functions are performed by the SQL Tuning Advisor? () A. Building the SQL profileB. Recommending optimization of materialized viewsC. Checking query objects for missing and stale statisticsD. Recommending bitmap, function-based, and B-tree indexesE. Recommending restructuring SQL queries that are using bad plans
The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）A. statistics recommendationsB. SQL Profile recommendationsC. Index-related recommendationsD. restructuring of SQL recommendations
Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window?() A. generating the SQL profileB. testing and accepting the SQL profileC. generating a list of candidate SQLs for tuningD. adding tuned SQL plans into the SQL plan baselineE. tuning each SQL statement in the order of importanceF. generating baselines that include candidate SQLs for tuning
Which tasks are run automatically as part of the Automated Maintenance Task by default?() A. Segment AdvisorB. SQL Access AdvisorC. Optimizer statistics gatheringD. Automatic SQL Tuning AdvisorE. Automatic Database Diagnostics Monitor
Which tasks are run automatically as part of the Automated Maintenance Task by default? ()(Choose all that apply.) A. Segment AdvisorB. SQL Access AdvisorC. Optimizer statistics gatheringD. Automatic SQL Tuning AdvisorE. Automatic Database Diagnostics Monitor
Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.() A. Cursor cacheB. Stored outlineC. SQL Tuning SetD. Automatic Workload Repository (AWR) snapshots
Which three functions are performed by the SQL Tuning Advisor?() (Choose three.) A. Building the SQL profileB. Recommending optimization of materialized viewsC. Checking query objects for missing and stale statisticsD. Recommending bitmap, function-based, and B-tree indexesE. Recommending restructuring SQL queries that are using bad plans
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? （）A、SQL statements that are part of the AWR baseline only B、SQL statements based on the AWR top SQL identificationC、SQL statements that are part of the available SQL Tuning Set (STS) only D、SQL statements that are available in the cursor cache and executed by a user other than SYS
Which three functions are performed by the SQL Tuning Advisor?（） (Choose three.)A、Building the SQL profileB、Recommending optimization of materialized viewsC、Checking query objects for missing and stale statisticsD、Recommending bitmap, function-based, and B-tree indexesE、Recommending restructuring SQL queries that are using bad plans
Which of these appropriately describes the results of a manual SQL Tuning Advisor task?（）A、A list of SQL statements and recommendations for tuningB、A list of SQL statements that have been tuned by the Advisor, with before and after metricsC、Graphs showing the actual performance improvement made by the Advisor after it implemented the recommended changesD、All of the above
Which tasks are run automatically as part of the Automated Maintenance Task by default? （）(Choose all that apply.)A、Segment AdvisorB、SQL Access AdvisorC、Optimizer statistics gatheringD、Automatic SQL Tuning AdvisorE、Automatic Database Diagnostics Monitor
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.
The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）A、statistics recommendationsB、SQL Profile recommendationsC、Index-related recommendationsD、restructuring of SQL recommendations
Which three functions are performed by the SQL Tuning Advisor？（） A、 Building the SQL profileB、 Recommending optimization of materialized viewsC、 Checking query objects for missing and stale statisticsD、 Recommending bitmap， function-based， and B-tree indexesE、 Recommending restructuring SQL queries that are using bad plans
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework？（）A、 SQL statements that are part of the AWR baseline onlyB、 SQL statements based on the AWR top SQL identificationC、 SQL statements that are part of the available SQL Tuning Set （STS） onlyD、 SQL statements that are available in the cursor cache and executed by a user other than SYS
You want to analyze a SQL Tuning Set （STS） using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set？（）A、 Every SQL statement in the STS is considered only once for execution.B、 The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.C、 The execution plan and execution statistics are computed for each SQL statement in the STS. D、 The effects of DDL and DML are considered to produce the execution plan and execution statistics.
Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window?（）A、generating the SQL profileB、testing and accepting the SQL profileC、generating a list of candidate SQLs for tuningD、adding tuned SQL plans into the SQL plan baselineE、tuning each SQL statement in the order of importanceF、generating baselines that include candidate SQLs for tuning
Which tasks are run automatically as part of the Automated Maintenance Task by default？（） A、 Segment AdvisorB、 SQL Access AdvisorC、 Optimizer statistics gatheringD、 Automatic SQL Tuning AdvisorE、 Automatic Database Diagnostics Monitor
Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.（）A、 Cursor cacheB、 Stored outlineC、 SQL Tuning SetD、 Automatic Workload Repository （AWR） snapshots
To view the results of the most recent Automatic SQL Tuning Advisor task，which sequence should you follow？（） A、 EM Database home page，Software and Support，SQL Advisors，Automatic SQL Tuning AdvisorB、 EM Database home page，Software and Support，Advisor Central，SQL Advisors，Automatic SQL Tuning AdvisorC、 EM Database home page，Software and Support，Support Workbench，Advisor Central，SQL Advisors，Automatic SQL Tuning AdvisorD、 Either B or CE、 All of the above
Which of the following advisors is run in every maintenance window by the auto-task system?（）A、The Memory AdvisorB、The SQL Tuning AdvisorC、The Undo AdvisorD、The SQL Access Advisor
You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?（）A、Every SQL statement in the STS is considered only once for executionB、The SQL statements in the STS are executed concurrently to produce the execution plan and execution statisticsC、The execution plan and execution statistics are computed for each SQL statement in the STSD、The effects of DDL and DML are considered to produce the execution plan and execution statistics
单选题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.
单选题The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）Astatistics recommendationsBSQL Profile recommendationsCIndex-related recommendationsDrestructuring of SQL recommendations
多选题Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window?（）Agenerating the SQL profileBtesting and accepting the SQL profileCgenerating a list of candidate SQLs for tuningDadding tuned SQL plans into the SQL plan baselineEtuning each SQL statement in the order of importanceFgenerating baselines that include candidate SQLs for tuning
单选题The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task？（）A statistics recommendationsB SQL Profile recommendationsC Index-related recommendationsD restructuring of SQL recommendations
多选题You want to analyze a SQL Tuning Set （STS） using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set？（）AEvery SQL statement in the STS is considered only once for execution.BThe SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.CThe execution plan and execution statistics are computed for each SQL statement in the STS.DThe effects of DDL and DML are considered to produce the execution plan and execution statistics.