1Z0-082 Multitenant Architecture 2

Question 1

Which clause must be included in the CREATE DATABASE statement to create a Container Database (CDB)?

Accepted Answer

ENABLE PLUGGABLE DATABASE

Answer

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?

Accepted Answer

ALTER PLUGGABLE DATABASE ALL OPEN

Answer

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?

Accepted Answer

MOUNTED

Answer

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?

Accepted Answer

CREATE PLUGGABLE DATABASE new_pdb ADMIN USER pdb_admin IDENTIFIED BY password

Answer

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?

Accepted Answer

Query a specific table across all open PDBs simultaneously

Answer

The CONTAINERS() function enables cross-container queries, allowing a single SELECT to retrieve data from a table across all open PDBs.

1Z0-082 - Oracle Database Administration I Practice Test