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

5. Which files do you need to back up for a database that is in ARCHIVELOG mode to
ensure recovery? (Choose all that apply.)
A. Database data files
B. Online redo logs
C. Archived redo logs
D. Backup control file
E. Control file from a backup
6. What does the SCN represent?
A. The system change number, which is a marker indicating a point in time relative to
transactions within a given database.
B. A number that represents time. Thus, at 1300 hours, the SCN is the same on all
databases.
C. The security change number, which represents the security code that is needed to
access any database structure.
D. A conversion factor that converts internal database time to external clock time.
E. UTC time in the database, providing a standardized way of tracking time in Oracle.
7. Which command(s) are used to back up the control file? (Choose all that apply.)
A. ALTER SYSTEM BACKUP CONTROLFILE
B. ALTER DATABASE BACKUP CONTROLFILE TO TRACE
C. ALTER DATABASE BACKUP CONTROL FILE
D. ALTER DATABASE BACKUP CONTROLFILE TO 'FILENAME'
E. ALTER CONTROLFILE BACKUP
8. What is the purpose of MAA?
A. MAA is a set of practices that Oracle has created to help you better administer
your databases.
B. MAA is a set of practices that standardizes Oracle database creation, file naming
conventions and operating system directory names.
C. MAA is a set of practices that align around providing maximum availability for
Oracle databases.
D. MAA is a new form of Oracle martial arts.
E. MAA is an online document available from oracle.com that provides a list of cur-
rent critical issues related to database backup and recovery.