网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

You performed an incremental level 0 backup of a database:RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;To enable block change tracking after the incremental level 0 backup, you issued this command:SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ‘ /mydir/rman_change_track.f’;To perform an incremental level 1 cumulative backup, you issued this command:RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;Which three statements are true?()

A. Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.

B. The change tracking file must always be backed up when you perform a full database backup.

C. Block change tracking will always reduce I/O performed during cumulative incremental backups.

D. More than one database block may be read by an incremental backup for a change made to a single block.

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


参考答案

更多 “ You performed an incremental level 0 backup of a database:RMAN BACKUP INCREMENTAL LEVEL 0 DATABASE;To enable block change tracking after the incremental level 0 backup, you issued this command:SQL ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ‘ /mydir/rman_change_track.f’;To perform an incremental level 1 cumulative backup, you issued this command:RMAN BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;Which three statements are true?()A. Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.B. The change tracking file must always be backed up when you perform a full database backup.C. Block change tracking will always reduce I/O performed during cumulative incremental backups.D. More than one database block may be read by an incremental backup for a change made to a single block.E. 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. ” 相关考题
考题 After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?() A. Opening the database in RESTRICTED modeB. Opening the database with the RESETLOGS optionC. Setting a new DBID for the newly restored databaseD. Restoring the server parameter file (SPFILE) to the new host

考题 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 USINGFILE ‘/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.

考题 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.

考题 Examinethefollowingcommandusedtoperformincrementallevel0backup:RMANBACKUPINCREMENTALLEVEL0DATABASE;Toenabletheblockchangetracking,aftertheincrementallevel0backupyouissuedthefollowingcommand:SQLALTERDATABASEENABLEBLOCKCHANGETRACKINGUSINGFILE’/mydir/rman_change_track.f’;Toperformincrementallevel1cumulativebackup,youissuedthefollowingcommand:RMANBACKUPINCREMENTALLEVEL1CUMULATIVEDATABASE;Whichtwostatementsaretrueintheabovesituation?()A.Theblockchangetrackingdatawillbeusedonlyfromthenextincremental0backup.B.Theincrementalbackupwillusechangetrackingdataforaccomplishingthebackup.C.Theincrementalbackupwillnotusechangetrackingdataforaccomplishingthebackup.D.Theblocktrackfilewillscanalltheblocksandcreatebitmapforalltheblocksbackedupinthelevel0backup.

考题 Youperformdifferentialincrementallevel1backupsofyourdatabaseoneachworkingdayandlevel0backuponSundays,totape.Whichtwostatementsaretrueaboutdifferentialincrementalbackups() A.ThebackupperformedonSundayscontainsalltheblocksthathaveeverbeenusedinthedatabase.B.ThebackupperformedonSundayscontainsalltheblocksthathavechangedsincethelastlevel1backup.C.Thebackupperformedoneachworkingdaycontainsalltheblocksthathavechangedsincethelastlevel0 backup.D.ThebackupperformedonMondaycontainsalltheblocksthathavechangedsincethelevel0backup,and everyotherworkingdaycontainsalltheblocksthathavechangedsincethelevel1backup

考题 Youexecutedthefollowingcode:BACKUPVALIDATEDATABASE;BLOCKRECOVERCORRUPTIONLIST;Whatwillbetheresultofexecutingtheabovecode?() A.ThecodewillrunabackupvalidationtopopulatetheV$BACKUP_CORRUPTIONviewandrepaircorruptblocks,ifany,recordedintheview.B.ThecodewillrunabackupvalidatetopopulatetheV$COPY_CORRUPTIONviewandthenrepairanycorruptblocksrecordedintheview.C.ThecodewillrunsabackupvalidatetopopulatetheV$DATABASE_BLOCK_CORRUPTIONviewandthenrepaircorruptblocks,ifany,recordedintheview.D.ThecodewillrunabackupvalidatetopopulatetheRC_BACKUP_CORRUPTIONviewandthenrepaircorruptblocks,ifany,recordedintheview.

考题 YouareusingtheBlockMediaRecoveryfeaturetorecovertheblocksthataremarkedcorruptsincethelastbackup.Whichviewwillyouquerytodisplayinformationaboutthedatablocksthataremarkedcorruptsincethelastbackup?() A.V$BACKUP_CORRUPTIONB.V$COPY_CORRUPTIONC.V$DATABASE_BLOCK_CORRUPTIOND.RC_BACKUP_CORRUPTION

考题 YouaremanaginganOracleDatabase11gdatabasewiththisbackupstrategy:-EverySundaynight,level0backupisperformed.-OnMondaynightandsubsequentdays,level1incrementalbackupisperformed.Thebackupsarenotcumulativeincremental.WhichstatementaboutMonday’sbackupistrue()A.Thebackupcontainsalltheusedblocks.B.Thebackupcontainsalltheusedandunusedblocks.C.Thebackupcontainsblocksthathavechangedsincethelastlevel0backup.D.Thebackupcontainsblocksthathavechangedsincethelastlevel1backuptakenlastweek.

考题 Whichofthefollowingbackuptypeswillresetthearchivebit?() A.FullB.CompressedC.CopyD.DifferentialE.Incremental