What recommendations does the SQL Access Advisor provide for optimizing SQL queries?()
第1题:
A. partitioning recommendations
B. statistics collection recommendations
C. index creation recommendations
D. materialized view recommendations
E. materialized view log recommendations
第2题:
Which three functions are performed by the SQL Tuning Advisor?() (Choose three.)
第3题:
What two statements are true regarding the recommendations received from the SQL Access Advisor?()(Choose two.)
第4题:
Which three functions are performed by the SQL Tuning Advisor?()
第5题:
Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?()
第6题:
What recommendations does the SQL Access Advisor provide for optimizing SQL queries? ()(Choose all that apply.)
第7题:
What two statements are true regarding the recommendations received from the SQL Access Advisor?()
第8题:
It cannot generate recommendations that support multiple workload queries.
It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.
It can recommend partitioning only on tables that have at least 10,000 rows.
It can recommend only B-tree indexes and not bitmap or function-based indexes
第9题:
Building and implementing SQL profiles
Recommending the optimization of materialized views
Checking query objects for missing and stale statistics
Recommending bitmap, function-based, and B-tree indexes
Recommending the restructuring of SQL queries that are using bad plans
第10题:
selection of SQL plan baselines
partitioning of tables and indexes
creation of index-organized tables
creation of bitmap, function-based,and B-tree indexes
optimization of materialized views for maximum query usage and fast refresh
第11题:
Building the SQL profile
Recommending optimization of materialized views
Checking query objects for missing and stale statistics
Recommending bitmap, function-based, and B-tree indexes
Recommending restructuring SQL queries that are using bad plans
第12题:
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.
第13题:
A. Building the SQL profile
B. Recommending optimization of materialized views
C. Checking query objects for missing and stale statistics
D. Recommending bitmap, function-based, and B-tree indexes
E. Recommending restructuring SQL queries that are using bad plans
第14题:
Which three functions are performed by the SQL Tuning Advisor?()
第15题:
What happens when you run the SQL Tuning Advisor with limited scope?()
第16题:
What happens when you run the SQL Tuning Advisor with limited scope?()
第17题:
In Oracle 11g, which recommendations does the SQL Access Advisor generate?()
第18题:
What recommendations does the SQL Access Advisor provide for optimizing SQL queries?()
第19题:
In Oracle 11g, which recommendations does the SQL Access Advisor generate? ()(Choose all that apply.)
第20题:
selection of SQL plan baselines
partitioning of tables and indexes
creation of index-organized tables
creation of bitmap, function-based, and B-tree indexes
optimization of materialized views for maximum query usage and fast refresh
第21题:
Building the SQL profile
Recommending optimization of materialized views
Checking query objects for missing and stale statistics
Recommending bitmap, function-based, and B-tree indexes
Recommending restructuring SQL queries that are using bad plans
第22题:
SQL Access Advisor recommendations are automatically implemented.
Individual SQL Access Advisor recommendations can be scheduled for implementation.
All SQL Access Advisor recommendations for a specific task must be implemented at the same time.
SQL Access Advisor recommendations are automatically scheduled for implementation during the maintenance window.
None of the above.
第23题:
partitioning recommendations
statistics collection recommendations
index creation recommendations
materialized view recommendations
materialized view log recommendations
第24题:
partitioning recommendations
statistics collection recommendations
index creation recommendations
materialized view recommendations
materialized view log recommendations