statistics recommendations
SQL profile recommendations
index-related recommendations
restructuring of SQL recommendations
第1题:
Which of these appropriately describes the results of a manual SQL Tuning Advisor task?()
第2题:
To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?()
第3题:
The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA’s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?()
第4题:
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?()
第5题:
The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?()
第6题:
To view the results of the most recent Automatic SQL Tuning Advisor task,which sequence should you follow?()
第7题:
To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?()
第8题:
A list of SQL statements and recommendations for tuning
A list of SQL statements that have been tuned by the Advisor,with before and after metrics
Graphs showing the actual performance improvement made by the Advisor after it implemented the recommended changes
All of the above
第9题:
statistics recommendations
SQL Profile recommendations
Index-related recommendations
restructuring of SQL recommendations
第10题:
EM Database home page,Software and Support,SQL Advisors,Automatic SQL Tuning Advisor
EM Database home page,Software and Support,Advisor Central,SQL Advisors,Automatic SQL Tuning Advisor
EM Database home page,Software and Support,Support Workbench,Advisor Central,SQL Advisors,Automatic SQL Tuning Advisor
Either B or C
All of the above
第11题:
statistics recommendations
SQL Profile recommendations
Index-related recommendations
restructuring of SQL recommendations
第12题:
statistics recommendations
SQL profile recommendations
index-related recommendations
restructuring of SQL recommendations
第13题:
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?()
第14题:
Which of these appropriately describes the results of a manual SQL Tuning Advisor task?()
第15题:
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?()
第16题:
To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?()
第17题:
Which tasks are run automatically as part of the Automated Maintenance Task by default?()
第18题:
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?()
第19题:
EM Database home page, Software and Support, SQL Advisors, Automatic SQL Tuning Advisor.
EM Database home page, Software and Support, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.
EM Database home page, Software and Support, Support Workbench, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.
Either B or C
All of the above
第20题:
A list of SQL statements and recommendations for tuning
A list of SQL statements that have been tuned by the Advisor, with before and after metrics
Graphs showing the actual performance improvement made by the Advisor after it implemented the recommended changes
All of the above
第21题:
statistics recommendations
SQL Profile recommendations
Index-related recommendations
restructuring of SQL recommendations
第22题:
Run Segment Advisor
Run the SQL Tuning Advisor (STA)
Run the Automatic Workload Repository (AWR) report
Run the SQL Access Advisor with a hypothetical workload
第23题:
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