OCM Oracle Multitenant Architecture

Question 1

In Oracle Multitenant architecture, what does CDB stand for?

Accepted Answer

Container Database

Answer

Consolidated Database Block

Answer

Central Data Buffer

Answer

Cluster Database Bundle

Question 2

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

Accepted Answer

PDB$SEED

Answer

CDB$ROOT

Answer

SEED$PDB

Answer

ROOT$SEED

Question 3

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

Accepted Answer

4096

Answer

252

Answer

1024

Answer

512

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

DBA_CONTAINERS

Answer

V$DATABASE

Answer

ALL_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 SYSTEM SET CONTAINER = SALESPDB

Answer

CONNECT TO SALESPDB

Answer

USE CONTAINER SALESPDB

Question 6

What does setting LOCAL_UNDO = TRUE at the CDB level enable in Oracle Multitenant?

Accepted Answer

Each PDB maintains its own dedicated undo tablespace rather than sharing a CDB-level undo tablespace

Answer

Undo operations are restricted to the local RAC node

Answer

A local undo segment is created in the SYSTEM tablespace

Answer

Automatic undo management is enabled for temporary tablespaces

Question 7

When creating a new PDB using CREATE PLUGGABLE DATABASE, which clause is typically used to map source datafile paths to the new PDB's target file locations?

Accepted Answer

FILE_NAME_CONVERT

Answer

DATAFILES IN

Answer

TABLESPACE CONVERT

Answer

PATH_CONVERT