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

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

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.

Show Hint

← Previous question

Next question →

Vonpire

See here : https://oracle-base.com/articles/12c/multitenant-manage-tablespaces-in-a-cdb-and-pdb-12cr1#temporary-tablespaces

Manage Tablespaces in a CDB

Management of tablespaces in a container database (CDB) is no different to that of a non-CDB database. Provided you are logged in as a privileged user and pointing to the root container, the usual commands are all available. – B

Temporary Tablespaces

Management of the temporary tablespace in a CDB is unchanged from that of a non-CDB database.

A PDB can either have its owner temporary tablespace, or if it is created without a temporary tablespace, it can share the temporary tablespace with the CBD.

Default Tablespaces

Setting the default tablespace and default temporary tablespace for a CDB is unchanged compared to a non-CDB database.

There are a two ways to set the default tablespace and default temporary tablespace for a PDB. The ALTER PLUGGABLE DATABASE command is the recommended way.

CONN pdb_admin@pdb1
ALTER PLUGGABLE DATABASE DEFAULT TABLESPACE users;
ALTER PLUGGABLE DATABASE DEFAULT TEMPORARY TABLESPACE temp; – C
For backwards compatibility, it is also possible to use the ALTER DATABASE command.

CONN pdb_admin@pdb1
ALTER DATABASE DEFAULT TABLESPACE users;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp;
With both methods, you should be pointing to the appropriate container for the command to work.

Tri

Thanks Vonpire!