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 user connecting from the local server host

Answer

A user with local administrator privileges in CDB$ROOT

Answer

A user defined in CDB$ROOT with restricted PDB access

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 DATABASE pdb_name AUTO OPEN

Answer

SET PDB pdb_name AUTOSTART = TRUE

Answer

ALTER PLUGGABLE DATABASE pdb_name STARTUP MODE AUTO

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

A PDB that exclusively hosts Java EE application data

Answer

A container that stores Oracle Forms and Reports applications

Answer

A read-only PDB dedicated to application reporting workloads

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

V$USERS — SCOPE column

Answer

CDB_USERS — LOCAL_USER column

Answer

ALL_USERS — USER_TYPE column

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

CLONE PLUGGABLE DATABASE src_pdb TO new_pdb

Answer

CREATE PDB new_pdb AS CLONE OF src_pdb

Answer

DUPLICATE PLUGGABLE DATABASE src_pdb NAMED new_pdb

Question 6

What does 'unplugging' a PDB accomplish?

Accepted Answer

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

Answer

Permanently deletes the PDB and its associated data files

Answer

Immediately moves the PDB to a different CDB

Answer

Converts the PDB to a standalone non-CDB Oracle database

Question 7

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

Accepted Answer

TEMP

Answer

PDBTEMP

Answer

SYSTEM_TEMP

Answer

PDB_TEMP