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
第1题:
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
第2题:
Which three functions are performed by the SQL Tuning Advisor?() (Choose three.)
第3题:
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
第4题:
Which statement is true when you run the SQL Tuning Advisor with limited scope?()
第5题:
Which three functions are performed by the SQL Tuning Advisor?()
第6题:
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
第7题:
Which three statements about performance analysis by SQL Performance Analyzer are true? ()(Choose three.)
第8题:
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
第9题:
Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?()
第10题:
What happens when you run the SQL Tuning Advisor with limited scope?()