1Z0-082 Multitenant Architecture 1 — Questions and Answers
Question 1: What does CDB stand for in Oracle Multitenant Architecture?
- Container Database (Correct answer)
- Central Database
- Clustered Database
- Consolidated Database
Correct answer: Container Database
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?
- CDB$ROOT (Correct answer)
- SYS$ROOT
- ROOT$CDB
- CDB$MASTER
Correct answer: CDB$ROOT
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?
- It serves as a read-only template for creating new PDBs (Correct answer)
- It stores the CDB administrator credentials
- It hosts shared application data for all PDBs
- It provides a backup of the CDB$ROOT container
Correct answer: It serves as a read-only template for creating new PDBs
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?
- V$PDBS
- V$CONTAINERS (Correct answer)
- DBA_PDBS
- CDB_PDBS
Correct answer: V$CONTAINERS
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?
- CONNECT TO pdb_name
- USE pdb_name
- ALTER SESSION SET CONTAINER = pdb_name (Correct answer)
- SET CONTAINER pdb_name
Correct answer: ALTER SESSION SET CONTAINER = pdb_name
ALTER SESSION SET CONTAINER = pdb_name switches the current session context to the specified PDB without disconnecting.
Question 6: What is a 'common user' in Oracle Multitenant Architecture?
- A user created in CDB$ROOT that exists across all containers (Correct answer)
- A user shared between exactly two PDBs
- A default Oracle user such as SYS or SYSTEM
- A user with read-only privileges across the CDB
Correct answer: A user created in CDB$ROOT that exists across all containers
A common user is defined in CDB$ROOT and automatically has a presence in every container, including PDB$SEED and all PDBs.
Question 7: What naming convention is required for common users created in a CDB?
- Names must begin with the prefix C## (Correct answer)
- Names must end with the suffix _CDB
- Names must begin with SYS or SYSTEM
- Names must be in all uppercase letters
Correct answer: Names must begin with the prefix C##
Common user names must start with C## (e.g., C##ADMIN) by default to distinguish them from local users scoped to a single PDB.
1Z0-082 Multitenant Architecture 1
What does CDB stand for in Oracle Multitenant Architecture?