Oracle 1Z0-083 Quiz 16 Topic 9 Questions 76-80

Question: 1

Which two are true about Optimizer Statistics? (Choose two.)

AThey can be gathered by the DBMS_STATS package.

BThey are gathered by the SQL Tuning Advisor.

CThey provide real-time data about schema objects.

DThey are ignored by Optimizer if they are stale.

EBy default, they are automatically gathered by a maintenance job.

Show Answer

Question: 2

Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)? (Choose

three.)

Athe data dictionary in CDB$ROOT

Btemporary tablespaces

Cthe Process Monitor Process (PMON)

DSYSAUX tablespaces

Ethe log writer process (LGWR)

Fundo tablespaces

Show Answer

Question: 3

Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable

database (PBD) starting from Oracle 19c? (Choose three.)

Acreating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned

Bcreating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to
be cloned

Ccreating a new empty PDB in the local database from PDB$SEED

Dcreating a database link from CDB$ROOT in the remote database to be cloned to CDB$ROOT in the local database

Eautomatically dropping the database link to the remote database if it already exists

Fcreating a database link from CDB$ROOT in the remote database to the PDB in the local database

Gopening the cloned PDB

Show Answer

Question: 4

Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic

Monitor (ADDM) in an Oracle multitenant environment? (Choose three.)

AADDM can run in a nonroot container.

BAWR snapshots can be created in CDB$ROOT.

CAWR reports can be generated while connected to any container.

DAll AWR data is stored in the CDB$ROOT SYSAUX tablespace.

EAWR snapshots can be created in a PDB.

FNo AWR data is stored in the CDB$ROOT SYSAUX tablespace.

Show Answer

Question: 5

PDB1 and PBD2 are pluggable databases in CDB1.

Examine these commands:

q5_1Z0-083

CDB1 is then restarted.

Which three are true? (Choose three.)

APDB2 will be MOUNTED.

BPDB1 will be MOUNTED.

CPDB$SEED will be opened READ ONLY.

DPDB2 will be opened READ WRITE.

EPDB1 will be opened READ WRITE.

FPDB$SEED will be MOUNTED.

Show Answer

Oracle 1Z0-083 Quiz:16 Topic:9 Questions:76-80