Oracle Database 12c: RAC and Grid Infrastructure Administration — Question 39

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

Answer options

• A. Different pluggable databases within a logical standby database may have different guard statuses.
• B. The Data Guard broker automatically always opens the pluggable databases of a standby database after a role change operation.
• C. The Data Guard broker automatically opens all pluggable databases of a primary database a role change operation.
• D. The CDBDBA privilege must be used instead of the SYSDBA privilege for connections as SYS to the root container of a multi-tenant standby database.
• E. A multi-tenant standby database can have fewer pluggable databases than the primary container database.

Correct answer: C, D

Explanation

Option C is correct because the Data Guard broker indeed opens all pluggable databases of the primary database during a role change. Option D is also correct, as the CDBDBA privilege is necessary for connections to the root container in a multi-tenant standby database. Options A and B are incorrect because guard statuses can be the same across pluggable databases, and the broker does not automatically open pluggable databases on standby after a role change.