You notice that your RMAN script used to copy the datafiles，

第1题：

Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement：   SQL> DROP TABLE SCOTT.EMP PURGE；   After one hour， you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup？（）

• A、 the datafiles associated with the SYSTEM tablespace
• B、 the datafiles associated to the DATA1 tablespace
• C、 the datafiles associated to the SYSTEM and DATA1 tablespaces
• D、 all the datafiles in the database

第2题：

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

第3题：

第4题：

You are migrating your production database from non-ASM to ASM storage. You used the RMAN utility to migrate the database from non-ASM to ASM storage. Which type of backup command script will you use for migrating the database from non-ASM to ASM storage？（）

• A、 BACKUP AS BACKUPSET
• B、 BACKUP AS COPY
• C、 BACKUP AS COMPRESSED BACKUPSET
• D、 BACKUP INCREMENTAL LEVEL n CUMULATIVE

第5题：

You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）

• A、Database Datafiles 
• B、Database Control Files 
• C、Online redo logs
• D、Archived redo logs 
• E、The database SPFILE 
• F、None of the above, all these files are backed up. 

第6题：

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?（） (Choose two.)

• 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

第7题：

You issue the following command：   RMAN>CONFIGURE BACKUP OPTIMIZATION ON；   What is the result of this command on your backups？（）

• A、 An incremental backup strategy will be used automatically.
• B、 Read-only datafiles will not be backed up as long as backups of those files already exist and those backups meet established retention criteria.
• C、 RMAN will configure itself for maximum performance at the cost of CPU.
• D、 RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database.
• E、 RMAN will automatically compress backups.

第8题：

第9题：

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

第10题：

You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?（）

• A、The backup as copy can only be taken to disk
• B、The backup as copy can only be taken to tape
• C、Backup can be performed only when the instance is shutdown
• D、Backup will constitute all used and unused blocks in the database