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

4. Given a complete loss of your database, in what order would you need to perform the
following RMAN operations to restore it?
a. RESTORE CONTROLFILE
b. RESTORE DATABASE
c. RESTORE SPFILE
d. RECOVER DATABASE
e. ALTER DATABASE OPEN
f. ALTER DATABASE OPEN RESETLOGS
A. b, a, c, d, e
B. a, c, b, d, f
C. c, a, b, d, e
D. c, a, b, d, f
E. e, a, b, d, c
5. If you lost your entire database, including the database spfile, control files, online redo
logs, and database data files, what kind of recovery would be required with RMAN?
A. Complete database recovery.
B. Incomplete database recovery.
C. Approximate database recovery.
D. Archived database recovery.
E. The database could not be recovered with RMAN.
6. Which command will restore all data files to the date 9/30/2013 at 18:00 hours?
A. RESTORE DATAFILES UNTIL TIME '09/28/2013:21:03:11';
B. RESTORE DATABASE FILES UNTIL TIME '09/28/2013:18:00:00';
C. RESTORE DATABASE UNTIL TIME '09/28/2013:18:00:00';
D. RECOVER DATABASE UNTIL TIME '09/28/2013:18:00:00';
E. RECOVER DATABASE UNTIL TIMESTAMP '09/28/2013:18:00:00';