OCM Oracle Multitenant Architecture

Question 1

In Oracle Multitenant architecture, what does CDB stand for?

Accepted Answer

Container Database

Answer

CDB stands for Container Database, which is the top-level database that can host multiple Pluggable Databases (PDBs).

Question 2

Which component of a CDB serves as a read-only, system-supplied template for creating new PDBs?

Accepted Answer

PDB$SEED

Answer

PDB$SEED is the read-only seed PDB provided by Oracle that acts as a template from which new Pluggable Databases are created.

Question 3

What is the maximum number of PDBs supported in a single Oracle 12.2+ CDB?

Accepted Answer

4096

Answer

Oracle 12.2 and later supports up to 4096 PDBs in a single CDB, a significant expansion from the 252-PDB limit in Oracle 12.1.

Question 4

Which Oracle dynamic performance view provides real-time information about all containers (root, seed, and PDBs) in the current CDB?

Accepted Answer

V$CONTAINERS

Answer

V$CONTAINERS is the dynamic performance view that lists every container in the CDB including CDB$ROOT, PDB$SEED, and all user-created PDBs.

Question 5

To switch a DBA session from CDB$ROOT to a PDB named SALESPDB without disconnecting, which SQL command is used?

Accepted Answer

ALTER SESSION SET CONTAINER = SALESPDB

Answer

ALTER SESSION SET CONTAINER = <PDB_name> switches the current session context from the root to the specified PDB without requiring a reconnection.

OCM - Oracle Certified Master Practice Test