Oracle Database Administration II — Question 92

Your CDB has two regular PDBs as well as one application container with two application PDBs and an application seed.
No changes have been made to the standard PDB$SEED.
How many default temporary tablespaces can be assigned in the CDB?

Answer options

• A. six
• B. seven
• C. five
• D. eight
• E. three

Correct answer: D

Explanation

The correct answer is D (eight) because a CDB can have a default temporary tablespace for each PDB and additionally for the application containers. With two regular PDBs and three application-related entities (two application PDBs and the application seed), a total of eight default temporary tablespaces can be assigned. The other options do not account for all the components correctly.