What is the outcome of the above commands?

You are in the process of creating a virtual private catalog in your Oracle Database 11 g database.
The PROD1 „ PROD and PROD3 Oracle Database 10g databases are registered in the base
recovery catalog. The database user who own the base recovery catalog is CATOWNER.
CATOWNER executes the following command to grant privileges to a new user VPC1 using
Oracle Database 11 g RMAN executables:
RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1;
Then you issue the following commands:
RMAN> CONNECT CATALOG vpc1/oracle@catdb;
RMAN> SQL “EXEC catowner.dbms_rcvcat.create_virtual_catalog;”
What is the outcome of the above commands?

You are in the process of creating a virtual private catalog in your Oracle Database 11 g database.
The PROD1 „ PROD and PROD3 Oracle Database 10g databases are registered in the base
recovery catalog. The database user who own the base recovery catalog is CATOWNER.
CATOWNER executes the following command to grant privileges to a new user VPC1 using
Oracle Database 11 g RMAN executables:
RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1;
Then you issue the following commands:
RMAN> CONNECT CATALOG vpc1/oracle@catdb;
RMAN> SQL “EXEC catowner.dbms_rcvcat.create_virtual_catalog;”
What is the outcome of the above commands?

A.
They execute and create a virtual catalog for pre-Oracle 11 g clients.

B.
They produce an error because PROD1 and PROD2 databases belong to the older version.

C.
They produce an error because you need to connect as CATOWNER to execute this packaged
procedure.

D.
They produce an error because you need to connect to the target database to execute this
packaged procedure.



Leave a Reply 0

Your email address will not be published. Required fields are marked *