Recovery File Structures   «Prev  Next»

Oracle Redo log - quiz

Each question is worth one point. Select the best answer or answers for each question.
1. What information does V$LOG provide about online redo logs?
Please select the best answer.
  A. Historical log records from the control file
  B. Individual member filenames and member status
  C. Group numbers, sequence numbers, sizes, and group status
  D. User session connection and login information

2. In a single-instance CDB, group 3 does not exist. The new filesystem paths are available and writable. Which statement creates group 3 with two 512M members?
Please select the best answer.
  A. ALTER DATABASE ADD LOGFILE GROUP 3 ('/u01/oradata/CDB1/g3_loga.ora') SIZE 512M;
  B. ALTER DATABASE MODIFY LOGFILE GROUP 3 ('/u01/oradata/CDB1/g3_loga.ora', '/u02/oradata/CDB1/g3_logb.ora') SIZE 512M;
  C. ALTER DATABASE ADD LOGFILE GROUP 3 ('/u01/oradata/CDB1/g3_loga.ora', '/u02/oradata/CDB1/g3_logb.ora') SIZE 512M;
  D. ALTER LOGFILE ADD GROUP 3 ('/u01/oradata/CDB1/g3_loga.ora', '/u02/oradata/CDB1/g3_logb.ora') SIZE 512M;

3. During planned maintenance, previously used group 3 is INACTIVE and its required archiving is complete. At least two valid groups will remain in its thread. Which SQL statement drops group 3?
Please select the best answer.
  A. ALTER LOGFILE DROP GROUP 3;
  B. ALTER DATABASE REMOVE LOGFILE GROUP 3;
  C. ALTER DATABASE DROP LOGFILE GROUP 3;
  D. ALTER DATABASE DROP GROUP 3;

4. A redo thread has three groups, each with two usable members. While group 1 is current, where is its new redo written?
Please select the best answer.
  A. To both members of group 1, with the same redo in each
  B. To one member of each of the three groups
  C. To all six members with the same redo
  D. To the two members of group 1, with different redo in each

5. In ARCHIVELOG mode, a noncurrent group has STATUS = ACTIVE and ARCHIVED = YES in V$LOG. What does this mean?
Please select the best answer.
  A. It is reusable immediately because archiving has completed.
  B. LGWR is currently writing new redo to this group.
  C. Its members contain different portions of archived redo.
  D. It has been archived but is still needed for instance recovery.