statistics recommendations
SQL Profile recommendations
Index-related recommendations
restructuring of SQL recommendations
第1题:
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?()
第2题:
Which of these appropriately describes the results of a manual SQL Tuning Advisor task?()
第3题:
Which tasks are run automatically as part of the Automated Maintenance Task by default? ()(Choose all that apply.)
第4题:
To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?()
第5题:
Which tasks are run automatically as part of the Automated Maintenance Task by default?()
第6题:
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?()
第7题:
Segment Advisor
SQL Access Advisor
Optimizer statistics gathering
Automatic SQL Tuning Advisor
Automatic Database Diagnostics Monitor
第8题:
statistics recommendations
SQL Profile recommendations
Index-related recommendations
restructuring of SQL recommendations
第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题:
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
第12题:
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
第13题:
To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?()
第14题:
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?()
第15题:
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?()
第16题:
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?()
第17题:
To view the results of the most recent Automatic SQL Tuning Advisor task,which sequence should you follow?()
第18题:
To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?()
第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题:
statistics recommendations
SQL profile recommendations
index-related recommendations
restructuring of SQL recommendations
第21题:
Segment Advisor
SQL Access Advisor
Optimizer statistics gathering
Automatic SQL Tuning Advisor
Automatic Database Diagnostics Monitor
第22题:
SQL Access Advisor recommendations are automatically implemented.
Individual SQL Access Advisor recommendations can be scheduled for implementation.
All SQL Access Advisor recommendations for a specific task must be implemented at the same time.
SQL Access Advisor recommendations are automatically scheduled for implementation during the maintenance window.
None of the above.
第23题:
statistics recommendations
SQL Profile recommendations
Index-related recommendations
restructuring of SQL recommendations
第24题:
statistics recommendations
SQL profile recommendations
index-related recommendations
restructuring of SQL recommendations