1Z0-034 · Question #144
You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1,PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery…
The correct answer is A. They execute and create a virtual catalog for pre-Oracle 11g clients. See the full explanation below for the reasoning.
Question
You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1,PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The databaseuser who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grantprivileges to a new user VPC1 using Oracle Database 11g 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?
Options
- AThey execute and create a virtual catalog for pre-Oracle 11g clients.
- BThey produce an error because PROD1 and PROD2 databases belong to the older version.
- CThey produce an error because you need to connect as CATOWNER to execute this packaged
- DThey produce an error because you need to connect to the target database to execute this
How the community answered
(38 responses)- A82% (31)
- B5% (2)
- C11% (4)
- D3% (1)
Community Discussion
No community discussion yet for this question.