QUESTION 73

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 t he CDB level.

Correct Answer: BDG

Section: (none)

Explanation

Explanation/Reference: 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 t he point at which t he 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.