Answers to Review Questions - OCP: Oracle Database 12c Administrator Certified Professional - page 662

Chapter 1: Performing Oracle
User-Managed Backups
1. C, F. The two logging modes that are available in Oracle are NOARCHIVELOG
mode—which is the default—and ARCHIVELOG mode. In NOARCHIVELOG mode,
the database does not create archived redo logs, and as a result the recovery options are
fewer. In ARCHIVELOG mode, the database creates archived redo logs and this results
in a much larger number of options.
2. C. You will have to wait until you can shut down the database since it's in
NOARCHIVELOG mode. No other option will give you a backup that is recoverable.
3. B. The database should be in ARCHIVELOG mode.
4. B, E. B and E are the correct answers because ARCHIVELOG and NOARCHIVELOG
are the two logging modes available in Oracle Database 12 c .
5. A, C, D. A backup of any database in ARCHIVELOG mode should include the data-
base data files (after they are put in backup mode), the archived redo logs, and the
database control file.
6. A. The SCN is a number that represents a point in time in the database relative to
transactions within a given database.
7. B, D. The ALTER DATABASE BACKUP CONTROLFILE TO TRACE command will create a
trace file with the create controlfile commands inside that are needed to recreate
the control file. The ALTER DATABASE BACKUP CONTROLFILE TO 'FILENAME' command
will create a backup control file that can be used later to recover the control file should
the database control file be lost.
8. A. The ALTER SYSTEM SWITCH LOGFILE command will cause a log file switch, and the
log file that was the current log file will then be archived.