Segment Advisor
SQL Access Advisor
Undo Advisor
SQL Tuning Advisor
第1题:
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?()
第2题:
Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?()
第3题:
A. The SGA Tuning Advisor
B. The SQL Access Advisor
C. The SQL Tuning Advisor
D. The Memory Advisor
第4题:
Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?()
第5题:
While running long running queries, you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error?()
第6题:
You accepted the recommended SQL Profile by executing the following code: DECLARE sqlprofile_name varchar2(30); BEGIN sqlprofile_name := DBMS_SQLTUNE.ACCEPT_SQL_PROFILE( task_name => ’my_task’, profile_name => ’my_profile’); END; Which advisor will analyze this profile?()
第7题:
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?()
第8题:
A. The Memory Advisor
B. The SQL Tuning Advisor
C. The Undo Advisor
D. The SQL Access Advisor
第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题:
Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?()