多选题While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Iden

第1题：

You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?（）

• A、Enable the flash recovery area and specify it as the archived redo log destination.
• B、Disable the flash recovery area and start the database instance in ARCHIVELOG mode.
• C、Enable the flash recovery area but do not specify it as the archived redo log destination.
• D、Disable the flash recovery area and start the database instance in NOARCHIVELOG mode

第2题：

While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed   that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.  Identify the two events that can occur in the event of a log switch？（）  

• A、 An entry is created in the alert log file and the database instance continues to function normally
• B、 The log switch hangs occur for transactions until free space is available in the flash recovery area
• C、 The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area
• D、 The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented

第3题：

What does the DB_FLASHBACK_RETENTION_TARGET parameter configure？（）  

• A、 An upper limit on how far you can flash back the database，depending on the information in the redo logs
• B、 An upper limit on how far you can flash back the database，depending on the information in the undo tablespace
• C、 The amount of time for which the flashback data is to be kept in the flash recovery area， provided that there is enough space
• D、 The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace，provided that there is enough space

第4题：

Which options would you consider while configuring a flash recovery area fast recovery area in 11g Release 2 for your production database that is running in ARCHIVELOG mode？（） 

• A、 Setting the FAST_START_MTTR_TARGET to set the mean time to recover
• B、 Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs
• C、 Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area
• D、 Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area

第5题：

ou are using the flash recovery area （fast recovery area in 11g Release 2） to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is （jetting filled up very fast and it is running out of space.  Your database flash recovery area is low on specie and you have no more room on disk. Proactively， which two options could you use to make more space available in the flash recovery（）

• A、 Change the RMAN archived log deletion policy.
• B、 Use the RMAN CROSSCHECK command to reclaim the archived log space.
• C、 Change the RMAN retention policy to retain backups for a shorter period of time.
• D、 Use OS command to move files from the flash recovery area to some other location.

第6题：

While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch?（）

• A、An entry is created in the alert log file and the database instance continues to function normally
• B、The log switch hangs occur for transactions until free space is available in the flash recovery area
• C、The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area Oracle
• D、The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is jetting filled up very fast and it is running out of space. Your database flash recovery area is low on space and you have no more room on disk. Proactively, which two options could you use to make more space available in the flash recovery？（）

• A、Change the RMAN archived log deletion policy
• B、Use the RMAN CROSSCHECK command to reclaim the archived log space
• C、Change the RMAN retention policy to retain backups for a shorter period of time
• D、Use OS command to move files from the flash recovery area to some other location

第14题：

While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options to increase the space. However, you have another database where more space is available and you want to move your existing recovery catalog to this database. The options that can be considered while moving the recovery catalog are as follows:（） 1. Using one of the Oracle expdp utilities to export the catalog data 2. Creating a recovery catalog user and granting the necessary privileges in the other database 3. Creating the recovery catalog using the CREATE CATALOG command 4. Using the corresponding impdp utility to import the catalog data into the other database 5. Registering the target database in the new catalog database using the REGISTER DATABASE command Identify the option with the correct sequence for moving the recovery catalog.

• A、2, 3, 5
• B、1, 2, 4
• C、1, 2, 4, 5
• D、1, 2, 3, 4, 5

第15题：

You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）

• A、 multiplexed control files
• B、 RMAN obsolete backups
• C、 multiplexed online redo log files
• D、 archived redo logs that have not been copied to tape

第16题：

You configured the Flash Recovery Area （FRA） for your database. The database instance is runningin ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.  Which two files are removed automaticallyif the space is required in the FRA as per the retention policy（）

• A、flashback log files
• B、backups that have become obsolete
• C、copies of the data files and control files
• D、archived redo log files that have multiple copies in a different archive location and not backed up

第17题：

You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup?（）

• A、You are backing up to tape and your tape device performs its own compression.
• B、You are making image copies, and you have not enabled tablespace compression.
• C、You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited.
• D、You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.
• E、You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves  media costs and archival storage.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：