多选题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 

第1题：

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.

第2题：

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、 Create and populate a SQL Tuning Set from the AWR on every Monday.
• B、 Change the RETENTION setting for the AWR snapshots to 7 days on Monday.
• C、 Create a repeating baseline template.
• D、 Insert a finding directive for future ADDM tasks.

第3题：

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

第4题：

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.

第5题：

You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?（）

• A、Set MEMORY_TARGET to zero
• B、Set the STATISTICS_LEVEL parameter to BASIC
• C、Set the WORKAREA_SIZE_POLICY parameter to MANUAL
• D、Set the PGA_AGGREGATE_TARGET parameter to nonzero value

第6题：

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

• 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 automaticpurging of snapshots

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

• 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 the automatic purging of the snapshots.

第8题：

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

• A、set DB_FLASHBACK_RETENTION_TARGET=10800  
• B、create a new scheduler window for the time period of 24 hours and use the optimizer statistics 
• C、modify the Automatic Workload Repository (AWR) snapshot time interval to three hours and use ADDMfindings 
• D、specify New Undo Retention as three hours and Analysis Time period as Last One Day in the Undo Advisor page and use its recommendations

第9题：

第10题：

第11题：

第12题：

第13题：

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.

第14题：

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.

第15题：

You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）

• A、Set the UNDO_RETENTION parameter to AUTO.
• B、Create an initial undo segment in undotablespace.
• C、Set the UNDO_RETENTION parameter to 900 or more
• D、Set the initialization parameter UNDO_MANAGEMENT to AUTO
• E、Set the UNDO_MANAGEMENT parameter to the name of an undotablespace

第16题：

In your running instance， some of the initialization parameters are set as shown below： SGA_MAX_SIZE = 14GB  DB_CACHE_SIZE = 1GB  SHARED_POOL_SIZE = 3GB  STATISTICS_LEVEL = BASIC  PGA_AGGREGATE_TARGET = 0  You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason？（）

• A、The STATISTICS_LEVEL initialization parameter is set to BASIC
• B、The PGA_AGGREGATE_TARGET initialization parameter is set to zero.
• C、The SGA_MAX_SIZE initialization parameter is set to less than 20 GB
• D、The DB_CACHE_SIZE initialization parameter is set to less than 5 GB
• E、The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.

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

• A、On Wednesday， the statistics have been purged.
• B、On Wednesday， the retention period has been set to zero.
• C、On Wednesday， the collection interval has been set to zero.
• D、On Wednesday， the collection level has been changed to All.
• E、On Wednesday， the retention period has been set to one day.
• F、On Wednesday， the retention period has been set to two days.
• G、On Wednesday， the collection level has been changed to Typical.
• H、On Wednesday， the collection interval has been set to 1440 minutes.

第18题：

You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance？（）

• A、run Segment Advisor
• B、run SQL Tuning Advisor on top SQL statements
• C、run the Automatic Workload Repository （AWR） report
• D、run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements

第19题：

in your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC.  What is the impactof this setting（）

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

第20题：

第21题：

第22题：

第23题：

第24题：