Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.
The change tracking file must always be backed up when you perform a full database backup.
Block change tracking will always reduce I/O performed during cumulative incremental backups.
More than one database block may be read by an incremental backup for a change made to a single block.
The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.
第1题:
Which RMAN backup command is used to create the block-change tracking file?()
第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?()
第3题:
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.)
第4题:
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?()
第5题:
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?()
第6题:
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>;
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;
第7题:
You need to mention it with every BACKUP command.
The block change tracking feature is used automatically by RMAN.
You need to configure it using the CONFIGURE command.
You need to set the necessary initialization parameters to direct RMAN to use the feature.
第8题:
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING
第9题:
The script is stored only in the control file.
The script is stored only in the recover catalog.
The script can be executed only by using the RMAN RUN command.
The commands of the script can be displayed with the LIST command.
The commands of the script can be displayed with the PRINT command.
The commands of the script can be displayed with the REPORT command.
第10题:
The backup performed on Sundays contains all the blocks that have ever been used in the database.
The backup performed on Sundays contains all the blocks that have changed since the last level 1 backup.
The backup performed on each working day contains all the blocks that have changed since the last level 0 backup.
The backup performed on Monday contains all the blocks that have changed since the level 0 backup, and every other working day contains all the blocks that have changed since the level 1 backup
第11题:
Multiple change tracking files can be created for a database.
The change tracking file must be created after the first level 0 backup.
RMAN does not support backup and recovery of the change tracking file.
The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.
第12题:
Multiple change tracking files can be created for a database.
The change tracking file must be created after the first level 0 backup.
RMAN does not support backup and recovery of the change tracking file.
The database clears the change tracking file and starts tracking changes again,after whole database restore and recovery operations.
第13题:
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()
第14题:
You work as a database administrator for Certkiller .com. According to your backup strategy, you performed an incremental level 0 backup of your database. Which statement regarding this backup is true?()
第15题:
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?()
第16题:
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?()
第17题:
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?()
第18题:
The block change tracking data will be used only from the next incremental 0 backup.
The incremental backup will use change tracking data for accomplishing the backup.
The incremental backup will not use change tracking data for accomplishing the backup.
The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.
第19题:
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
第20题:
Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.
The change tracking file must always be backed up when you perform a full database backup.
Block change tracking will always reduce I/O performed during cumulative incremental backups.
More than one database block may be read by an incremental backup for a change made to a single block.
The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.
第21题:
alter database create block change tracking file
alter database enable block change file
alter database enable block change tracking using file ,/ora01/opt/ block_change_tracking.fil
alter system enable block change tracking using file ’/ora01/opt/block_ change_tracking.fil’
alter system block change tracking on
第22题:
The block change tracking data will be used only from the next incremental 0 backup.
The incremental backup will use change tracking data for accomplishing the backup.
The incremental backup will not use change tracking data for accomplishing the backup.
The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.
第23题:
RMAN reads the block change tracking file only when it performs the incremental level 0 backup.
RMAN reads the block change tracking file when it performs both incremental backups.
RMAN reads the block change tracking file only when it performs the incremental level 1 backup.
RMAN does not read the block change tracking file when it performs either incremental backup.
第24题:
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING