Oracle Database 12c: Advanced Administration — Question 173

Which three conditions must be met before you Virtual Private Catalog (VPC) can be created and used by an Administrator?

Answer options

• A. A base recovery catalog must exist.
• B. The owner of the 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 DBA role must be granted to the virtual catalog owner.

Correct answer: A, D, E

Explanation

The correct prerequisites for creating a VPC are that a base recovery catalog must exist (A), the virtual catalog owner should have the REGISTER DATABASE privilege (D), and the DBA role must be assigned to the virtual catalog owner (E). Option B is incorrect because it is acceptable for the VPC owner to own the recovery catalog, and option C is not a requirement for the creation of a VPC.