Oracle Database Administration II — Question 5

For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)

Answer options

• A. to specify a default tablespace in a PDB cloned from another PDB in the same CDB.
• B. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB
• C. to include specific user tablespaces only when relocating a PDB
• D. to specify the list of user tablespaces to include when moving a non-CDB to a PDB
• E. to exclude a temp tablespace when plugging in a PDB
• F. to specify the list of tablespaces to include when creating a PDB from the CDB seed

Correct answer: B, D

Explanation

The USER_TABLESPACE clause is applicable for excluding all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB (option B). It can also be used to specify the list of user tablespaces to include when converting a non-CDB to a PDB (option D). The other options do not align with the functions of the USER_TABLESPACE clause.