单选题Examine the following RMAN script：   RMAN> run { debug on；  allocate channel c1 type disk； backup datafile 5； }   Which statement describes the purpose of the script？（）AThe data file is checked for physical corruption and backed up if found clean.BThe 

第1题：

第2题：

Examine the following RMAN script: RMAN> run { debug on; allocate channel c1 type disk; backup datafile 5; } Which statement describes the purpose of the script?（）

• A、The data file is checked for physical corruption and backed up if found clean.
• B、The backup of data file 5 is performed and the interactive messages during the backup are suppressed.
• C、The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.
• D、The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

第3题：

You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true？ （）

• A、It is a SQL script.
• B、It is a PL/SQL file.
• C、It is an operating system （OS） file.
• D、It is a Recovery Manager （RMAN） script

第4题：

Examine the following scenario： The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host， using the Recovery Manager （RMAN） duplicate command as follows：   RMAN> RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK；  DUPLICATE TARGET DATABASE TO auxdb； }   Which statement is true about the duplicate database in this scenario？（）  

• A、 It contains data till the last backup
• B、 It contains all data from target database until the current time
• C、 It contains all data from only the committed transactions in the target database
• D、 It contains all data except that which is used by the transactions in the current online redo file of target database

第5题：

In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN: RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2 BACKUP TYPE TO BACKUPSET; RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE disk FORMAT '/home/oracle/disk1/%U'; RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE disk FORMAT '/home/oracle/disk2/%U'; You issue the following RMAN command to backup the database: RMAN> RUN 2> { 3> ALLOCATE CHANNEL ch1 DEVICE TYPE disk; 4> BACKUP DATABASE; 5> } Which statement is true about the outcome?（）

• A、Only one channel is allocated and the backup is created in the flash recovery area
• B、Only one channel is allocated and the backup is created in the destination specified for channel 1
• C、Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2
• D、Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA

第6题：

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.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

第14题：

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.

第15题：

You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file， if it has already been backed up.（）

• A、 The data file backup is done with multiple channels
• B、 The data files is in the read-write mode after being backed up in the read only mode
• C、 The backup was taken after the data files was taken offline-normal or is in the read only mode
• D、 The data file backup complies with the back retention policy and the backup duplexing fe ture

第16题：

View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation：   RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8； BACKUP DATABASE FILESPERSET 4； }   What is the multiplexing level in the preceding backup process？（）

• A、 4
• B、 8
• C、 7
• D、 0

第17题：

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.

第18题：

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

第19题：

第20题：

第21题：

第22题：

第23题：