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

第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 instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）

• A、The retention period to support flashback
• B、The expected length of the longest-running query
• C、The number of undo tablespaces in the database
• D、The size of the Flash Recovery Area for the database instance

第3题：

You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database. What must you do accomplish this task？（）

• A、 Enable supplemental logging for the database.
• B、 Specify undo retention guarantee for the database
• C、 Create Flashback Data Archive in the tablespace where the tables are stored.
• D、 Create Flashback Data Archive and enable Flashback Data Archive for specific tables

第4题：

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

第5题：

You have a single Active Directory directory service domain. You have three Active Directorysites. Site replication is scheduled to occur during business hours only. You plan to make a schema change after business hours. You need to ensure that replication occurs for all sites during the schema change.   What should you do？（）

• A、 Set the Ignore schedules setting for the IP transport.
• B、 Clear the Ignore schedules setting for the IP transport.
• C、 Enable the KCC for all site objects.
• D、 Disable the KCC for all site objects.

第6题：

You need to back up the existing data on a computer before you install a new application. You also need to ensure that you are able to recover individual user files that are replaced or deleted during the installation.  What should you do？（）

• A、Create a System Restore point.
• B、Perform an Automated System Recovery （ASR） backup and restore.
• C、In the Backup and Restore Center window， click the Back up files button.
• D、In the Backup and Restore Center window， click the Back up computer button.

第7题：

第8题：

第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题：

You need to ensure that the database users should be able to use the various flashback query features in order to go back in time by four hours. What would you do to achieve this?（）

• A、set SQL_TRACE=True 
• B、set UNDO_RETENTION=14400 
• C、set FAST_START_MTTR_TARGET=240 
• D、set LOG_CHECKPOINT_INTERVAL=240 
• E、set DB_FLASHBACK_RETENTION_TARGET=14400 
• F、set the RETENTION GUARANTEE clause for the undo tablespace

第15题：

You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.  Which configuration should you use to accomplish this task？（）

• A、 Enable Flashback Data Archive for the tables.
• B、 Specify undo retention guarantee for the database.
• C、 Enable supplemental logging for the database.
• D、 Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo  tablespace for that size.
• E、 Create Flashback Data Archive on the tablespace on which the tables are stored.

第16题：

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

第17题：

Your network has 1，000 client computers that run Windows 7.   You plan to deploy a new application.   You need to ensure that the application deploys only during non-business hours.   What should you do？（）

• A、Use Group Policy.
• B、Use Windows Deployment Services with a schedule cast.
• C、Use Microsoft System Center Configuration Manager.
• D、Use a logon script.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：