单选题You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB.  You issue the following command from the RMAN prompt to per

第1题：

Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - The recovery window is set to 7 days in RMAN. - The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007. - The TOOLS tablespace is read-only since November 4, 2007. On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?（）

• A、The RMAN backup fails because the TOOLS tablespace is read-only
• B、The RMAN skips the backup of the tablespace because backup optimization is enabled
• C、The RMAN makes backup because optimization can be enabled only for backups to disk
• D、The RMAN makes the backup because no backup of the tablespace exists within the seven day window

第2题：

You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for the RMAN. To accomplish the backup， you issued the following RMAN command：   RMAN> BACKUP SECTION SIZE 300M TABLESPACE users；   Which two statements are true regarding the execution of the above command？（）

• A、 The RMAN parallelizes the backup although the parallelism is not set for a channel.
• B、 The backup piece size will be limited to 300 MB.
• C、 The operation is accomplished using the default channel available.
• D、 Three channels for the tape drive must be configured by setting the parallelism to three.

第3题：

You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB.  You issue the following command from the RMAN prompt to perform a backup of the tablespace：   RMAN> BACKUP TABLESPACE TS1 MAXSETSIZE 100M；  Which statement is true about executing this command？（）

• A、 The command generates an error.
• B、 The command backs up the tablespace and creates a backup set of size 200 MB
• C、 The command backs up the tablespace and creates two backup sets of size 100 MB each.
• D、 The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.

第4题：

You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command：       RMAN>BACKUP DATABASE；  At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）

• A、 Start the database in the MOUNT stage.
• B、 Back up the control file to trace.
• C、 Set the DBID
• D、 Issue the RECOVER DATABASE command.

第5题：

You have control-file autobackups enabled. When starting your database from SQL*Plus， you receive the following error message：   SQL> startup ORA-01078： failure in processing system parameters LRM-00109：  could not open parameter file ，  C:///ORACLE/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.ORA Using RMAN，   how would you respond to this error？（）  

• A、 Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.
• B、 Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.
• C、 Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.
• D、 Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.
• E、 Issue the restore spfile from autobackup command from the RMAN prompt.

第6题：

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

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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

第14题：

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

第15题：

You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Identify the appropriate configuration to accomplish faster and optimized backups using the above command.（）

• A、The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.
• B、The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.
• C、The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.
• D、The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1

第16题：

Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the  database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands：        RMAN>RESTORE DATABASE；        RMAN>RECOVER DATABASE；   After successfully executing these RMAN commands， you issue the following statement using SQL*Plus：        SQL>ALTER DATABASE OPEN；   You receive the following errors when attempting to open the database：        ORA-01157： cannot identify/lock data file 10 see DBWR trace file        ORA-01110： data file 10： ’D:///USERS.DBF’   What is the cause of these errors？（）

• A、 The USERS.DBF datafile is corrupted and cannot be restored by RMAN.
• B、 The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.
• C、 The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.
• D、 The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.

第17题：

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

第18题：

You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup， you issued the following RMAN command：   RMAN>BACKUP SECTION SIZE 300M TABLESPACE users；   What configuration should be effected to accomplish faster and optimized backups by using the above command？（）

• A、 The SBT channel must be configured， with the default parallelism setting for the SBT device set to 1
• B、 The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0
• C、 The SBT channel must be configured， with the parallelism setting for the SBT device set to 3
• D、 The SBT channel must be configured， with the MAXPIECESIZE set to 300 MB

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：