单选题Examine the RMAN command： SWITCH DATAFILE ’/DISK3/user_data01.dbf’； Which command do you need to issue before you issue the above command， so that RMAN finds the file in the restored location of ’DISK2/user_data01.dbf’？ （）A RESTORE DATAFILE ’/DISK2/use

第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题：

Examine the following RMAN command：   RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON； RMAN> BACKUP DATABASE PLUS ARCHIVELOG；   Which prerequisite must be met before accomplishing the backup？（）

• A、 Provide a password for the encryption
• B、 Set up an Oracle wallet for the encryption
• C、 No setup is required as it is a default encryption method
• D、 Both Oracle wallet and password must be set up for the encryption

第3题：

You configured the default backup device type as disk for RMAN backups. In your database，because of business requirements，you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used.  What must you set using the RMAN CONFIGURE command to achieve this？（）  

• A、 MAXSETSIZE TO 2
• B、 DEVICE TYPE DISK PARALLELISM 2
• C、 RETENTION POLICY TO REDUNDANCY 2
• D、 DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2

第4题：

You execute the following command to perform a backup by using Recovery Manager （RMAN）： RMAN> run  {allocate channel c1 type sbt;  backup datafile 1;  }  The command errors out. A part of the error message is as follows：  RMAN/x7f03009： failure of allocate command on c1 channel  ORA/x7f19554： error allocating device， device type： SBT_TAPE， device name：  What could explain why the statement failed？（）

• A、sbt is not a valid device type.
• B、Media Management Library was not loaded.
• C、The sbt device cannot be used for data file backups.
• D、No path was defined in the ALLOCATE CHANNEL command.
• E、The channel is currently being used by another RMAN session.

第5题：

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

What does the output on this report indicate？（）   RMAN> report need backup；  RMAN retention policy will be applied to the command  RMAN retention policy is set to redundancy 1  Report of files with less than 1 redundant backups  File #bkps Name  5 0 C:///ORACLE/ORADATA/ORCL/MY_DATA_01.DBF  

• A、 The my_data_01.dbf datafile is corrupted and needs to be restored.
• B、 The my_data_01.dbf datafile has not yet been backed up. This report does not imply that the data in the datafile can not be recovered.
• C、 The my_data_01.dbf datafile has not yet been backed up. This report implies that the data in the datafile can not be recovered.
• D、 The my_data_01.dbf datafile no longer meets the retention criteria for backups.
• E、 Datafile 5 is missing.

第14题：

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

第15题：

In Recovery Manager （RMAN）， you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance after a regular maintenance task， you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the datafile by using the image copy. You could perform the following steps to accomplish this：   1） Mount the database  2） Take the data file offline  3） Bring the data file online  4） Use the RMAN SWITCH TO command to switch the image copy  5） Apply the archived redo logs  6） Open the database  7） Use the RMAN RESTORE TO command to switch to the image copy   Which two options illustrate the correct sequence of steps that you could follow？（）

• A、 2， 6， 4， 5， 3
• B、 1， 2， 4， 5， 3， 6
• C、 1， 2， 4， 6， 3
• D、 1， 2， 7， 5， 3， 6

第16题：

Given the script   create script db_backup_datafile_script  {backup datafile and 1， and2 plus archivelog delete input；} Run {execute script db_backup_datafile_script using 2；}   What is the result of running this command？（）  

• A、 The script will fail since you instructed RMAN to back up only one datafile rather than two
• B、 The script will successfully back up datafile 3 without error
• C、 The script will fail since it uses a substitution variable which is not supported
• D、 The execute script command will prompt for the value of and2 since it’s not included in the command
• E、 The script will fail because you cannot use the plus archivelog command when backing up

第17题：

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：