The alter system checkpoint forces manual checkpoints

318 Chapter 7 ✦ Study Guide

8. The three dynamic performance views that include information about logfiles are V$THREAD, indicating which logfile group is currently being written to, V$LOG, which shows which groups exist in the database and when and what was last written to them, and V$LOGFILE, which shows the status of and other information about each member in each group.

9. To determine whether the database is in ARCHIVELOG mode, query the V$INSTANCE view for the value of the ARCHIVER column — STARTED means that the archiver process is started. You can also query the V$DATABASE view and verify the value of the ARCHIVE_MODE column, which will read ARCHIVELOG if the mode is set, otherwise NOARCHIVELOG. You can also issue the command “ARCHIVE LOG LIST” in SQL*Plus or Server Manage line mode.

3. A. The minimum number of redo log files per group is one. You should, how-ever, have at least two members per group to protect against failures. For more information, refer to the section on “Planning Redo Log Files” section.

7. A. Oracle does not guarantee that redo log information will be written after DML statements. For more information, refer to section “Using Online Redo Log Files”

8. D. Checkpoints do not happen at commits. For more information, refer to sec- tion “Using Online Redo Log Files.”

13. A. The ALTER SYSTEM CHECKPOINT forces manual checkpoints. More infor-mation about checkpoints can be found in the “Using Online Redo Log Files.”

14. B. The ALTER SYSTEM SWITCH LOGFILE forces manual log switches. The“Using Online Redo Log Files” section has more information about log switches.