Which three statements are true concerning the multitenant architecture?
A.
Each pluggable database (PDB) has its own set of background processes.
B.
A PDB can have a private temp tablespace.
C.
PDBs can share the sysaux tablespace.
D.
Log switches occur only at the multitenant container database (CDB) level.
E.
Different PDBs can have different default block sizes.
F.
PDBs share a common system tablespace.
G.
Instance recovery is always performed at the CDB level.
Explanation:
B:
* A PDB would have its SYSTEM, SYSAUX, TEMP tablespaces.It can also contains other user
created tablespaces in it.
* There is one default temporary tablespace for the entire CDB. However, you can create
additional temporary tablespaces in individual PDBs.
D:
* There is a single redo log and a single control file for an entire CDB
* A log switch is the point at which the database stops writing to one redo log file and begins
writing to another. Normally, a log switch occurs when the current redo log file is completely filled
and writing must continue to the next redo log file.
G: instance recovery
The automatic application of redo log records to uncommitted data blocks when an database
instance is restarted after a failure.Incorrect:
Not A:
* There is one set of background processes shared by the root and all PDBs. –
* High consolidation density. The many pluggable databases in a single
container database share its memory and background processes, letting you operate
many more pluggable databases on a particular platform than you can single databases
that use the old architecture.
Not C: There is a separate SYSAUX tablespace for the root and for each PDB.
Not F: There is a separate SYSTEM tablespace for the root and for each PDB. –
BDG
BDG