From the Advisor Central home page, select the tuning task from the Advisor Tasks section.
From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.
From Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.
Either B or C
第1题:
A. From the Advisor Central home page, select the tuning task from the Advisor Tasks section.
B. From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.
C. From Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.
D. Either B or C
第2题:
Which of these appropriately describes the results of a manual SQL Tuning Advisor task?()
第3题:
A. Accept the recommended SQL profile.
B.Collect statistics for the related objects.
C. Run the Access Advisor for the SQL statement.
D. Run the Segment Advisor for recommendations.
第4题:
What happens when you run the SQL Tuning Advisor with limited scope?()
第5题:
Which of these appropriately describes the results of a manual SQL Tuning Advisor task?()
第6题:
A. The Memory Advisor
B. The SQL Tuning Advisor
C. The Undo Advisor
D. The SQL Access Advisor
第7题:
The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?()
第8题:
The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?()
A. statistics recommendations
B. SQL Profile recommendations
C. Index-related recommendations
D. restructuring of SQL recommendations
第9题:
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?()
第10题:
Evaluate the following code: SQL>VARIABLE task_name VARCHAR2(255); SQL>VARIABLE sql_stmt VARCHAR2(4000); SQL>BEGIN :sql_stmt := ’SELECT COUNT(*) FROM customers WHERE cust_state_province =’’CA’’’; :task_name := ’MY_QUICKTUNE_TASK’; DBMS_ADVISOR.QUICK_TUNE(DBMS_ADVISOR.SQLACCESS_ADVISOR, :task_name, :sql_stmt); END; What is the outcome of this block of code?()