Which three conditions must be met before you create a Virtual Private Catalog (VPC)?
A.
A base recovery catalog should exist.
B.
The owner of 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 recovery_catalog_owner role should be granted to the virtual catalog owner.
Explanation:
Reference:
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta013.htm
A,D,E
Why ADE?
because of this : http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta013.htm
I checked also 😉
Thanks Vonpire!
Thanks Vonphire again!
A.
A base recovery catalog should exist.
D.
The register database privilege should be granted to the virtual catalog owner.
E.
The recovery_catalog_owner role should be granted to the virtual catalog owner.
ADE
Why is this correct ?
D.
The register database privilege should be granted to the virtual catalog owner
The question is about Pre-requisites for creating the Virtual Private Catalog (VPC)
If the condition is it also have to register database then the D will apply..
Apologize if this looks silly am still learning to appear for the exam
I agree with you, grant the REGISTER DATABASE privilege is not a pre-requistes to create the VPC.
May be the base catalog ownet doesn’t want that the VPC owner to register any database, but only to see Information about some databases, see he grants him only the GRANT CATALOG FOR DATABASE prod TO vpc;
to correct answer should be: A B E
A, C, E
Not B, because the BaseRecoveryCatalog owner has already control over all DBs.
You cannot create the two catalogs for the same DB and the same user.
Not D, because the BaseRC owner can do this. The VPC owner doesn’t need this privileg.
ABE
A
not sure, but as Vonpire tested it – i believe 🙂
B
Each virtual private catalog is owned by a database schema user which is different than the user who owns the recovery catalog.
E
Grant the RECOVERY_CATALOG_OWNER role to the schema owner. This role provides the user with all privileges required to maintain and query the recovery catalog.
D incorrect-you >>can<< grant this ,so this is not required
ADE