Managing Redo log   «Prev  Next»

Listing Redo LogFiles Quiz - Results

Each question is worth one point. Select the best answer or answers for each question.
1. Which configuration best protects an online redo log group if one member or its storage device fails?
Please select the best answer.
  A. Back up each online redo log member to tape on a frequent schedule.
  B. Multiplex the group with members stored on separate failure domains.
  C. Create additional groups, but keep only one member in each group.
  D. Enable ARCHIVELOG mode and rely on archived redo logs instead of multiplexing.

2. Which two recovery functions depend on redo generated by the database?
Please select all the correct answers.
  A. Automatic instance recovery after an instance failure.
  B. Distributing datafile read I/O across multiple disks.
  C. Eliminating the need for LGWR to complete a commit.
  D. Rolling restored datafiles forward during media recovery.

3. What is the best way to display a list of redo log files for your database?
Please select the best answer.
  A. Read the binary control file directly at the operating-system prompt.
  B. Issue SHOW LOGFILES in SQL*Plus.
  C. Query V$LOGFILE and select the MEMBER column.
  D. Query a DBA_LOGFILE data dictionary view.