1Z0-082 Multitenant Architecture 3

Question 1

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

Accepted Answer

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

Answer

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

Question 2

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

Accepted Answer

ALTER PLUGGABLE DATABASE pdb_name SAVE STATE

Answer

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

Question 3

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

Accepted Answer

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

Answer

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.

Question 4

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

Accepted Answer

DBA_USERS — COMMON column

Answer

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

Question 5

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

Accepted Answer

CREATE PLUGGABLE DATABASE new_pdb FROM src_pdb

Answer

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

1Z0-082 - Oracle Database Administration I Practice Test

1Z0-082 - Oracle Database Administration I Practice Test

1Z0-082 Multitenant Architecture 3