Oracle Database 12c: Advanced Administration — Question 74

Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

Answer options

• A. A base recovery catalog should exist.
• B. The owner of VPC cannot own recovery catalog.
• C. At least one target database should be registered in the recovery catalog.
• D. The register database privilege should be granted to the virtual catalog owner.
• E. The recovery_catalog_owner role should be granted to the virtual catalog owner.

Correct answer: C, D, E

Explanation

To create a Virtual Private Catalog (VPC), it is essential to have at least one target database registered in the recovery catalog, grant the register database privilege, and assign the recovery_catalog_owner role to the virtual catalog owner. Options A and B are not necessary conditions for VPC creation, making them incorrect.