Þ D. TO CREATE THE VIRTUAL CATALOG, YOU CONNECT TO THE BASE CATALOG...

5. þ D. To create the virtual catalog, you connect to the base catalog, create

P AR T III

the virtual catalog, connect to the target database, register the database,

and finally back it up. You need to create the virtual catalog only once, and

each target database needs to be registered only once. Subsequent backup

operations can occur after connecting to the base catalog and the target

database.

ý A, B, and C. A is wrong because the base catalog and virtual catalog are

on the instance with the service name CATDB2, not the target database DW.

B is wrong because EXEC CATOWNER.DBMS_RCVCAT.CREATE_VIRTUAL_

CATALOG is only for pre-11g clients and must be run by the virtual catalog

owner at a SQL> prompt. C is wrong because GRANT CATALOG FOR

DATABASE DW TO VPC1 must be run by the base catalog owner and only if

the database is already registered in the base catalog.