Performing Oracle User-Managed Database Recoveries - OCP: Oracle Database 12c Administrator Certified Professional - page 98

4. STARTUP MOUNT the database.
5. Issue an ALTER DATABASE CLEAR LOGFILE command.
6. Recover all database data files.
A. 1,2,3,4
B. 2,4,5,6
C. 1,2,4,5,3
D. 2,6,4,6,3
E. 2,4,1,3
7. What methods of point-in-time recovery are available in ARCHIVELOG mode?
(Choose all that apply.)
A. Change-based
B. Cancel-based
C. Time-based
D. Sequence number-based
E. Transaction number-based
8. Which files are required for a full recovery of the database in ARCHIVELOG mode?
(Choose three.)
A. Database data files
B. Online redo logs
C. Archived redo logs
D. Backup control file
E. Control file from a backup
9. What methods of point-in-time recovery are available in NOARCHIVELOG mode?
A. Change-based
B. Cancel-based
C. Time-based
D. Sequence number-based
E. None of the above
10. Upon starting your ARCHIVELOG mode database, you receive the following error:
SQL> startup
ORACLE instance started.
Total System Global Area 171581440 bytes
Fixed Size 1298640 bytes