多选题You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace：  RMAN> BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully？ （）AThe database is in NOMOUNT state.BThe datab

第1题：

You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager （RMAN）. The most recent backup of the TOOLS tablespace to disk was taken on January 3. The TOOLS tablespace is read/x7fonly.  On February 21， when you execute a command to back up all the tablespaces to disk， you find that RMAN backs up the TOOLS tablespace also， even though the contents of the tablespace have not changed after the backup on January 3.  Because there are no changes made to the TOOLS tablespace， you decide that the tablespace should not be backed up by RMAN. What can you to do skip backing up the TOOLS tablespace without changing the current backup optimization setting？（）

• A、configure a default device for RMAN backups
• B、temporarily disable the retention policy for RMAN backups
• C、configure automatic channel allocation for RMAN backups
• D、use the CONFIGURE command to reconfigure the recovery window to 60 days

第2题：

You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（） 

• A、back up the control file to trace
• B、bring database to the MOUNT state
• C、open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database
• D、set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

第3题：

You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files：  $ rman target /  What would be the effect of this command？（）

• A、RMAN would use the current operating system location to place the backup.
• B、RMAN would use the control file of the target database to maintain the backup.
• C、RMAN would use the recovery catalog of the target database to maintain the backup.
• D、RMAN would use the control file of the target database to maintain the backup metadata. 
• E、RMAN would use the recovery catalog of the target database to maintain the backup metadata.

第4题：

You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB.  You issue the following command from the RMAN prompt to perform a backup of the tablespace：   RMAN> BACKUP TABLESPACE TS1 MAXSETSIZE 100M；  Which statement is true about executing this command？（）

• A、 The command generates an error.
• B、 The command backs up the tablespace and creates a backup set of size 200 MB
• C、 The command backs up the tablespace and creates two backup sets of size 100 MB each.
• D、 The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.

第5题：

You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database：  RMAN> REPORT NEED BACKUP days 3;  What would be the output of this command？（） 

• A、a list of files that require a backup within three days
• B、a list of files that have not been backed up for three days
• C、a list of files that RMAN recommends be backed up only once in every three days， based on low volatility
• D、a list of files for which a backup has already been performed and may need a backup after three days

第6题：

You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）

• A、 target database
• B、 auxiliary database
• C、 third-party database
• D、 recovery catalog database

第7题：

You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager （RMAN）. The most recent backup of the TOOLStablespace to disk was taken on January 3. The TOOLStablespace is read-only.On February 21， when you execute a command to back up all the tablespaces to disk， you find that RMAN backs up the TOOLS tablespace also， even though the contents of the tablespace have not changed after the backup on January 3. Because there are no changes made to the TOOLStablespace， you decide that the tablespace should not be backed up by RMAN. What can you do to skip backing up the TOOLStablespace without changing the current backup optimization setting？（）

• A、 configure a default device for RMAN backups
• B、 temporarily disable the retention policy for RMAN backups
• C、 configure automatic channel allocation for RMAN backups
• D、 use the CONFIGURE command to reconfigure the recovery window to 60 days

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? （）(Choose two.)

• A、The backup piece size will be limited to 300 MB
• B、The RMAN uses multiplexing to perform backup
• C、The operation is accomplished using the default channel available
• D、The RMAN parallelizes the backup although the parallelism is not set for a channel

第14题：

Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - The recovery window is set to 7 days in RMAN. - The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007. - The TOOLS tablespace is read-only since November 4, 2007. On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?（）

• A、The RMAN backup fails because the TOOLS tablespace is read-only
• B、The RMAN skips the backup of the tablespace because backup optimization is enabled
• C、The RMAN makes backup because optimization can be enabled only for backups to disk
• D、The RMAN makes the backup because no backup of the tablespace exists within the seven day window

第15题：

You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace： RMAN> BACKUP TABLESPACE DETTBS；  Under which conditions would this command execute successfully？ （）

• A、 The database is in NOMOUNT state.
• B、 The database is in NOARCHIVELOG mode and the tablespace is online.
• C、 The database is in NOARCHIVELOG mode and the tablespace is offline.
• D、 The database is in ARCHIVELOG mode and the tablespace is offline.
• E、 The database is in ARCHIVELOG mode and the tablespace is online.

第16题：

In Recovery Manager （RMAN）， you have set control file autobackup to ON by using the following command： CONFIGURE CONTROLFILE AUTOBACKUP ON； Which two events would cause the control file to be backed up automatically？ （）

• A、 A tablespace is taken offline.
• B、 The database instance is restarted.
• C、 A new data file is added to an existing tablespace.
• D、 A successful backup is recorded in the RMAN repository.
• E、 The RMAN connection is disconnected from the target database.

第17题：

Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the  database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands：        RMAN>RESTORE DATABASE；        RMAN>RECOVER DATABASE；   After successfully executing these RMAN commands， you issue the following statement using SQL*Plus：        SQL>ALTER DATABASE OPEN；   You receive the following errors when attempting to open the database：        ORA-01157： cannot identify/lock data file 10 see DBWR trace file        ORA-01110： data file 10： ’D:///USERS.DBF’   What is the cause of these errors？（）

• A、 The USERS.DBF datafile is corrupted and cannot be restored by RMAN.
• B、 The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.
• C、 The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.
• D、 The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.

第18题：

You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）

• A、The backup status will be marked expired in RMAN recovery catalog.
• B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.
• C、The backup will be deleted physically from the OS （Operating system）and the backup information is removed from the recovery catalogl
• D、The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）.
• E、The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）， if you are not using Oracle Managed Files （OMF）.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：