Recovering Databases with RMAN - OCP: Oracle Database 12c Administrator Certified Professional - page 237

17. 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?
A. RECOVER LOST BLOCKS;
B. RECOVER CORRUPT BLOCKS;
C. RECOVER MEDIA CORRUPT BLOCKS FROM LIST;
D. RECOVER CORRUPT BLOCKS FROM LIST;
E. RECOVER CORRUPTION LIST;
18. What will be the end result of this set of RMAN commands?
shutdown abort
startup mount
restore datafile 4 until time '09/30/2013:15:00:00';
recover datafile 4 until time '09/29/2013:15:00:00';
alter database open resetlogs;
A. Data file 4 will be recovered until 9/30/2013 at 15:00 and the database will open.
B. The RESTORE command will fail.
C. The RECOVER command will fail.
D. The ALTER DATABASE OPEN RESETLOGS command will fail.
E. All these commands will fail because they must be in the confines of a RUN block.
19. Which of the following represents the correct way to perform an online recovery of
data file 4, which is assigned to a tablespace called USERS ?
A. SHUTDOWNRESTORE DATAFILE 4;RECOVER DATAFILE 4;ALTER DATABASE OPEN;
B. SQL 'ALTER DATABASE DATAFILE 4 OFFLINE';RESTORE DATAFILE 4;RECOVER
DATAFILE 4;ALTER DATABASE OPEN;
C. SQL 'ALTER DATABASE DATAFILE 5 OFFLINE';RESTORE DATAFILE 4;SQL 'ALTER
DATABASE DATAFILE 4 ONLINE';
D. SQL 'ALTER DATABASE DATAFILE 4 OFFLINE';RESTORE DATABASE DATAFILE
4;RECOVER DATABASE DATAFILE 4;SQL 'ALTER DATABASE DATAFILE 4 ONLINE';
E. SQL 'ALTER DATABASE DATAFILE 4 OFFLINE';RESTORE DATAFILE 4;RECOVER
DATAFILE 4;SQL 'ALTER DATABASE DATAFILE 4 ONLINE';