单选题What does the minimize load database parameter mean when backing up a database?（）A RMAN will attempt to make the backup run as fast as possible without any IO limitations. B RMAN will automatically restrict the number of channels in use to one. C RMAN 

第1题：

What does the minimize load database parameter mean when backing up a database?（）

• A、RMAN will attempt to make the backup run as fast as possible without any IO limitations. 
• B、RMAN will automatically restrict the number of channels in use to one. 
• C、RMAN will spread the backup IO over the total duration stated in the backup command.
• D、RMAN will skip any datafile that currently is involved in an IO operation. RMAN will retry backing up the datafile later and an error will be raised at the end of the backup if the datafile cannot be backed up. 
• E、Datafiles will be backed up; those having the lowest current number of IO operations will be backed up first. 

第2题：

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

第3题：

第4题：

Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）

• A、 when you change the name of a datafile
• B、 when you drop a table from the database
• C、 when you take an export of the database
• D、 when you back up the database using OS utilities
• E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
• F、 when you issue a BACKUP command from inside the RMAN run block

第5题：

When you are allowing RMAN to backup your archived redo log files，how does RMAN know which archived redo logs to back up from your archive log destination？（）

• A、RMAN keeps a list of archive logs in a text file.
• B、The DBA must manually tell RMAN which archive logs to backup.
• C、RMAN has access to target control file and/or catalog information.
• D、RMAN looks at the ARCHIVE_LOG_DEST parameter of your target database and backs up all archive logs found.

第6题：

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. 

第7题：

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

第8题：

Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager （RMAN）.（）

• A、 You can use RMAN stored scripts.
• B、 Recovery is faster if data is stored in catalog in addition to the control file.
• C、 You can store backup Information of all registered databases in one place.
• D、 Database backups are automatically deleted when they are older than the specified time period.

第9题：

You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script？（）  

• A、 run { open script backup_database； run script backup_database }
• B、 run { engage script backup_database； }
• C、 run { run script backup_database； }
• D、 Run { execute script backup_database； }
• E、 The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.

第10题：

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