Segment Advisor
SQL Access Advisor
Undo Advisor
SQL Tuning Advisor
第1题：
A. Create new indexes.
B. Modify existing indexes.
C. Implement partitioning on a nonpartitioned table.
D. Create materialized views.
E. All of the above
第2题：
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
第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题：
The Chief Information Officer （CIO） is preparing a briefing about the reliability of their server environment. There is a need to create a report about which systems had unplanned system outages and how often they occurred. What IBM Director tool can be used to create the report？（）
第5题：
Which three functions are performed by the SQL Tuning Advisor?（）
第6题：
A. partitioning recommendations
B. statistics collection recommendations
C. index creation recommendations
D. materialized view recommendations
E. materialized view log recommendations
第7题：
Which three functions are performed by the SQL Tuning Advisor?（） (Choose three.)
第8题：
A. partitioning recommendations
B. statistics collection recommendations
C. index creation recommendations
D. materialized view recommendations
E. materialized view log recommendations
第9题：
Which of the following would BEST optimize a computer that is heavily used? （）
第10题：
Which IBM Resource would best help you determine the proper performance tuning of your System x hardware and the application workload of the software？（）