RelationalDBDesign RelationalDBDesign


Manual | Automatic Archiving   «Prev  Next»
 

Manually Archiving - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. When using server manager, which command(s) can be used to manually archive all the online redo log file groups?
Please select all the correct answers.
  A. alter system archive log all;
  B. alter system archive log current;
  C. alter system archive log group;
  D. archive log group;

2. When using server manager, which command will enable ARCH to automatically archive the redo log files?
Please select the best answer.
  A. alter system archive log start to ‘e:\oracle8\archive’;
  B. alter archive log start to ‘e:\oracle8\archive’;
  C. alter system start archive log to ‘e:\oracle8\archive’;
  D. alter system start archive log to ‘e:\oracle8\archive’;

3. What is the proper setting of the init.ora parameter to start automatic archiving of redo logs at instance startup?
Please select the best answer.
  A. LOG_ARCHIVE=TRUE
  B. LOG_ARCHIVE_START=TRUE
  C. ARCHIVE_LOG_START=TRUE
  D. ARCHIVE_LOG=START

4. Your init.ora parameter to enable automatic archive of redo logs at instance startup is set to TRUE. While the database is running you issue the following command in server manager; alter system archive log stop. You then bring your database down and back up. What will be the state of your archiving?
Please select the best answer.
  A. The init.ora parameter is FALSE, archiving is enabled and set for manual archiving.
  B. The init.ora parameter is TRUE, archiving is enabled and set for automatic archiving.
  C. The init.ora parameter is TRUE, archiving is disabled.
  D. The init.ora parameter is set to FALSE and archiving is disabled.