Which statement is true regarding virtual private catalogs?
A.
A virtual private catalog owner can create a local stored script, and have read/write
access to a global stored script.
B.
The virtual private catalog owner cannot create and modify the stored scripts.
C.
The set of views and synonyms that make up the virtual private catalog is stored in the
schema of the RMAN recovery catalog owner.
D.
To perform most of the RMAN operations, the virtual catalog owner must have the
SYSDBA or SYSOPER privilege on the target database.
D is not correct.
Normally you connect to the target and catalog using one of these formats
RMAN target=/ catalog=rcat_own/rcat_own@RCAT
RMAN target=sys/robert@orcl catalog=rcat_own/rcat_own@RCAT
Note that the catalogs owner rcat_own does not need SYSDBA or SYSOPER privileges on the target because we provide this access to him in these connections above.
The correct answer is C:
From the doc: https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmcatdb.htm#CHDHIFHB
A virtual private catalog is a set of synonyms and views that refer to a base recovery catalog.
From the same link:
Note that a virtual private catalog owner can create a local stored script, but only has read-only access to a global stored script. The set of views and synonyms that makes up the virtual private catalog is stored in the schema of the virtual private catalog owner.
yes
A virtual private catalog is a set of synonyms and views that refer to a base recovery catalog.
but this is not what C says.
C says that they are stored in the base RC owners schema.
I would say that none of these answers are correct.
D is correct. A virtual catalog owner needs SYSDBA-privileges on his target database.