Backup Recovery   «Prev  Next»

log_archive_dest - Quiz

Other improvements for backup & recovery

Each question is worth one point. Select the best answer or answers for each question.
 
1. What is the difference between LOG_ARCHIVE_DEST_n and LOG_ARCHIVE_DUPLEX_DEST?
Please select all the correct answers.
  A. The first is used to set an indefinite number of locations for saving copies of archived redo log files. The second parameter is used for making two copies of the archived redo log files.
  B. LOG_ARCHIVE_DUPLEX_DEST defines the second path for maintaining another copy of the archived redo log file.
This parameter is deprecated within Oracle8i and LOG_ARCHIVE_DEST_n is introduced, which allows you to specify 5 destinations for maintaining copies of the archived redo log files.
  C. Both parameters are not available within Oracle8i, because they are deprecated.
  D. Both parameters define the different format of maintaining the archived redo log files.

2. LOG_ARCHIVE_DEST_n, the parameter for specifying multiple locations for archived redo log files, is deprecated within Oracle8i, because:
Please select all the correct answers.
  A. It is no longer efficient to have more than one copy of the archive log files.
  B. LOG_ARCHIVE_DEST, a feature found within older versions of Oracle is the only parameter for specifying the destination of archive log files.
  C. It is replaced with the LOG_ARCHIVE_DUPLEX_DEST parameter.
  D. It only specifies the format of archive log files and not its destinations.

3. How do you select a particular set of records when performing a table based export?
Please select all the correct answers.
  A. You define a view and export data from the view.
  B. Oracle8i does not support this feature.
  C. You define the WHERE clause within the QUERY parameter when performing the export.
  D. By using the Materialized Views feature within Oracle8i, you can create and export a materialized view based on selection criteria

4. Which of the following parameters should be used when you want a LogMiner report for a date range?
Please select all the correct answers.
  A. StartSCN because this parameter specifies the SCN for a particular date range
  B. Options because this parameter provides the option of selecting archive log files for a particular date range
  C. DictFileName because this parameter provides the data dictionary that has the details of the log files for a particular date range
  D. The combination of StartTime and EndTime to select log files for a particular date range

5. Which procedure is available within DBMS_REPAIR to detect corrupt blocks?
Please select all the correct answers.
  A. DBMS_REPAIR is currently not available within Oracle8i because it is within beta test.
  B. FIX_CORRUPT_BLOCKS has the ability to check and fix corrupted data blocks.
  C. CHECK_OBJECT detects and reports corrupt blocks.
  D. CHECK_CORRUPT_BLOCKS checks for corrupt blocks.