单选题Which of the following would you use to enable automatic media recovery for a database？（）A SET AUTORECOVERY ONB SET RECOVERY ONC SET AUTO OND You cannot enable automatic media recovery.

第1题：

You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re/x7fcreate the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re/x7fcreate the indexes？（）

• A、ONLINE
• B、REVERSE
• C、PARALLEL
• D、COMPRESS
• E、NOLOGGING
• F、COMPUTE STATISTICS

第2题：

You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup metadata information. You want to enable the reusable section of the control file to expand itself if the oldest record cannot be reused， and whenever a new record is added to the reusable section of the control file. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME parameter？（）

• A、 Zero
• B、 One or more
• C、 NONE
• D、 DEFAULT

第3题：

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

第4题：

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

第5题：

You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）

• A、 ONLINE
• B、 REVERSE
• C、 PARALLEL
• D、 COMPRESS
• E、 NOLOGGING
• F、 COMPUTE STATISTICS

第6题：

Which of the following would you use to enable automatic media recovery for a database？（）

• A、SET AUTORECOVERY ON
• B、SET RECOVERY ON
• C、SET AUTO ON
• D、You cannot enable automatic media recovery.

第7题：

When you use Microsoft Windows Media Player to begin playback of a music file， you receive the following error message： "You do not have the rights to play this file."  You need to configure Windows Media Player to ensure playback of protected digital media.  What should you do？ （）

• A、Disable the Set clock on devices automatically option.
• B、Enable the Automatically check if protected files need to be refreshed option.
• C、Enable the Update music files by retrieving media info from the Internet option.
• D、Enable the Download usage rights automatically when I play or sync a file option.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

What command would you issue to enable automated backups of control files？（）  

• A、 alter database controlfile autobackup on
• B、 alter system controlfile autobackup on
• C、 configure controlfile autobackup on
• D、 enable controlfile autobackup

第14题：

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

第15题：

Following a server crash, the automatic recovery of InnoDB fails. How would you begin to manually repair the InnoDB tables?（）

• A、Start the server with the – innodb_recover_options option set to FORCE
• B、Start the server with the – innodb_force_recovery option set to a non-zero value
• C、Start the server as usual, and then execute the REPAIR TABLE command
• D、Start the server as usual, and then execute the CHECK TABLE command

第16题：

Which initialization parameter must you set to enable automatic archiving？ （）

• A、LOG_ARCHIVE_DEST
• B、LOG_ARCHIVE_START
• C、LOG_ARCHIVE_FORMAT
• D、LOG_ARCHIVE_MAX_PROCESSES

第17题：

You are performing a block media recovery on the tools01.dbf data file in the SALES database using RMAN. Which two statements are correct in this scenario？（）

• A、 You must ensure that the SALES database is mounted or open.
• B、 You must restore a backup control file to perform a block media recovery.
• C、 You must take the tools01.dbf data file offline before you start a block media recovery.
• D、 You must put the database in NOARCHIVELOG mode to perform a block media recovery.
• E、 You can perform only a complete media recovery of individual blocks， point-in-time recovery of individual data blocks is not supported.

第18题：

In the parameter file of your production database， the CONTROL_FILE_RECORD_KEEP_TIME parameter is set to 31. What would be the impact of this setting on the backup that is being performed by using Recovery Manager （RMAN）？（）

• A、 The backup would be retained on the media for 31 days.
• B、 The backup would be maintained in the recovery catalog for 31 days.
• C、 The backup metadata would be retained in the control file for 31 days.
• D、 The backup metadata would be maintained in the recovery catalog for 31 days.
• E、 Automatic backups of the control file will be retained in the flash recovery area for 31 days.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：