Recovery Catalog   «Prev  Next»

Oracle Scripts - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which are correct statements about stored scripts?
Please select all the correct answers.
  A. When you create a stored script, the syntax can be stored in the recovery catalog and on your file system.
  B. When you create a stored script it is compiled into PL/SQL steps, which are stored in the recovery catalog or file system.
  C. Stored scripts can be created with embedded operating system commands.
  D. Stored scripts must be executed using the run command.

2. You have been doing operating system backups for the past month and have decided to use Recovery Manager with a recovery catalog. Which of the following statements are true?
Please select the best answer.
  A. If you have your operating system backups stored in your ORACLE_HOME subdirectory, Recovery Manager will update the recovery catalog with these entries.
  B. You will need to use the catalog command to update the recovery catalog with your operating system backups.
  C. All backups that have occurred before the recovery catalog is created are worthless.

3. What is the name of the data dictionary view to get information about your stored scripts?
Please select the best answer.
  A. V$STORED_SCRIPT
  B. RC_STORED_SCRIPT
  C. STORED_SCRIPT
  D. STORED_SCRIPTS_LINE

4. Which command will update your recovery with information about a copy of a control file?
Please select the best answer.
  A. catalog controlfile 'C:\backup\ctl1orc1.ora'
  B. catalog update controlfile 'C:\backup\ctl1orc1.ora'
  C. catalog controlfilecopy 'C:\backup\ctl1orc1.ora'
  D. catalog controlfilelog 'C:\backup\ctl1orc1.ora'

5. You are using backup sets when you back up your database. If you need to recover the recovery catalog, which method will you use to restore the backup set to your recovery catalog?
Please select the best answer.
  A. Use the catalog command.
  B. Use the catalog command followed by a resync command to eliminate records for files that don't exist.
  C. Use the resync command.
  D. Use the import command.

6. Which statements are true about the list command?
Please select all the correct answers.
  A. The list command will report on your backup sets, file copies, and archived log files.
  B. When using the list command, you do not need to be connected to the target database.
  C. The list command will report on an incarnation of a data file.
  D. When using the list command, you need to be connected to your recovery catalog.