单选题You are creating a SQL Tuning Set to allow a group of SQL statements to be passed into the SQL Tuning Advisor. Which packages will you use to create the SQL Tuning Set？（）A DBMS_WORKLOAD_REPOSITORYB DBMS_RESOURCE_MANAGERC DBMS_SQLTUNED DBMS_ADVISOR
单选题
You are creating a SQL Tuning Set to allow a group of SQL statements to be passed into the SQL Tuning Advisor. Which packages will you use to create the SQL Tuning Set？（）
A
DBMS_WORKLOAD_REPOSITORY
B
DBMS_RESOURCE_MANAGER
C
DBMS_SQLTUNE
D
DBMS_ADVISOR
参考解析
解析：
暂无解析
相关考题：
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 SQLB. the execution planC. the execution contextD. the execution frequencyE. the system change number (SCN)
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.
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
Which of the following cannot be used as input to the SQL Tuning Advisor?() (Choose all that apply.) A. A single SQL statement provided by a userB. An existing SQL Tuning Set (STS)C. A preprocessed Database Replay workloadD. A schema nameE. SQL statement identified in EM as using excessive resources
When creating a SQL tuning set，which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values？（）A、 Filter versionsB、 Filter loadsC、 Filter tasksD、 Filter options
What happens when you run the SQL Tuning Advisor with limited scope？（） A、 Access path analysis is not performed for SQL statements.B、 SQL structure analysis is not performed for SQL statements.C、 SQL Profile recommendations are not generated for SQL statements.D、 Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.
Which of the following cannot be used as input to the SQL Tuning Advisor?（） (Choose all that apply.)A、A single SQL statement provided by a userB、An existing SQL Tuning Set (STS)C、A preprocessed Database Replay workloadD、A schema nameE、SQL statement identified in EM as using excessive resources
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
What happens when you run the SQL Tuning Advisor with limited scope?（）A、Access pathanalysis is not performed for SQL statements.B、SQL structure analysis is not performed for SQL statements.C、SQL Profile recommendations are not generated for SQL statements.D、Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor. In this case, SQL Tuning Advisor produces recommendations based on statistical checks, access path analysis, and SQL structure analysis. SQL profile recommendations are not generated.
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 textB、 the execution planC、 the execution contextD、 the execution frequencyE、 the system change number （SCN）
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
You are creating a SQL Tuning Set to allow a group of SQL statements to be passed into the SQL Tuning Advisor. Which packages will you use to create the SQL Tuning Set？（）A、 DBMS_WORKLOAD_REPOSITORYB、 DBMS_RESOURCE_MANAGERC、 DBMS_SQLTUNED、 DBMS_ADVISOR
Which of the following cannot be used as input to the SQL Tuning Advisor？（）A、 A single SQL statement provided by a userB、 An existing SQL Tuning Set （STS）C、 A preprocessed Database Replay workloadD、 A schema nameE、 SQL statement identified in EM as using excessive resources
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 SQLB、the execution planC、the execution contextD、the execution frequencyE、the system change number (SCN)
You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advisor to analyze？ （）A、Top SQLB、snapshotsC、SQL Tuning setsD、index access pathE、optimizer statisticsF、materialized view logs
单选题Which statement is true when you run the SQL Tuning Advisor with limited scope？（）AAccess path analysis is not performed for the SQL statements.BSQL structure analysis is not performed for the SQL statements.CSQL Profile recommendations are not generated for the SQL statements.DThe staleness and absence of the statistics are not checked for the objects in the query supplied to the SQL Tuning 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?（）AEvery SQL statement in the STS is considered only once for executionBThe SQL statements in the STS are executed concurrently to produce the execution plan and execution statisticsCThe execution plan and execution statistics are computed for each SQL statement in the STSDThe effects of DDL and DML are considered to produce the execution plan and execution statistics
多选题You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advisor to analyze？ （）ATop SQLBsnapshotsCSQL Tuning setsDindex access pathEoptimizer statisticsFmaterialized view logs
多选题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？（）Athe SQL textBthe execution planCthe execution contextDthe execution frequencyEthe system change number （SCN）
单选题What happens when you run the SQL Tuning Advisor with limited scope？（）A Access path analysis is not performed for SQL statements.B SQL structure analysis is not performed for SQL statements.C SQL Profile recommendations are not generated for SQL statements.D Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.
单选题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 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
单选题When creating a SQL tuning set，which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values？（）A Filter versionsB Filter loadsC Filter tasksD Filter options
多选题Which of the following cannot be used as input to the SQL Tuning Advisor?（） (Choose all that apply.)AA single SQL statement provided by a userBAn existing SQL Tuning Set (STS)CA preprocessed Database Replay workloadDA schema nameESQL statement identified in EM as using excessive resources
多选题What happens when you run the SQL Tuning Advisor with limited scope?（）AAccess pathanalysis is not performed for SQL statements.BSQL structure analysis is not performed for SQL statements.CSQL Profile recommendations are not generated for SQL statements.DStaleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor. In this case, SQL Tuning Advisor produces recommendations based on statistical checks, access path analysis, and SQL structure analysis. SQL profile recommendations are not generated.
多选题Which of the following cannot be used as input to the SQL Tuning Advisor？（）AA single SQL statement provided by a userBAn existing SQL Tuning Set （STS）CA preprocessed Database Replay workloadDA schema nameESQL statement identified in EM as using excessive resources
多选题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.