单选题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 Memo

第1题：

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

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

• 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.

第3题：

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

• A、use enterprise manager
• B、use DBMS_SQL package
• C、use DBMS_AWR package
• D、use PRVT_WORKLOAD package
• E、query the AWR snapshot repository objects
• F、use DBMS_WORKLOAD_REPOSITORY package

第5题：

In your database，the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting？（）

• A、The optimizer statistics are collected automatically.
• B、Only the timed operating system （OS） statistics and plan execution statistics are collected.
• C、The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
• D、The snapshots for the Automatic Workload Repository （AWR） are not generated automatically. 
• E、Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.

第6题：

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.

第7题：

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.

第8题：

第9题：

Which two initialization parameters would you set to enable Automatic Shared Memory Management？（）

• A、 set SHARED_POOL_SIZE to zero
• B、 set STATISTICS_LEVEL to BASIC
• C、 set SGA_TARGET to a non-zero value
• D、 set DB_CACHE_SIZE to a non-zero value
• E、 set STATISTICS_LEVEL to TYPICAL or ALL

第10题：

Your database instance is functional for the past one month. The Automatic Workload Repository（AWR） snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TYPICAL.  You receive a complaint about the poor performance of the database between 7 PM and 9 PM of theprevious day.  Choose two actions any of which can be referred to first to diagnose the problem. （）

• A、Use the Active Session History report.
• B、Use the AWR Compare Periods report.
• C、Use an ADDM analysis between 7 PM and 9 PM of the previous day.
• D、Use the AWR Compare Period report between 7 PM and 9 PM of the previous day.