1Z0-082 Multitenant Architecture 2 — Questions and Answers
Question 1: Which clause must be included in the CREATE DATABASE statement to create a Container Database (CDB)?
- ENABLE PLUGGABLE DATABASE (Correct answer)
- CREATE PLUGGABLE DATABASE
- CONTAINER DATABASE ON
- MULTITENANT ON
Correct answer: ENABLE PLUGGABLE DATABASE
The ENABLE PLUGGABLE DATABASE clause in CREATE DATABASE instructs Oracle to create a CDB rather than a traditional non-CDB.
Question 2: Which SQL statement opens all PDBs in a CDB at once?
- ALTER PLUGGABLE DATABASE ALL OPEN (Correct answer)
- STARTUP ALL PDBS
- OPEN ALL PLUGGABLE DATABASE
- ALTER DATABASE OPEN ALL CONTAINERS
Correct answer: ALTER PLUGGABLE DATABASE ALL OPEN
ALTER PLUGGABLE DATABASE ALL OPEN opens every PDB in the current CDB instance in a single command.
Question 3: After restarting a CDB, what is the default state of user-created PDBs?
- MOUNTED (Correct answer)
- OPEN READ WRITE
- OPEN READ ONLY
- OPEN RESTRICTED
Correct answer: MOUNTED
When a CDB restarts, all PDBs default to MOUNTED state and must be explicitly opened unless SAVE STATE was previously configured.
Question 4: Which command creates a new PDB from the PDB$SEED template?
- CREATE PLUGGABLE DATABASE new_pdb ADMIN USER pdb_admin IDENTIFIED BY password (Correct answer)
- CREATE DATABASE new_pdb FROM SEED
- CLONE PDB$SEED TO new_pdb
- CREATE PDB new_pdb USING SEED
Correct answer: CREATE PLUGGABLE DATABASE new_pdb ADMIN USER pdb_admin IDENTIFIED BY password
CREATE PLUGGABLE DATABASE with the ADMIN USER clause creates a new PDB using PDB$SEED as the source template.
Question 5: What does the CONTAINERS() table function allow a DBA to do when connected to CDB$ROOT?
- Query a specific table across all open PDBs simultaneously (Correct answer)
- List all containers and their statuses
- Move rows between containers
- Create identical tables in all PDBs
Correct answer: Query a specific table across all open PDBs simultaneously
The CONTAINERS() function enables cross-container queries, allowing a single SELECT to retrieve data from a table across all open PDBs.
Question 6: What happens to all PDBs when a DBA shuts down the CDB instance?
- All PDBs are automatically closed along with the CDB (Correct answer)
- PDBs save their state and remain available independently
- PDBs switch to standalone read-only mode
- PDB data files are unmounted from the OS separately
Correct answer: All PDBs are automatically closed along with the CDB
PDBs share the CDB instance, so shutting down the CDB instance closes all PDBs — they cannot run independently.
Question 7: Which view should be queried to check the real-time OPEN_MODE of all PDBs in a CDB?
- V$PDBS (Correct answer)
- DBA_PDBS
- V$DATABASE
- CDB_PDBS
Correct answer: V$PDBS
V$PDBS is a dynamic performance view that reflects the current OPEN_MODE (READ WRITE, READ ONLY, or MOUNTED) of each PDB.
1Z0-082 Multitenant Architecture 2
Which clause must be included in the CREATE DATABASE statement to create a Container Database (CDB)?