1. What state does the database need to be in to enable archiving?
A. Opened
B. Closed
C. Mounted
D. Unmounted
Answer: C
The database must be in MOUNT mode to enable archive logging.
Chapter: 7
2. What are some of the issues the DBA should be aware of when the database is running in ARCHIVELOG mode?
A. Whether they have the ability to perform a complete recovery
B. Whether they have to shut down the database to perform backups
C. Whether they have the ability to perform an incomplete recovery
D. Whether this mode will cause increased disk space utilization
Answer: D
The database will use more space because of the creation of archived logs.
Chapter: 7
3. Which of the choices below are ways in which you can change the destination of archived log files? (Choose all that apply.)
A. Change the LOG_ARCHIVE_DEST_n init.ora parameter.
B. Configure the control file.
C. Change the LOG_ARCHIVE_DEST init.ora parameter.
D. Change the LOG_ARCHIVE_DUMP init.ora parameter.
Answer: A, C
The archive destination is controlled by the LOG_ARCHIVE_DEST init.ora parameter and by issuing ALTER SYSTEM commands when the database is running.
Chapter: 7
4. What is the maximum number of archived log destinations that is supported?
A. 1
B. 2
C. 5
D. 10
Answer: D
The maximum number of archive destinations is controlled by the LOG_ARCHIVE_DEST_N init.ora parameter. It will support up to 10 locations.
Chapter: 7
5. What type of database backup requires a shutdown of the database? (Choose all that apply.)
A. A database in ARCHIVELOG
B. A database in NOARCHIVELOG
C. Hot backup (online backup)
D. Cold backup (offline backup)
Answer: B, D
A database in NOARCHIVELOG mode will not support backups without a shutdown of the database, and a cold backup is a backup taken when the database is offline or shut down.
Chapter: 7
6. List all the methods of determining that the database is in ARCHIVELOG mode. (Choose all that apply.)
A. Query the V$DATABASE view.
B. See whether the ARCn process is running.
C. Check the value of the LOG_ARCHIVE_DEST parameter.
D. View the results of the ARCHIVE LOG LIST command.
Answer: A, B, D
The V$DATABASE view shows whether the database is in ARCHIVELOG or NOARCHIVELOG mode, the ARCn process indirectly determines that the archiver is running, and the ARCHIVE LOG LIST command shows whether archiving is enabled. Checking the value of the LOG_ARCHIVE_DEST parameter indicates only whether there is a directory to contain the archived logs, not whether the database is in ARCHIVELOG mode.
Chapter: 7
7. You are the DBA for a manufacturing company that runs three shifts a day and performs work 24 hours a day on the database, taking orders, performing inventory adjustments, and shipping products. Which type of backup should you perform? (Choose all that apply.)
A. Hot backup in ARCHIVELOG mode
B. Cold backup in ARCHIVELOG mode
C. Online backup in NOARCHIVELOG mode
D. Online backup in ARCHIVELOG mode
Answer: A, D
A hot backup and online backup are synonymous. A cold backup and offline backup are synonymous. A hot backup can be run only in ARCHIVELOG mode (so the backup method in answer C doesn't exist). A hot backup can be run while the database is running; therefore, it does not affect the availability of the database. Because this database must have 24-hour availability, a hot or online backup would be appropriate.
Chapter: 7
8. What init.ora parameter allows no more than two archive log destinations?
A. ARCHIVE_LOG_DEST_N
B. ARCHIVE_LOG_DEST_DUPLEX
C. LOG_ARCHIVE_DEST_DUPLEX
D. LOG_ARCHIVE_DUPLEX_DEST
Answer: D
The LOG_ARCHIVE_DUPLEX_DEST parameter allows for the second archive destination. Also, this parameter must be used in conjunction with the LOG_ARCHIVE_DEST parameter for the first archive log destination.
Chapter: 7
9. What init.ora parameter allows no more than 10 archive log destinations?
A. ARCHIVE_LOG_DEST_N
B. ARCHIVE_LOG_DEST_DUPLEX
C. LOG_ARCHIVE_DEST_DUPLEX
D. LOG_ARCHIVE_DUPLEX_DEST
E. LOG_ARCHIVE_DEST_N
Answer: E
The LOG_ARCHIVE_DEST_N allows up to 10 locations.
Chapter: 7
10. What init.ora parameter allows remote archive log destinations?
A. ARCHIVE_LOG_DEST
B. ARCHIVE_LOG_DEST_DUPLEX
C. LOG_ARCHIVE_DEST_N
D. LOG_ARCHIVE_DUPLEX_DEST
Answer: C
LOG_ARCHIVE_DEST_N allows up to 10 locations. One of these locations can be remote, that is, not on the same server.
Chapter: 7
11. What command is necessary to perform manual archiving?
A. MANUAL ARCHIVE ALL
B. ARCHIVE MANUAL
C. LOG ARCHIVE LIST
D. ARCHIVE LOG ALL
Answer: D
The ARCHIVE LOG ALL command is responsible for manually generating archived logs. The ARCHIVE LOG NEXT command will also archive logs manually, but it will only archive the next archived log in the sequence as opposed to all of the archived logs. The database must also be in ARCHIVELOG mode.
Chapter: 7
12. What is required to manually archive the database?
A. The database running in ARCHIVELOG mode.
B. LOG_ARCHIVE_START is set to TRUE.
C. MANUAL_ARCHIVE is set to TRUE.
D. Nothing.
Answer: A
The database running in ARCHIVELOG mode is a requirement for performing manual or automatic archiving. This means that the database must be restarted with STARTUP MOUNT and then the command ALTER DATABASE ARCHIVELOG must be executed. Then the database should be opened for normal use.
Chapter: 7
13. What command is necessary to perform manual archiving?
A. ARCHIVE LOG NEXT
B. ARCHIVE LOG LIST
C. ARCHIVE ALL LOG
D. ARCHIVE ALL
Answer: A
The ARCHIVE LOG NEXT command will archive the next group of redo logs.
Chapter: 7
14. What will happen to the database if ARCHIVELOG mode is enabled, but the LOG_ARCHIVE_START command is not set to TRUE? (Choose all that apply.)
A. The database will perform with problems.
B. The database will hang until the archived logs are manually archived.
C. The database will not start because of improper configuration.
D. The database will work properly until all online redo logs have been filled.
Answer: B, D
The database will hang after all the online redo logs have been filled, but it will work properly as long as there are unfilled online redo logs.
Chapter: 7
15. Which of the following is true about NOARCHIVELOG mode?
A. The database must be shut down completely for backups.
B. Tablespaces must be taken offline before backups.
C. The database must be running for backups.
D. The database may be running for backups, but it isn't required.
Answer: A
The database must be shut down completely for backups. If the database is open and a backup is taken, the backup will be invalid.
Chapter: 7
16. Which initialization parameter determines how many of the archived log destinations must be successfully written to before the online redo logs may be written over?
A. ARCHIVE_MINIMUM_SUCCEED
B. LOG_ARCHIVE_MINIMUM_SUCCEED
C. LOG_ARCHIVE_MIN_SUCCEED_DEST
D. ARCHIVE_MIN_SUCCEED_DEST
Answer: C
The LOG_ARCHIVE_MIN_SUCCEED_DEST parameter determines how many of the log archive destinations must be successfully written to before the online redo logs can be overwritten.
Chapter: 7
17. What parameter will allow the database to keep on processing if an archived log does not arrive at a log archive destination?
A. REOPEN
B. MANDATORY
C. OPTIONAL
D. UNSUCCESSFUL
Answer: C
The OPTIONAL parameter will allow the database to continue processing even when the online redo logs have been filled and the archived log still has not arrived at the log archive destination.
Chapter: 7
18. What parameter will cause failed archived log transfers to retry after a determined period of time?
A. MANDATORY
B. OPTIONAL
C. REOPEN
D. RETRY
Answer: C
The REOPEN parameter will cause failed archived log transfers to retry after a determined period of time.
Chapter: 7
19. How can you identify whether the database is in ARCHIVELOG mode or not? (Choose all that apply.)
A. You can use the ARCHIVE LOG LIST command.
B. You can select * from V$DATABASE.
C. You can use the ARCHIVELOG LIST command.
D. You can select * from V$LOG.
Answer: A, B
The ARCHIVE LOG LIST command can be executed from within SQL*Plus and will display whether or not the database is in ARCHIVELOG mode. Selecting from V$DATABASE will also show this information.
Chapter: 7
20. Complete recovery can be performed when what is true about the database?
A. It is in ARCHIVELOG mode.
B. It is in NOARCHIVELOG mode.
C. Manual archive logging is enabled.
D. Automatic archive logging is enabled.
Answer: A
When the database is in ARCHIVELOG mode, complete recovery can be performed. What mode to use is one of the most significant decisions you can make about backup and recovery of your database.
Chapter: 7
