Multitenant Architecture Flashcards

What is a 'local user' in Oracle Multitenant Architecture?

Answer: A user created within a specific PDB and accessible only in that PDB

A local user is created inside a specific PDB and exists only in that container, with no presence in other PDBs or the root.

How do you configure a PDB to automatically open whenever the CDB instance starts?

Answer: ALTER PLUGGABLE DATABASE pdb_name SAVE STATE

ALTER PLUGGABLE DATABASE ... SAVE STATE persists the PDB's current open mode so it is automatically restored after the next CDB restart.

What is an 'application container' in Oracle 19c Multitenant?

Answer: A named container that serves as a sub-root for a group of related application PDBs

An application container is an optional layer between CDB$ROOT and regular PDBs, acting as a root for application PDBs that share common application metadata.

Which data dictionary view and column identify whether a user is a common user or a local user?

Answer: DBA_USERS — COMMON column

DBA_USERS includes a COMMON column that returns 'YES' for common users (defined in CDB$ROOT) and 'NO' for local users.

Which SQL statement clones an existing PDB named SRC_PDB to create a new PDB named NEW_PDB within the same CDB?

Answer: CREATE PLUGGABLE DATABASE new_pdb FROM src_pdb

CREATE PLUGGABLE DATABASE new_pdb FROM src_pdb clones the source PDB to produce a new PDB with the same structure and data.

What does 'unplugging' a PDB accomplish?

Answer: Closes the PDB and generates an XML manifest file describing its structure for future use

Unplugging closes the PDB and creates an XML metadata file so the PDB can later be plugged into another CDB.

What is the name of the default temporary tablespace created in a newly provisioned PDB?

Answer: TEMP

A new PDB uses a temporary tablespace named TEMP by default, consistent with the naming convention of standalone non-CDB Oracle databases.