Prev Question

Which two statements are true for Data Guard environments with multi-tenant databases?

A.
DB_UNIQUE_NAME must be specified differently for each pluggable database within a multi-tenant
standby database.

B.
Each pluggable database within a multi-tenant physical standby database has a minimum of one
associated Oracle Net service name.

C.
Each pluggable database within a multi-tenant physical standby has one MRP background process running
during redo apply.

D.
A pluggable database within a multi-tenant standby database can have a different open mode than the
container database.

E.
A pluggable database within a multi-tenant standby database can have a different database role than the
container database.

Explanation:
Incorrect Answers:
C: in 12c Data Guard is set up at the Container level and not the individual Pluggable database level as the
redo log files only belong to the Container database and the individual pluggable databases do not have their
own online redo log files.
E: The database role is defined at the CDB level, not at the individual container level.
Any DDL related to role changes must be executed in the root container because a role is associated with an
entire CDB. Individual pluggable databases (PDBs) do not have their own roles.
https://docs.oracle.com/database/121/SBYDB/create_ps.htm#SBYDB5213

Prev Question

Leave a Reply

Your email address will not be published. Required fields are marked *