The following databases are registered in the base recovery catalog: PROD1, PROD2, and
PROD3.The database user CATOWNER owns the base recovery catalog. You want a new
user VPC1 to have access to only the PROD1 database and create a virtual private catalog.
The RVPC user can do which of the following? (Choose all that apply.)
A.
Register databases if granted the register database privilege
B.
See all databases in the recovery-catalog schema
C.
See all database-related metadata in the recovery catalog if they are granted access to
that database
D.
Unregister databases from the RVPC catalog that were not granted to the RVPC catalog
owner with the grant command
E.
Not be connected to with the RMAN command-line catalog parameter for backup or
recovery purposes
According to the book …
http://www.amazon.com/Oracle-Database-All-Guide-CD-ROM/dp/0071629181
that contains this question the answer is …
A, C. The RVPC user can register database if they are granted the register database privilege. They can also see all recovery-catalog database metadata to which they are granted access.
Just for the record, this is not my (Eamon) opinion.
This question is ambiguous so I will not give an opinion on the correct answer. However see this doc for this topic
https://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmcatdb.htm#BRADV89658