1Z0-082 Multitenant Architecture

Question 1

What does CDB stand for in Oracle Multitenant Architecture?

Accepted Answer

Container Database

Answer

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

Question 2

What is the name of the root container in a CDB?

Accepted Answer

CDB$ROOT

Answer

The root container is always named CDB$ROOT and holds Oracle-supplied metadata, common users, and common roles.

Question 3

What is the primary purpose of PDB$SEED in a CDB?

Accepted Answer

It serves as a read-only template for creating new PDBs

Answer

PDB$SEED is a read-only seed PDB that Oracle uses as a template when creating new pluggable databases.

Question 4

Which dynamic performance view shows ALL containers in a CDB, including CDB$ROOT and PDB$SEED?

Accepted Answer

V$CONTAINERS

Answer

V$CONTAINERS includes every container (CDB$ROOT, PDB$SEED, and all user-created PDBs), while V$PDBS shows only PDBs.

Question 5

Which SQL statement switches the current session from CDB$ROOT to a specific PDB?

Accepted Answer

ALTER SESSION SET CONTAINER = pdb_name

Answer

ALTER SESSION SET CONTAINER = pdb_name switches the current session context to the specified PDB without disconnecting.

1Z0-082 - Oracle Database Administration I Practice Test