Oracle Database 12c: Advanced Administration — Question 179

Which two statements are true about tablespaces in multitenant container databases (CDBs)?

Answer options

• A. Default permanent tablespaces can be shared across pluggable databases (PDBs).
• B. The current container must be set to root to create or modify the default temporary tablespace or tablespace group for a CDB.
• C. Each PDB can have its own default temporary tablespace.
• D. The default permanent tablespace for a PDB can be changed only by a local user with the required permissions.
• E. The amount of space that each PDB can use in a shared temporary tablespace must be set at the CDB level.

Correct answer: A, B

Explanation

Statements A and B are correct as default permanent tablespaces can indeed be shared among PDBs, and the root container is necessary for modifications to default temporary tablespaces. Statements C, D, and E are incorrect because they misrepresent the flexibility and permissions associated with tablespaces in CDBs, particularly regarding the default temporary tablespaces and their management.