Which two statements are true about a multitenant architecture?
A.
Each pluggable database (PDB) has its own initialization parameter file.
B.
A PDB can have a private undo tablespace.
C.
Log switches occur only at the container database level.
D.
A PDB can have a private temporary tablespace.
E.
Each PDB has a private control file.
C y D is fine for me
Answer C,D.
You are only able to switch the archived logs when you connect to the root of a CDB, but you cannot switch archived redo logs when connected to a PDB.
you can able to create a PDB without temporary tablespace but not able to make it use the temporary tablespace of CDB.
PDB can make use of CDB temp tablespace in the absence of no PDB. having temp talespace for PDB is optional.
that is why create pluggable database having this clause “MAX_SHARED_TEMP_SIZE”
CD
CD
CD
Again CD
SQL> alter system switch logfile;
alter system switch logfile
*
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable database ==> C
SQL>
In contrast, a PDB can not have an undo tablespace. Instead, it uses the undo tablespace belonging to the CDB. If we connect to a PDB, we can see no undo tablespace is visible.
https://oracle-base.com/articles/12c/multitenant-manage-tablespaces-in-a-cdb-and-pdb-12cr1#undo-tablespaces
https://oracle-base.com/articles/12c/multitenant-manage-tablespaces-in-a-cdb-and-pdb-12cr1#temporary-tablespaces
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. ==>> D
CD Explanation of Vikram is a little confusing for me
C&D is correct!
CD