Managing Redo log   «Prev  Next»

Manually Switching Log Files - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. What is a log switch in Oracle Database?
Please select the best answer.
  A. A checkpoint that writes every dirty buffer to its data file.
  B. The point when LGWR stops writing to the current redo log group and begins writing to the next available group.
  C. A copy of the current online redo log created without changing the current group.
  D. A change from one member to another member within the same multiplexed group.

2. Which two are valid reasons to force a log switch?
Please select all the correct answers.
  A. You need the current group to progress toward an inactive state before performing maintenance such as dropping the group or one of its members.
  B. You want to guarantee that a database checkpoint completes immediately.
  C. You want a partially filled current group to be archived sooner when the database is in ARCHIVELOG mode.
  D. You want to prevent Oracle from switching automatically when the current group becomes full.

3. Which SQL statement explicitly forces the current Oracle instance to perform a log switch?
Please select the best answer.
  A. ALTER DATABASE SWITCH LOGFILE;
  B. ALTER SYSTEM SWITCH LOGFILE;
  C. ALTER SYSTEM SWITCH REDO;
  D. ALTER DATABASE SWITCH LOGFILE GROUP;