use enterprise manager
use DBMS_SQL package
use DBMS_AWR package
use PRVT_WORKLOAD package
query the AWR snapshot repository objects
use DBMS_WORKLOAD_REPOSITORY package
第1题:
You work as a database administrator for Supportcenter.cn. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation. Which advisory component would you refer to, in order to determine the appropriate indexes?()
第2题:
Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of the database in the future. What action would you take to achieve this task?()
第3题:
You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this?()
第4题:
You work as a database administrator for Certkiller .com. You have set the retention period for Automatic Repository (AWR) statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics?()
第5题:
You work as a database administrator for Supportcenter.cn. You have set the retention period for Automatic Repository (AWR) statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics?()
第6题:
Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g?()
第7题:
Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of thedatabase in the future. What action would you take to achieve this task?()
第8题:
Insert finding directives for ADDM tasks in the future.
Create a baseline on a pair of snapshots spanning the peak-load period.
Decrease the snapshot interval in the AWR to collect more snapshots during the peak-load period.
Set the snapshot retention period in the Automatic Workload Repository (AWR) to zero to avoid automatic purging of snapshots.
第9题:
Set the STATISTICS_LEVEL initialization parameter to ALL.
Create a baseline on a pair of snapshots that have the statistics of the peakload period in the database.
Decrease the snapshot interval in the AWR to collect more number of snapshots during the peakload period.
Set the snapshot retention period in the Automatic Workload Repository (AWR) to zero to avoid theautomatic purging of the snapshots.
第10题:
It does not allow you to change the moving window size.
Adaptive threshold functionalities use it by default to compute statistics.
It is created by default with the window size being equal to the AWR retention time.
It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).
第11题:
On Wednesday, the statistics have been purged.
On Wednesday, the retention period has been set to zero.
On Wednesday, the collection interval has been set to zero.
On Wednesday, the collection level has been changed to All.
On Wednesday, the retention period has been set to one day.
On Wednesday, the retention period has been set to two days
On Wednesday, the collection level has been changed to Typical.
On Wednesday, the collection interval has been set to 1440 minutes.
第12题:
Insert finding directives for ADDM tasks in the future.
Create a baseline on a pair of snapshots spanning the peak-load period.
Decrease the snapshot interval in the AWR to collect more snapshots during the peak- load period.
Set the snapshot retention period in the Automatic Workload Repository (AWR) to zero to avoid automaticpurging of snapshots
第13题:
You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?()
第14题:
The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?()
第15题:
In your database,the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?()
第16题:
Initially, for the Automatic Workload Repository (AWR) statistics, the retention period is set to 7 days, the collection interval is set to 30 minutes and the collection level is set to Typical in your production database. You have been using the Memory Advisor for the last three months to generate recommendations for tuning memory components. However, when you observe the Memory Advisor on a Friday, you find that the statistics are available only for two days, Thursday and Friday, of that week. What would have caused the statistics to be removed?()
第17题:
Initially, for the Automatic Workload Repository (AWR) statistics,the retention period is set to 7 days, the collection interval is set to 30 minutes and the collection level is set to Typical in your production database. You have been using the Memory Advisor for the last three months to generate recommendations for tuning memory components. However,when you observe the Memory Advisor on a Friday,you find that the statistics are available only for two days, Thursday and Friday,of that week. What would have caused the statistics to be removed?()
第18题:
Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future. What action would you take to achieve this task()
第19题:
The system was running a normal workload during the last 24 hours. You need to ensure that with the same workload you should be able to flashback tables by three hours. What would you do to find the system recommendations for the undo retention period and the undo tablespace size?()
第20题:
Set the STATISTICS_LEVEL initialization parameter to ALL.
Create a baseline on a pair of snapshots that have the statistics of the peak-load period in the database.
Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak-load period.
Set the snapshot retention period in the Automatic Workload Repository (AWR) to zero to avoid the automatic purging of the snapshots.
第21题:
On Wednesday, the statistics have been purged.
On Wednesday, the retention period has been set to zero.
On Wednesday, the collection interval has been set to zero.
On Wednesday, the collection level has been changed to All.
On Wednesday, the retention period has been set to one day.
On Wednesday, the retention period has been set to two days.
On Wednesday, the collection level has been changed to Typical.
On Wednesday, the collection interval has been set to 1440 minutes.
第22题:
Use the Active Session History report.
Use the AWR Compare Periods report.
Use an ADDM analysis between 7 PM and 9 PM of the previous day.
Use the AWR Compare Period report between 7 PM and 9 PM of the previous day.
第23题:
use enterprise manager
use DBMS_SQL package
use DBMS_AWR package
use PRVT_WORKLOAD package
query the AWR snapshot repository objects
use DBMS_WORKLOAD_REPOSITORY package