Oracle Database Administration 2019 Certified Professional — Question 7

Which three statements are true regarding multitenant architecture for RAC databases? (Choose three.)

Answer options

• A. One UNDO tablespace for each PDB is required.
• B. PDBs can have local temporary tablespaces.
• C. You can open one, several, or all PDBs on one, several, or all CDB instances.
• D. It requires the CDB to use shared UNDO management.
• E. One UNDO tablespace for each instance is required.
• F. PDBs must use shared Temporary tablespace.

Correct answer: B, C, E

Explanation

The correct answers B, C, and E accurately reflect the characteristics of multitenant architecture in RAC databases. B is correct because PDBs indeed can have local temporary tablespaces. C is true as it is possible to manage PDBs across various CDB instances. E is correct because each instance in a RAC configuration requires its own UNDO tablespace. Options A, D, and F are incorrect because they do not align with the requirements of PDB configuration in a multitenant environment.