Exam 1z0-083 topic 1 question 132 discussion

A, B, C Tested in Lab A - True B - True C - True D - False. Not MUST. this can be done from the VPC to. E - False. Not MUST. F - False. shouldn't be in both. only in base

They use Must too much. ABC

A, B, C. NOT E: can not must https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/managing-recovery-catalog.html#GUID-B3238BE0-F52D-4773-A277-D3627AE28D57

ACE Not B (enable base catalog) RMAN uses the Virtual Private Database (VPD) functionality to implement virtual private catalogs. The VPD functionality is not enabled by default when the RMAN base recovery catalog is created. You need to explicitly enable the VPD model for a base recovery catalog by running the $ORACLE_HOME/rdbms/admin/dbmsrmanvpc.sql script after upgrading the base catalog schema. E is okay - 13.5.4 Registering a Database with a Virtual Private Catalog To store backup metadata for a target database in a virtual private catalog, you must register the database with the virtual private catalog. https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/managing-recovery-catalog.html#GUID-DA362C55-5B94-4AB8-A8A1-163BF08FE594

A, C and E https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/managing-recovery-catalog.html#GUID-B3238BE0-F52D-4773-A277-D3627AE28D57 NOT B: The Virtual Private Database must be enabled to use VPC. The base catalog is created with the RMAN CREATE CATALOG command. NOT D: Is a "can" not "must" NOT F: The VPC owner connects to the base catalog and the target database and issue the command REGISTER DATABASE

A. TRUE - Base catalog Owner must give access to metadata through "GRANT CATALOG FOR DATABASE" command to the VPC owner. "After you set up a virtual private catalog user, the administrator for the recovery catalog grants each virtual private catalog the privilege to use that catalog for one or more databases that are currently registered in the recovery catalog." The catalog owner receive access to the metadata for the PDBs which they manage. B. TRUE - By definition of a Virtual Private Catalog "A subset of the metadata in a base recovery catalog to which a database user is granted access. The owner of a base recovery catalog can grant or revoke restricted access to the recovery catalog to other database users. Each restricted user has full read/write access to his own virtual private catalog." C. TRUE - If a target database is not registered in the recovery catalog, then RMAN cannot use the catalog to store metadata for operations on this database. You can still perform RMAN operations on an unregistered database: RMAN always stores its metadata in the control file of the target database.

A is true: "You can also use a DBID rather than a database name. The virtual private catalog user does not have access to the metadata for any other databases registered in the recovery catalog." B is false: "Enable the VPD model for the recovery catalog by running" C is true: "Assume that the following databases are registered in the base recovery catalog: prod1, prod2, and prod3." D is false: RMAN uses control file. E is true: "To store backup metadata for a target database in a virtual private catalog, you must register the database with the virtual private catalog." F is false: Must be registered in both, I think it can be registered just in base catalog too.

I think the answer should be B, C, D since "A virtual private catalog is a set of security policies that restrict user access to a subset of a base recovery catalog." therefore a target PDB "MUST BE" registered in the base catalog, but it's optional to register a target PDB in Virtual private catalog to achieve separation of duties among dbas. https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/CREATE-CATALOG.html#GUID-9CFE47C7-2273-48C4-8056-6A4042AF3CDC

C is right E is wrong After you set up a virtual private catalog user, the administrator for the recovery catalog grants each virtual private catalog the privilege to use that catalog for one or more databases that are currently registered in the recovery catalog. The administrator of the recovery catalog can also grant the privilege to register new databases while using a virtual private catalog.

I think it's ADE.

Looks like its A D E

You have to register the PDB in a Virtual Private Catalog if you are going to use it. It uses is not mandatory. I think B C D

ADE correct https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/managing-recovery-catalog.html#GUID-A7502D0D-5840-4B13-869D-7259F2D73119 A base recovery catalog is a database schema that contains RMAN metadata for a set of target databases. A virtual private catalog is a set of security policies that restrict user access to a subset of a base recovery catalog.