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.
Whichviewprovidesinformationonthebackupstatusofthedatafilesinthedatabase?() A.V$BACKUPB.V$BACKUP_STATUSC.V$BACKUP_DATAFILED.V$DATAFILE_BACKUPE.V$TABLESPCE_BACKUP
YouaremanaginganOracleDatabase11gdatabasewiththefollowingbackupstrategy:1)OnSunday,anincrementallevel0tapebackupisperformed.2)MondaythroughSaturday,acumulativeincrementallevel1tapebackupisperformed.Whichtwostatementsaretrueregardingthebackupsperformed()A.Thebackupperformedinstep1backsupallblocksthathaveeverbeeninuseinthedatabase.B.Thebackupperformedinstep2copiesalltheblockschangedsincethemostrecentlevel0backup.C.Thebackupperformedinstep1backsupalltheblockschangedsincethemostrecentlevel1backup.D.Thebackupperformedinstep2backsupallblocksthathavechangedsincethemostrecentincrementalbackupatlevel1
Youperformdifferentialincrementallevel1backupsofyourdatabaseoneachworkingdayandlevel0backuponSundays,totape.Whichtwostatementsaretrueaboutdifferentialincrementalbackups() A.ThebackupperformedonSundayscontainsalltheblocksthathaveeverbeenusedinthedatabase.B.ThebackupperformedonSundayscontainsalltheblocksthathavechangedsincethelastlevel1backup.C.Thebackupperformedoneachworkingdaycontainsalltheblocksthathavechangedsincethelastlevel0 backup.D.ThebackupperformedonMondaycontainsalltheblocksthathavechangedsincethelevel0backup,and everyotherworkingdaycontainsalltheblocksthathavechangedsincethelevel1backup
YouaremanaginganOracleDatabase11gdatabasewiththefollowingbackupstrategy:1.OnSunday,anincrementallevel0tapebackupisperformed.2.MondaythroughSaturday,acumulativeincrementallevel1tapebackupisperformed.Whichtwostatementsaretrueregardingthebackupsperformed()A.Thebackupperformedinstep1backsupallblocksthathaveeverbeeninuseinthedatabase.B.Thebackupperformedinstep2copiesalltheblockschangedsincethemostrecentlevel0backup.C.Thebackupperformedinstep1backsupalltheblockschangedsincethemostrecentlevel1backup.D.Thebackupperformedinstep2backsupallblocksthathavechangedsincethemostrecentincrementalbackupatlevel1.
YouaremanaginganOracleDatabase11gdatabasewiththisbackupstrategy:-EverySundaynight,level0backupisperformed.-OnMondaynightandsubsequentdays,level1incrementalbackupisperformed.Thebackupsarenotcumulativeincremental.WhichstatementaboutMonday’sbackupistrue()A.Thebackupcontainsalltheusedblocks.B.Thebackupcontainsalltheusedandunusedblocks.C.Thebackupcontainsblocksthathavechangedsincethelastlevel0backup.D.Thebackupcontainsblocksthathavechangedsincethelastlevel1backuptakenlastweek.
Examinethissyntaxwhichallocateschannelsduringaparallelimagecopy:RMANCONFIGUREDEVICETYPEdiskparallelism4:2COPY3datafile1TO‘/BACKUP/datafile1.dbf’,4datafile2TO‘/BACKUP/datafile2.dbf’,5datafile3TO‘/BACKUP/datafile3.dbf;RMANCOPY2datafile4TO‘/BACKUP/datafile4.dbf’;Howmanychannelsareused?()A.0B.1C.3D.4
YouissuethisRMANcommand:RMANcreatescriptLevel0Backup{backupincrementallevel0format‘/u01/db01/backup/%d_%_Sp’fileperset5(databaseincludecurrentcontrolfile);sql‘alterdatabasearchivelogcurrent’;}WhichthreestatementsaretrueabouttheLevel0Backupscriptyoujustcreated?()A.Thescriptisstoredonlyinthecontrolfile.B.Thescriptisstoredonlyintherecovercatalog.C.ThescriptcanbeexecutedonlybyusingtheRMANRUNcommand.D.ThecommandsofthescriptcanbedisplayedwiththeLISTcommand.E.ThecommandsofthescriptcanbedisplayedwiththePRINTcommand.F.ThecommandsofthescriptcanbedisplayedwiththeREPORTcommand.