Recovery Manager Catalog - Quiz Explanation

The answers you selected are indicated below, along with text that explains the correct answers.
1. To start Recovery Manager, you need which privilege(s)?
Please select the best answer.
  A. SYSDBA
  B. SYSUSER
  C. SYSMAN
  D. SYSRCV
 

The correct answer is A.


You nee the SYSDBA privilege to start Recovery Manager. B is incorrect because the SYSUSER is not sufficient. C and D are incorrect because the SYSMAN and SYSRCV are not privileges.

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.
 

The correct answer is A.


The command specifies the keyword target and supplies a syntactically correct connect string. This should not fail, so answer B is incorrect. C is incorrect because the command does not specify anything about recovery catalogs. D is incorrect because the target keyword relates to a target database and not to the recovery catalog.

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.
 

The correct answer is D.


This should connect to MYDB and the recovery catalog specified by @RCVCAT. A is incorrect because the RCVCAT keyword specified the use of a recovery catalog. Answer B is incorrect because, based on the assumption, this should not fail. C is incorrect because a server process, not a user process, is created.