Choose the best answer. 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?
A
The right answer is C. eight
The right answer is A. seven
Explanation:
In a multitenant container database (CDB) with pluggable databases (PDBs), each container can have its own default temporary tablespace. Here's the breakdown:
CDB$ROOT: The root container has one default temporary tablespace.
PDB$SEED: The seed PDB has its own default temporary tablespace.
Two regular PDBs: Each regular PDB has its own default temporary tablespace (2 total).
Application Root: The application root container has its own default temporary tablespace.
Two application PDBs: Each application PDB can have its own default temporary tablespace (2 total).
Application Seed: The application seed has its own default temporary tablespace.
Adding these together:
CDB$ROOT = 1
PDB$SEED = 1
Regular PDBs = 2
Application Root = 1
Application PDBs = 2
Total = 7