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.
Bạn đang xem 5. - OCA OCP ORACLE DATABASE 11G A LL IN ONE EXAM GUIDE P72 POTX