Catalog Maintenance   «Prev  Next»

Recovery Manager Catalog - Quiz

Each question is worth one point. Select the best answer for each question.
1. To start Recovery Manager, you need which privilege(s)?
Please select the best answer.
  A. SYSDBA
  B. SYSUSER
  C. SYSMAN
  D. SYSRCV

2. Assuming user SCOTT has the appropriate privileges, the command RMAN TARGET SCOTT/TIGER@PROD will do what?
Please select the best answer.
  A. Recovery Manager will access the database referenced by PROD to perform some action.
  B. Recovery Manager will fail with an error.
  C. Recovery Manager will connect to the database by PROD and check the recovery catalog for the current state of the database.
  D. Recovery Manager will open the recovery catalog referenced by PROD and prepare to perform some action.

3. Assuming users SCOTT and RMAN have the appropriate privileges and given the following syntax:

C: >set oracle_sid = MYDB
C: >RMAN RCVCAT RMAN/RMAN@RCVCAT
RMAN> CONNECT TARGET

Which of the following are true?
Please select the best answer.
  A. Recovery Manager will not use a recovery catalog.
  B. The CONNECT TARGET statement will fail with an error.
  C. A user is created to connect to the recovery catalog RCVCAT.
  D. Recovery Manager will connect to a local database named MYDB.

Correct answers:

Your Score: 0