You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup?()
第1题:
You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sundays, to tape. Which two statements are true about differential incremental backups()
第2题:
Which of the following views must you query to identify any corrupt data file blocks that have been detected during backup set creation?()
第3题:
You are performing a block media recovery on the tools01.dbf data file in the SALES database using RMAN. Which two statements are correct in this scenario?()
第4题:
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?()
第5题:
You perform differential incremental level 1 backups of your database on each working day and level 0 backupon Sundays, to tape. Which two statements are true about differential incremental backups()
第6题:
You execute the following RMAN command in the order shown below: BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do?()
第7题:
If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT, what RMAN command would you run to correct the problem?()
第8题:
The block change tracking feature is enabled, and the information about the system change number is written in the change tracking file.
The block change tracking feature is enabled, and the information about the log sequence number is written in the change tracking file.
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.
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.
第9题:
redo log files
password file
control file
change tracking file
第10题:
The backup is similar to image copy.
The backup contains all used data blocks.
The backup contains only unused data blocks.
The backup contains all data blocks changed since the last incremental level 1 backup.
第11题:
recover lost blocks
recover corrupt blocks
recover media corrupt blocks from list
recover corrupt blocks from list
recover corruption list
第12题:
You must ensure that the SALES database is mounted or open.
You must restore a backup control file to perform a block media recovery.
You must take the tools01.dbf data file offline before you start a block media recovery.
You must put the database in NOARCHIVELOG mode to perform a block media recovery.
You can perform only a complete media recovery of individual blocks; point-in-time recovery of individual data blocks is not supported.
第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()
第14题:
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?()
第15题:
You execute the following RMAN commands in the order shown below: BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do?()
第16题:
Which two statements are true about Block Media Recovery (BMR)?()
第17题:
You executed the following code: BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will be the result of executing the above code?()
第18题:
Users complain SQL statements using a particular index fail. Using DBVERIFY, you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large. What is the least disruptive recover strategy available in Oracle9i?()
第19题:
Reduced MTTR.
Datafiles remain offline while corrupt blocks are repaired.
Datafiles remain online while corrupt blocks are repaired.
A and C
第20题:
The backup contains all the used blocks.
The backup contains all the used and unused blocks.
The backup contains blocks that have changed since the last level 0 backup.
The backup contains blocks that have changed since the last level 1 backup taken last week.
第21题:
The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks, if any, recorded in the view.
The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view.
The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks, if any, recorded in the view.
The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks, if any, recorded in the view.
第22题:
The backup is similar to image copy.
The backup contains all used data blocks.
The backup contains only unused data blocks.
The backup contains all data blocks changed since the last incremental level 1 backup.
第23题:
V$BACKUP_CORRUPTION
V$COPY_CORRUPTION
V$DATABASE_BLOCK_CORRUPTION
RC_BACKUP_CORRUPTION