Which three statements are true regarding multitenant architecture for RAC databases? (Choose three.)
Which three statements are true regarding multitenant architecture for RAC databases? (Choose three.)
Each Pluggable Database (PDB) can indeed have its own local temporary tablespaces. PDBs offer flexibility since you can open one, several, or all PDBs on one, several, or all Container Database (CDB) instances. Every instance in a RAC database usually has its own undo tablespace, making it necessary for each instance to have a dedicated UNDO tablespace.
E - One UNDO tablespace for each instance is required.
B. is True. Each pluggable database (PDB) can have its own local temporary tablespaces defined within it. C. is True. you can open one, several, or all PDBs on one or several CDB instances as per your requirements. E. is True. It is the minimum. Each instance in a RAC database typically has its own undo tablespace A is False. it's common practice to have one UNDO tablespace for each pluggable database (PDB) in a multitenant architecture, it's not an absolute requirement. D is False. It isn't mandatory or required. By default, in a multitenant environment, each pluggable database (PDB) has its own undo tablespace. F is False. It's not mandatory for PDBs to use shared temporary tablespaces. If needed you can use Local Temporary Tablespace