Backup Recovery   «Prev  Next»

log_archive_dest - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which statement correctly describes LOG_ARCHIVE_DEST_n in Oracle AI Database 26ai?
Please select the best answer.
  A. It supports an unlimited number of local archive destinations.
  B. It defines up to 31 numbered destinations using LOCATION for local destinations or SERVICE for remote destinations, subject to the restrictions for each destination number.
  C. It has been replaced by LOG_ARCHIVE_DUPLEX_DEST.
  D. It specifies the archived redo log filename format rather than a destination.

2. Which attribute specifies a local archive destination in LOG_ARCHIVE_DEST_1?
Please select the best answer.
  A. SERVICE
  B. DB_UNIQUE_NAME
  C. LOCATION
  D. VALID_FOR

3. Which Oracle Data Pump Export (expdp) parameter filters rows from a specified table using a SQL predicate?
Please select the best answer.
  A. CONTENT
  B. TABLES
  C. QUERY
  D. EXCLUDE

4. Which parameters of DBMS_LOGMNR.START_LOGMNR specify a mining time range when SCN boundaries are not supplied?
Please select the best answer.
  A. STARTSCN and ENDSCN
  B. OPTIONS alone
  C. DICTFILENAME alone
  D. STARTTIME and ENDTIME

5. Which DBMS_REPAIR procedure checks a table or index and reports block corruption in a repair table?
Please select the best answer.
  A. ADMIN_TABLES
  B. FIX_CORRUPT_BLOCKS
  C. CHECK_OBJECT
  D. SKIP_CORRUPT_BLOCKS