nerdexam
Oracle

1Z0-060 · Question #61

Which three statements are true concerning the multitenant architecture?

The correct answer is B. A PDB can have a private temp tablespace. D. Log switches occur only at the multitenant container database (CDB) level. G. Instance recovery is always performed at the CDB level. 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. There is a single redo log…

New Features for Database Infrastructure and Architecture

Question

Which three statements are true concerning the multitenant architecture?

Options

  • AEach pluggable database (PDB) has its own set of background processes.
  • BA PDB can have a private temp tablespace.
  • CPDBs can share the sysaux tablespace.
  • DLog switches occur only at the multitenant container database (CDB) level.
  • EDifferent PDBs can have different default block sizes.
  • FPDBs share a common system tablespace.
  • GInstance recovery is always performed at the CDB level.

How the community answered

(62 responses)
  • A
    15% (9)
  • B
    74% (46)
  • C
    5% (3)
  • E
    2% (1)
  • F
    5% (3)

Explanation

  • 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. * 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. * 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.

Topics

#CDB architecture#PDB isolation#background processes#instance recovery

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice