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.
第1题:
Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?()
第2题:
Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?()
第3题:
What happens when you run the SQL Tuning Advisor with limited scope?()
第4题:
Which component does the SQL Tuning Advisor NOT analyze for the SQL statements?()
第5题:
Which of the following cannot be used as input to the SQL Tuning Advisor?()
第6题:
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.
第7题:
The SGA Tuning Advisor
The SQL Access Advisor
The SQL Tuning Advisor
The Memory Advisor
第8题:
EM Database home page, Software and Support, SQL Advisors, Automatic SQL Tuning Advisor.
EM Database home page, Software and Support, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.
EM Database home page, Software and Support, Support Workbench, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.
Either B or C
All of the above
第9题:
From the Advisor Central home page, select the tuning task from the Advisor Tasks section.
From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.
From Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.
Either B or C
第10题:
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
第11题:
ADDM
AWR
Cursor Cache
SQL Tuning Sets
Flash Recovery Area
第12题:
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
第13题:
Which statement is true when you run the SQL Tuning Advisor with limited scope?()
第14题:
Which of the following cannot be used as input to the SQL Tuning Advisor?() (Choose all that apply.)
第15题:
To view the results of the most recent Automatic SQL Tuning Advisor task,which sequence should you follow?()
第16题:
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?()
第17题:
To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?()
第18题:
DBMS_WORKLOAD_REPOSITORY
DBMS_RESOURCE_MANAGER
DBMS_SQLTUNE
DBMS_ADVISOR
第19题:
The SGA Tuning Advisor
The SQL Access Advisor
The SQL Tuning Advisor
The Memory Advisor
第20题:
SQL Repair Advisor
SQL Optimizer
SQL Access Advisor
SQL Tuning Advisor
第21题:
EM Database home page,Software and Support,SQL Advisors,Automatic SQL Tuning Advisor
EM Database home page,Software and Support,Advisor Central,SQL Advisors,Automatic SQL Tuning Advisor
EM Database home page,Software and Support,Support Workbench,Advisor Central,SQL Advisors,Automatic SQL Tuning Advisor
Either B or C
All of the above
第22题:
Access path analysis is not performed for SQL statements.
SQL structure analysis is not performed for SQL statements.
SQL Profile recommendations are not generated for SQL statements.
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.
第23题:
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