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.
第1题:
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?()
第2题:
Which two statements are true regarding the SQL Repair Advisor?()
第3题:
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.
第4题:
Which statement is true when you run the SQL Tuning Advisor with limited scope?()
第5题:
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?()
第6题:
Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache. What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?()
第7题:
You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?()
第8题:
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 recommendations
B. SQL profile recommendations
C. index-related recommendations
D. restructuring of SQL recommendations
第9题:
You work with a newly created database. Presently, there is no application load on the database instance.You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.What action must you take to achieve this?()
第10题:
Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?()