RelationalDBDesign RelationalDBDesign


Incomplete Recovery   «Prev 

Concepts about Incomplete Recovery - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 

1. Which of the following describe characteristics of incomplete recovery?
Please select all the correct answers.
  A. Data is lost on all files in the database.
  B. Online redo logs must be reset when the database is open.
  C. The database may be recovered to a point in time, a specific System Change Number, or until CANCEL.
  D. Data may be inconsistent--some constraints may be disabled.

2. When a database is in ARCHIVELOG mode, which of the following are true?
Please select all the correct answers.
  A. You can restore a single datafile up to date while the database is running.
  B. You can restore the entire database to point-in-time, system change number (SCN), or until CANCEL.
  C. Your redo logs will always be archived automatically.
  D. You can perform on-line hot backups.

3. After a successful incomplete recovery, which of the following statements is true?
Please select the best answer.
  A. Not all datafiles in the system will be present.
  B. Online redo logs will have sequence numbers 0 and 1.
  C. You can put the database in recovery mode again and continue to apply more archive logs.
  D. You must recreate your control file.

4. The system tablespace is contained in one datafile. The datafile becomes corrupt. The database is in ARCHIVELOG mode. A valid online backup of the entire database, including the system tablespace datafile, was completed last night. Which is the most appropriate action to recover to the time of corruption?
Please select the best answer.
  A. Restore datafiles from backup and apply all archive logs
  B. Use ALTER DATABASE ARCHIVELOG
  C. Restore the entire database from last night's complete backup
  D. Perform point-in-time recovery

5. Which of the following do you need to have to perform a recovery through RESETLOGS?
Please select all the correct answers.
  A. The alert log contains information from the last incomplete recovery.
  B. The database version must be 7.3.3. or higher.
  C. There is a whole closed database backup after the database was opened with the RESETLOGS option.
  D. There is a whole open database backup before the database was opened with the RESETLOGS option.
  E. There are backups of the control file before and after the database was opened with the RESETLOGS option.
  F. There are online redo logs and archived logs with only one missing.

6. Before you start to perform the tablespace point-in-time recovery, which of the following must you have?
Please select all the correct answers.
  A. A database cloned from the current database
  B. Enough disk space and memory on your machine
  C. A backup of all the database files
  D. A backup of the current control file