Which three statements are true concerning the multitenant architecture? (Choose three.)
Correct Answer: B,D,G
Explanation/Reference:
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 Answers:
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.
C: There is a separate SYSAUX tablespace for the root and for each PDB.
F: There is a separate SYSTEM tablespace for the root and for each PDB. -