RelationalDBDesign RelationalDBDesign


Backup Recovery   «Prev  Next»

Recovery Manager Enhancements - Quiz

Select the best answer or answers for each question.
 

1. What is the utility of a control file within a database environment?
Please select all the correct answers.
  A. The control file is simply another copy of the initialization parameter file. Hence, it is not very important for a database.
  B. The control file has information about the database. It is maintained by the DBA and not used by the database, hence it is not useful to the database.
  C. The control file has critical information about the database, including the name of the database, tablespaces within it, the redo log file and datafiles within it, and the character set. This is a very critical file for a database.
  D. The Oracle database does not have a control file, hence it is not useful to the database.

2. How important is the character set within a control file?
Please select all the correct answers.
  A. The character set information is not very critical, because it is passed to the database during its creation and is maintained within the database.
  B. The control file does not have any character set information within it, because the file is maintained within the database.
  C. The character set information maintained within the control file is redundant, because this information is maintained within the initialization parameter file.
  D. The database character set information is stored within the control file. This allows access to the database character set before a database is opened. This is necessary for the Recovery Manager to correctly interpret the tablespace names prior to opening the database.

3. RMAN allows the user to complete the following process:
Please select all the correct answers.
  A. Import a database, but not export a database
  B. Export a database, but not import a database
  C. Import and export a database
  D. Generate the control file

4. How does the incremental backup within RMAN differ from the incremental backup within export utility?
Please select all the correct answers.
  A. The incremental backup within RMAN and export utility are conducted in exactly the same way.
  B. The export utility performs an incremental backup based on the tables within a schema. Within RMAN, the incremental backup is based on the changed data block within a tablespace, which is faster.
  C. The export utility for Oracle8i does not support incremental backups.
  D. RMAN for Oracle8i does not support incremental backups.

5. Where does the recovery catalog obtain the details about the target database?
Please select all the correct answers.
  A. From the control file
  B. From the target database
  C. From the initialization parameter file
  D. Scanning the file system that has the target database

6. What is the best solution for the location of the recovery catalog?
Please select all the correct answers.
  A. The recovery catalog is within the target database, because all the information is in a single place and the backup and recovery will be faster and safer.
  B. It is preferable to have the recovery catalog within another database. This is because if the target database is corrupted or it fails, the recovery by using RMAN and its recovery catalog is extremely difficult.
  C. The target database is the best place to keep the recovery catalog, because when doing a complete backup of the target database, the recovery catalog will also be backed up.
  D. The location of the recovery catalog is not important.