Performing Oracle User-Managed Backups - OCP: Oracle Database 12c Administrator Certified Professional - page 53

9. Which of the following will cause instance recovery to occur? (Choose all that apply.)
A. Power failure causes the database server to crash.
B. You issue a SHUTDOWN IMMEDIATE command from the SQL prompt.
C. You issue the ALTER DATABASE CHECKPOINT command.
D. You issue the SHUTDOWN ABORT command from the SQL prompt.
E. You issue the SHUTDOWN TRANSACTIONAL command from the SQL prompt.
10. What parameter controls how often the database checkpoints and also tries to reduce
the time that instance recovery will take?
A. FAST_START_RECOVERY
B. MTTR_TARGET
C. RESTART_FAST
D. CHECKPOINT_TIME
E. FAST_START_MTTR_RECOVERY
11. Which of the following database processes have some purpose in Oracle database oper-
ations that apply to database backup and recovery? (Choose all that apply.)
A. DBW
B. LGWR
C. DNNR
D. THREADn
E. PQOn
12. What is most impacted by the delay between committing a transaction and the time
that the data associated with that change is written to disk?
A. Media recovery
B. Archiving
C. Instance recovery
D. Transaction completion time
E. Database creation time
13. Which of the following files are likely to be found in the diagnostic destination direc-
tory of an Oracle database?
A. Database trace files
B. Database data files
C. Listener files
D. Database parameter files
E. Database alert log