单选题You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands： STARTUP MOUNT； BACKUP  FORMAT ’/BACKUP/df_%d_%s_%p.bus’  DATABASE filesperset = 2；  Which components are included in the backup？（）A Only the data fi

第1题：

Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）

• A、You need to perform the restore and recover operations manually, because the backup was made manually. 
• B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. 
• C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. 
• D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 

第2题：

You want to perform the database backup when user activity on your system is low, such as between 12:00 a.m. and 2:00 am. Which command terminates with an error if the backup is not complete at the end of the specified duration?（）

• A、RMAN> BACKUP DURATION 2:00 MINIMIZE LOAD DATABASE
• B、RMAN> BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASE
• C、RMAN> BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE 
• D、RMAN> BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE

第3题：

第4题：

It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager （RMAN）. How would you make use of this consistent backup in RMAN？（）

• A、cannot be used in RMAN
• B、by starting up the database again
• C、by using the CATALOG command of RMAN
• D、by using the RECOVER CATALOG command in RMAN
• E、by re-creating the target control file to rebuild the RMAN repository

第5题：

Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups.  Which two backups would you be able to perform when the database is being accessed by users？（）

• A、backup of offline tablespaces
• B、backup of read­only tablespaces
• C、backup of system­critical tablespaces
• D、backup of online， locally managed tablespaces
• E、backup of read/write dictionary­managed tablespaces

第6题：

Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）

• A、 control file
• B、 all datafiles
• C、 password file
• D、 online redo log file
• E、 archive redo log file
• F、 server parameter file
• G、 only the SYSTEM datafile

第7题：

You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands： STARTUP MOUNT； BACKUP  FORMAT ’/BACKUP/df_%d_%s_%p.bus’  DATABASE filesperset = 2；  Which components are included in the backup？（）

• A、Only the data files.
• B、Only the data files and the online logs.
• C、The data files， control files， and the online logs.
• D、The data files and control files， but not the online logs.

第8题：

You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）

• A、A backup of the target database when it is mounted
• B、A backup of online redo log files when the database is open
• C、A backup of only used data blocks in the file beingbeingbackup up
• D、A backup of online， read/write data files when the database is open
• E、A backup of only those data blocks that have changed since a previous backup
• F、A backup of online， read/write data files when the database is in the NOMOUNT state.

第9题：

Examine the following command used to perform incremental level 0 backup：   RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE；   To enable the block change tracking， after the incremental level 0 backup you issued the following command：   SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ’/mydir/ rman_change_track.f’；To perform incremental level 1 cumulative backup， you issued the following command：   RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE；   Which two statements are true in the above situation？（）

• A、 The block change tracking data will be used only from the next incremental 0 backup.
• B、 The incremental backup will use change tracking data for accomplishing the backup.
• C、 The incremental backup will not use change tracking data for accomplishing the backup.
• D、 The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.

第10题：

In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN> RESTORE CONTROLFILE;  Which two operations do you need to perform after restoring the control file from backup？（）

• A、shut down and restart the instance
• B、add new tempfiles to the temporary tablespaces after recovery
• C、perform a media recovery and open the database with the RESETLOGS option
• D、perform a media recovery and bring the database to NOARCHIVELOG mode