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？（）  A、 Cre

第1题：

第2题：

Your database is functional with a peak load for the last one hour. You want to preserve theperformance statistics collected during this period to be used for comparison when you analyze theperformance of the database in the future.  What action would you take to achieve this task（）

• A、Insert finding directives for ADDM tasks in the future.
• B、Create a baseline on a pair of snapshots spanning the peak-load period.
• C、Decrease the snapshot interval in the AWR to collect more snapshots during the peak-load period.
• D、Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automatic purging of snapshots.

第3题：

第4题：

You are the network administrator for All servers run Windows Server 2003. You are creating a backup schedule for the main file server. You need to create a schedule so that backup jobs are completed in the shortest amount of time possible. What should you do?（）

• A、Schedule a normal backup every Sunday. Schedule incremental backups every Monday through Saturday.
• B、Schedule a normal backup every Sunday. Schedule differential backups every Monday through Saturday.
• C、Schedule a copy backup every day.
• D、Schedule a normal backup every day.

第5题：

You have created a baseline metric， DISK_IO_BL， for the disk I/O metrics in your PROD database and you have been getting notifications whenever the database performance degrades. You optimize the database I/O to gain the performance and you decide to remove the baseline metrics. Which method would you use to remove the DISK_IO_BL baseline metrics？（）

• A、The baseline， once created， cannot be removed.
• B、Disable the baseline metrics in the Database Control Manage Metrics page.
• C、The baseline will be automatically removed once the database performance has been optimized.
• D、Drop the baseline metrics by usingDBMS_WORKLOAD_REPOSITORY.DROP_BASELINE procedure.

第6题：

You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?（）

• A、The collection level for the AWR should be set to BASIC
• B、The moving window size must be less than Undo Retention
• C、The moving window size should be greater than the Automatic Workload Repository (AWR) retention period
• D、The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period

第7题：

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?（）

• A、Compute the baseline statistics.
• B、Take an immediate AWR snapshot.
• C、Decrease the window size for the baseline.
• D、Decrease the expiration time for the baseline.

第8题：

第9题：

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？（）

• A、Set the STATISTICS_LEVEL initialization parameter to ALL.
• B、Create a baseline on a pair of snapshots that have the statistics of the peak­load period in the database.
• C、Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak­load period.
• D、Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid theautomatic purging of the snapshots.

第10题：

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?（）

• A、Create two custom ADDM tasks.
• B、Modify the AWR snapshot time interval to two hours.
• C、Create a new scheduler window for a time period of two hours.
• D、Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.