The SQL Tuning Advisor configuration has default settings in your database instance. Which

A. From the Advisor Central home page, select the tuning task from the Advisor Tasks section.

B. From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.

C. From Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.

D. Either B or C

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

A. The SGA Tuning Advisor

B. The SQL Access Advisor

C. The SQL Tuning Advisor

D. The Memory 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 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

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.

A. SQL Repair Advisor

B. SQL Optimizer

C. SQL Access Advisor

D. SQL Tuning Advisor

A. EM Database home page, Software and Support, SQL Advisors, Automatic SQL Tuning Advisor.

B. EM Database home page, Software and Support, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.

C. EM Database home page, Software and Support, Support Workbench, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.

D. Either B or C

E. All of the above

A. Segment Advisor

B. SQL Access Advisor

C. Undo Advisor

D. SQL Tuning Advisor

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

stance.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 recommendations

B. SQL profile recommendations

C. index-related recommendations

D. restructuring of SQL recommendations