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

Question

Options

• AA base recovery catalog should exist.
• BThe owner of VPC cannot own recovery catalog.
• CAt least one target database should be registered in the recovery catalog.
• DThe register database privilege should be granted to the virtual catalog owner.
• EThe recovery_catalog_owner role should be granted to the virtual catalog owner.

• A
  88% (30)
• C
  6% (2)
• E
  6% (2)

Explanation

Creating a VPC requires a base recovery catalog (A) because the VPC is logically layered on top of it - there's nothing to virtualize without a base. The VPC owner must be a different user from the base catalog owner (B) to enforce the separation of privilege that makes it "private." The REGISTER DATABASE privilege (D) must be explicitly granted to the VPC owner so they can register and manage databases within their private view.

Why C is wrong: Databases do not need to be pre-registered before creating a VPC - the VPC owner can register databases themselves afterward (that's what privilege D enables).

Why E is wrong: Granting RECOVERY_CATALOG_OWNER would give the VPC owner full access to the entire base catalog, which defeats the purpose of a private catalog - they receive only targeted privileges like REGISTER DATABASE instead.

Memory tip: Think "Base, Different, Permitted" - you need a base catalog, a different owner, and explicitly permitted privileges. The VPC concept is about controlled delegation, not full ownership transfer.

No community discussion yet for this question.