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

CREATE PLUGGABLE DATABASE

Answer

CONTAINER DATABASE ON

Answer

MULTITENANT ON

Question 2

Which SQL statement opens all PDBs in a CDB at once?

Accepted Answer

ALTER PLUGGABLE DATABASE ALL OPEN

Answer

STARTUP ALL PDBS

Answer

OPEN ALL PLUGGABLE DATABASE

Answer

ALTER DATABASE OPEN ALL CONTAINERS

Question 3

After restarting a CDB, what is the default state of user-created PDBs?

Accepted Answer

MOUNTED

Answer

OPEN READ WRITE

Answer

OPEN READ ONLY

Answer

OPEN RESTRICTED

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 DATABASE new_pdb FROM SEED

Answer

CLONE PDB$SEED TO new_pdb

Answer

CREATE PDB new_pdb USING SEED

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

List all containers and their statuses

Answer

Move rows between containers

Answer

Create identical tables in all PDBs

Question 6

What happens to all PDBs when a DBA shuts down the CDB instance?

Accepted Answer

All PDBs are automatically closed along with the CDB

Answer

PDBs save their state and remain available independently

Answer

PDBs switch to standalone read-only mode

Answer

PDB data files are unmounted from the OS separately

Question 7

Which view should be queried to check the real-time OPEN_MODE of all PDBs in a CDB?

Accepted Answer

V$PDBS

Answer

DBA_PDBS

Answer

V$DATABASE

Answer

CDB_PDBS