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?()
第1题:
A. A single SQL statement provided by a user
B. An existing SQL Tuning Set (STS)
C. A preprocessed Database Replay workload
D. A schema name
E. SQL statement identified in EM as using excessive resources
第2题:
Which statement is true when you run the SQL Tuning Advisor with limited scope?()
第3题:
Which of the following cannot be used as input to the SQL Tuning Advisor?() (Choose all that apply.)
第4题:
Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window?()
第5题:
To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?()
第6题:
The SGA Tuning Advisor
The SQL Access Advisor
The SQL Tuning Advisor
The Memory Advisor
第7题:
The SGA Tuning Advisor
The SQL Access Advisor
The SQL Tuning Advisor
The Memory Advisor
第8题:
SQL Repair Advisor
SQL Optimizer
SQL Access Advisor
SQL Tuning Advisor SQL
第9题:
It updates the existing SQL profiles with current statistics.
It makes the statistics information available to GATHER_STATS_JOB
It initiates the statistics collection process by running GATHER_STATS_JOB
It logs a warning message in the alert log so that the DBA can perform statistics collection manually.
第10题:
SQL Repair Advisor
SQL Optimizer
SQL Access Advisor
SQL Tuning Advisor
第11题:
It updates the existing SQL profiles with current statistics
It makes the statistics information available to GATHER_STATS_JOB
It initiates the statistics collection process by running GATHER_STATS_JOB
It logs a warning message in the alert log so that the DBA can perform statistics collection manually
第12题:
Every SQL statement in the STS is considered only once for execution.
The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.
The execution plan and execution statistics are computed for each SQL statement in the STS.
The effects of DDL and DML are considered to produce the execution plan and execution statistics.
第13题:
Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?()
第14题:
Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?()
第15题:
Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window?()
第16题:
Which of the following cannot be used as input to the SQL Tuning Advisor?()
第17题:
Access path analysis is not performed for the SQL statements.
SQL structure analysis is not performed for the SQL statements.
SQL Profile recommendations are not generated for the SQL statements.
The staleness and absence of the statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.
第18题:
Every SQL statement in the STS is considered only once for execution
The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics
The execution plan and execution statistics are computed for each SQL statement in the STS
The effects of DDL and DML are considered to produce the execution plan and execution statistics
第19题:
generating the SQL profile
testing and accepting the SQL profile
generating a list of candidate SQLs for tuning
adding tuned SQL plans into the SQL plan baseline
tuning each SQL statement in the order of importance
generating baselines that include candidate SQLs for tuning
第20题:
SQL Repair Advisor
SQL Optimizer
SQL Access Advisor
SQL Tuning Advisor
第21题:
The tuned plan is not added to the SQL plan baseline.
The tuned plan is added to the fixed SQL plan baseline as a fixed plan.
The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.
The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.
第22题:
A single SQL statement provided by a user
An existing SQL Tuning Set (STS)
A preprocessed Database Replay workload
A schema name
SQL statement identified in EM as using excessive resources
第23题:
A single SQL statement provided by a user
An existing SQL Tuning Set (STS)
A preprocessed Database Replay workload
A schema name
SQL statement identified in EM as using excessive resources