Multiple choice technology databases

What is the benefit of “Virtual Private Catalog” feature in Oracle 11g?

  1. Create one catalog database per Database Administrator to share the maintenance workload

  2. Restrict SYSDBA and SYSOPER access from Database Administrators and yet allow them to perform database backup and recovery related tasks i.e. Virtualization of the SYSDBA and SYSOPER access

  3. Maintain only one database for the RMAN repository catalog yet establish secure boundaries for individual database owners to manage their own virtual repositories

  4. Make Oracle 11g database compliant with global Backup and Recovery standards
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The Virtual Private Catalog feature allows a single RMAN catalog database to serve multiple database owners while maintaining security boundaries. Each administrator gets a virtual view of only their databases (option C is correct). This avoids the overhead of separate catalog databases. Options A, B, and D are incorrect because VPC doesn't create separate catalogs, restrict SYSDBA access, or relate to compliance standards.

Keep practicing — related questions