Which of the following is a potential performance tuning recommendation from the SQL Access 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题:
Using the following information: Performance data from an existing system that a new system will replace; Performance estimates that anticipate future workloads; Micro-partitioning and logical partitioning implementations. Which of the following allows a technical sales representative to create a system design which can be imported into an HMC?()
第3题:
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
第4题:
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?()
第5题:
Which of these appropriately describes the results of a manual SQL Tuning Advisor task?()
第6题:
A. partitioning recommendations
B. statistics collection recommendations
C. index creation recommendations
D. materialized view recommendations
E. materialized view log recommendations
第7题:
You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?()
第8题:
A. A list of SQL statements and recommendations for tuning
B. A list of SQL statements that have been tuned by the Advisor, with before and after metrics
C. Graphs showing the actual performance improvement made by the Advisor after it implemented the recommended changes
D. All of the above
第9题:
Which of these appropriately describes the results of a manual SQL Tuning Advisor task?()
第10题:
Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?()