单选题While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）AIt updates the existing SQL profiles with current statistics.BIt makes the statistics information available to GATHER_STATS_JOBCIt initiates the statistics collection process by running GATHER_STATS_JOBDIt logs a warning message in the alert log so that the DBA can perform statistics collection manually.
单选题
While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）
A
It updates the existing SQL profiles with current statistics.
B
It makes the statistics information available to GATHER_STATS_JOB
C
It initiates the statistics collection process by running GATHER_STATS_JOB
D
It logs a warning message in the alert log so that the DBA can perform statistics collection manually.
参考解析
解析：
暂无解析
相关考题：
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.
The SQL Tuning Advisor has been configured with default configurations in your database instance.Which recommendation is automatically implemented without the DBA‘s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?（）A. statistics recommendationsB. SQL profile recommendationsC. index-related recommendationsD. restructuring of SQL recommendations
Which two statements about the SQL Management Base (SMB) are true?() A. It contains only SQL profiles generated by SQL Tuning Advisor.B. It stores plans generated by the optimizer using a stored outline.C. It is part of the data dictionary and stored in the SYSAUX tablespace.D. It is part of the data dictionary and stored in the SYSTEM tablespace.E. It contains the statement log, the plan history, plan baselines, and SQL profiles.
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 of the following identifies and creates an index to minimize the DB time for a particular SQL statement?() A. The SGA Tuning AdvisorB. The SQL Access AdvisorC. The SQL Tuning AdvisorD. The Memory Advisor
While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）A、It updates the existing SQL profiles with current statisticsB、It makes the statistics information available to GATHER_STATS_JOBC、It initiates the statistics collection process by running GATHER_STATS_JOBD、It logs a warning message in the alert log so that the DBA can perform statistics collection manually
While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）A、It updates the existing SQL profiles with current statistics.B、It makes the statistics information available to GATHER_STATS_JOBC、It initiates the statistics collection process by running GATHER_STATS_JOBD、It logs a warning message in the alert log so that the DBA can perform statistics collection manually.
The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA’s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework？（）A、 statistics recommendationsB、 SQL profile recommendationsC、 index-related recommendationsD、 restructuring of SQL recommendations
Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement？（） A、 The SGA Tuning AdvisorB、 The SQL Access AdvisorC、 The SQL Tuning AdvisorD、 The Memory Advisor
Which statement is true when you run the SQL Tuning Advisor with limited scope？（）A、Access path analysis is not performed for the SQL statements.B、SQL structure analysis is not performed for the SQL statements.C、SQL Profile recommendations are not generated for the SQL statements.D、The staleness and absence of the statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.
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
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
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 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 AdvisorB、run SQL Tuning Advisor on top SQL statementsC、run the Automatic Workload Repository （AWR） reportD、run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements
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 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？（）Arun Segment AdvisorBrun SQL Tuning Advisor on top SQL statementsCrun the Automatic Workload Repository （AWR） reportDrun the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements
单选题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.)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
单选题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.
单选题While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）AIt updates the existing SQL profiles with current statisticsBIt makes the statistics information available to GATHER_STATS_JOBCIt initiates the statistics collection process by running GATHER_STATS_JOBDIt logs a warning message in the alert log so that the DBA can perform statistics collection manually
单选题While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）AIt updates the existing SQL profiles with current statistics.BIt makes the statistics information available to GATHER_STATS_JOBCIt initiates the statistics collection process by running GATHER_STATS_JOBDIt logs a warning message in the alert log so that the DBA can perform statistics collection manually.
多选题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 identifies and creates an index to minimize the DB time for a particular SQL statement？（）A The SGA Tuning AdvisorB The SQL Access AdvisorC The SQL Tuning AdvisorD The Memory Advisor
单选题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 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
单选题Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?（）AThe SGA Tuning AdvisorBThe SQL Access AdvisorCThe SQL Tuning AdvisorDThe Memory Advisor
单选题The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA’s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework？（）A statistics recommendationsB SQL profile recommendationsC index-related recommendationsD restructuring of SQL recommendations