Your company decided to start using RMAN in its backup strategy. Previously your company used operating system file copies. Which command is used to make RMAN aware of existing backups made by copying files at the operating system？（）A、CHANGEB、RESYNCC、CATA

第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 are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database？（）

• A、SYSDBA
• B、SYSOPER
• C、No system privileges are required for the RMAN user.
• D、Only SYS user can connect and execute RMAN commands on a target database.

第3题：

You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）

• A、 online redo log files
• B、 alert log files
• C、 control file
• D、 datafiles associated with the SYSTEM tablespace

第4题：

You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager （RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？ （）

• A、 RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.
• B、 RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location， defined using OMF
• C、 RMAN would relocate all the database files to an ASM disk group.
• D、 RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.

第5题：

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.

第6题：

You are using the backup scheduler in Enterprise Manager （EM） to schedule a backup of your database. Which type of script does the backup scheduler generate？ （）

• A、SQL script
• B、PL/SQL script
• C、Operating System （OS） script
• D、Enterprise Manager （EM） script
• E、Recovery Manager （RMAN） script

第7题：

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）.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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

第14题：

You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE,Which statement is true of this command?（）

• A、A different procedure is required to restore a database from compressed backups 
• B、The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies. 
• C、Using this command to create backups minimizes the bandwidth consumed.
• D、Using this command to create backups improves the performance of the backup process 

第15题：

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

第16题：

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

第17题：

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

第18题：

You perform a backup using the following BACKUP command：   RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE；   Which statement is true of this command？（）  

• A、 A different procedure is required to restore a database from compressed backups
• B、 The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed  backup sets and image copies.
• C、 Using this command to create backups minimizes the bandwidth consumed
• D、 Using this command to create backups improves the performance of the backup process

第19题：

第20题：

第21题：

第22题：

第23题：