多选题You issue this RMAN command：   RMAN> create script Level0Backup {   backup   incremental level 0   format ‘/u01/db01/backup/%d_%_Sp’   fileperset 5   （database include current controlfile）；   sql ‘alter database archive log current’；   }  Which three s

第1题：

You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands： STARTUP MOUNT； BACKUP  FORMAT ’/BACKUP/df_%d_%s_%p.bus’  DATABASE filesperset = 2；  Which components are included in the backup？（）

• A、Only the data files.
• B、Only the data files and the online logs.
• C、The data files， control files， and the online logs.
• D、The data files and control files， but not the online logs.

第2题：

Examine the following command used to perform incremental level 0 backup：   RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE；   To enable the block change tracking， after the incremental level 0 backup you issued the following command：   SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ’/mydir/ rman_change_track.f’；To perform incremental level 1 cumulative backup， you issued the following command：   RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE；   Which two statements are true in the above situation？（）

• A、 The block change tracking data will be used only from the next incremental 0 backup.
• B、 The incremental backup will use change tracking data for accomplishing the backup.
• C、 The incremental backup will not use change tracking data for accomplishing the backup.
• D、 The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.

第3题：

You issued the following RMAN command：  RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；     What is NOT an impact of using the above command？（）

• A、 When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.
• B、 When a structural change is made to the database， then a backup of the current control file is performed.
• C、 When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.
• D、 When a structural change is made to the database， then a backup of the alert log file will be performed.

第4题：

You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE; The next day, you issue the following command: BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which statement about the use of the change tracking file is true?（）

• A、RMAN reads the block change tracking file only when it performs the incremental level 0 backup.
• B、RMAN reads the block change tracking file when it performs both incremental backups.
• C、RMAN reads the block change tracking file only when it performs the incremental level 1 backup.
• D、RMAN does not read the block change tracking file when it performs either incremental backup.

第5题：

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

第6题：

You issue the following command on the RMAN prompt.   RMAN> REPORT NEED BACKUP DAYS = 5 DATABASE；   Which statement is true about executing this command？（）

• A、 It will display a list of files that need incremental backup.
• B、 It will display a list of files that need backup after five days.
• C、 It will display a list of files that were backed up in the last five days.
• D、 It will display a list of files that have not been backed up in the last five days.
• E、 It will apply the current retention policy to determine the files that need to be backed 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 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.

第15题：

Which command will result in a trace file being created with the create controlfile command contained in it？（）  

• A、 alter database backup controlfile
• B、 alter database backup controlfile to trace
• C、 alter database controlfile backup
• D、 alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’
• E、 alter database begin controlfile backup

第16题：

You issue this RMAN command：   RMAN> create script Level0Backup {   backup   incremental level 0   format ‘/u01/db01/backup/%d_%_Sp’   fileperset 5   （database include current controlfile）；   sql ‘alter database archive log current’；   }  Which three statements are true about the Level0Backup script you just created？（）

• A、The script is stored only in the control file.
• B、The script is stored only in the recover catalog.
• C、The script can be executed only by using the RMAN RUN command.
• D、The commands of the script can be displayed with the LIST command.
• E、The commands of the script can be displayed with the PRINT command.
• F、The commands of the script can be displayed with the REPORT command.

第17题：

In which scenario will you issue the following command？（）      SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING        BACKUP CONTROLFILE；

• A、 when all the control files are missing and only a binary backup of the current control file exists
• B、 when a multiplexed copy of the current control file is missing
• C、when all the control files are missing and only a script containing the CREATE CONTROLFILE statement exists
• D、 when the SPFILE is missing

第18题：

You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery？（）  

• A、 You will need to open the database with the resetlogs command.
• B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
• C、 You will use the resetlogs version of the create controlfile command.
• D、 You will use the noresetlogs version of the create controlfile command.
• E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：