Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?()
第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题:
Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?()