单选题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

第1题：

You issued the following command： ALTER DATABASE ENABLE BLOCK CHANGE TRACKING；  What will be the result of issuing this command？（）

• A、 The block change tracking feature is enabled， and the information about the system change number is written in the change tracking file.
• B、 The block change tracking feature is enabled， and the information about the log sequence number is written in the change tracking file.
• C、 The block change tracking feature is enabled， and the information about the blocks that are changed since the last backup is written in the change tracking file.
• D、 The block change tracking feature is enabled， and the information about the locations of the datafiles and the online redo log files are written in the change tracking file.

第2题：

You are managing an Oracle Database 11g database with the following backup strategy：1） On Sunday， an incremental level 0 tape backup is performed.2） Monday through Saturday， a cumulative incremental level 1 tape backup is performed. Which twostatements are true regarding the backups performed（）

• A、The backup performed in step 1 backs up all blocks that have ever been in use in the database.
• B、The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup.
• C、The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup.
• D、The backup performed in step 2 backs up all blocks that have changed since the most recent incrementalbackup at level 1

第3题：

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.

第4题：

To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file? （）(Choose two.)

• A、Multiple change tracking files can be created for a database.
• B、The change tracking file must be created after the first level 0 backup.
• C、RMAN does not support backup and recovery of the change tracking file.
• D、The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

第5题：

You are managing a database for which incremental backups can be very time consuming. In order to perform optimized incremental backups you enable the block change tracking feature.How would you instruct RMAN to use the block change tracking feature when performing incremental backups？（）

• A、 You need to mention it with every BACKUP command.
• B、 The block change tracking feature is used automatically by RMAN.
• C、 You need to configure it using the CONFIGURE command.
• D、 You need to set the necessary initialization parameters to direct RMAN to use the feature.

第6题：

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

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You are managing an Oracle Database 11g database with this backup strategy：  - Every Sunday night， level 0 backup is performed.  - On Monday night and subsequent days， level 1 incremental backup is performed.  The backups are not cumulative incremental.  Which statement about Monday’s backup is true（）

• A、The backup contains all the used blocks.
• B、The backup contains all the used and unused blocks.
• C、The backup contains blocks that have changed since the last level 0 backup.
• D、The backup contains blocks that have changed since the last level 1 backup taken last week.

第14题：

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

第15题：

You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）

• A、 redo log files
• B、 password file
• C、 control file
• D、 change tracking file

第16题：

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.

第17题：

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.

第18题：

You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.Which statement should you use to enable the block change tracking feature?（）

• A、ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
• B、ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE
• C、ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
• D、ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：