1Z0-083 Online Practice Questions and Answers

Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)

A. All metrics are instance related.

B. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.

C. A space usage management alert is automatically cleared after the underlying problem is resolved.

D. They are generated by SMON when a tablespace is 97% full.

E. Metrics are statistical counts for a specific unit.

F. STATISTICS_LEVEL must be set to ALL to generate alerts.

Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)

A. It analyzes a period of time corresponding to the 12 hours of activity.

B. It runs automatically after each AWR snapshot.

C. A DBA can run it manually.

D. Results are written to the alert log.

E. It analyzes a period of time corresponding to the last day of activity.

Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)

A. After the change, only a common user with the required privilege can create an undo tablespace in CDBandROOT.

B. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.

C. After the change, only one undo tablespace can exist in CDB$ROOT.

D. After the change, any user with the required privilege can create an undo tablespace in the PDBs.

E. Undo tablespaces existing in PDBs must be dropped before the change.

F. After the change, each existing PDB has to be reopened for the new undo mode to take effect.

Which two are true about gathering optimizer statistics? (Choose two.)

A. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.

B. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB.

C. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.

D. System statistics can be gathered only while connected to CDB$ROOT.

E. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)

Examine these queries and their output:

After a system crash, an instance restart and an attempted opening of the PDBs result in:

Which two are true? (Choose two.)

A. Data file 24 can be recovered while PDB2 is opened.

B. Data file 24 must be recovered while the CDB is opened.

C. Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.

D. Data file 24 cannot be recovered while the CDB is opened.

E. Data file 24 must be recovered while PDB2 is closed.

How do you configure a CDB for local undo mode?

A. Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance.

B. Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and create an UNDO tablespace in each PDB, then restart the CDB instance.

C. Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace. Execute ALTER DATABASE LOCAL UNDO ONin each PDB, and then restart the CDB instance.

D. Open the CDB instance in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then change the CDB to read/write mode.

E. Open the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the CDB instance.

Which two are true about creating pluggable databases (PDBs) in Oracle 19c and later releases?

A. A PDB snapshot depends on an existing storage snapshot of the source PDB.

B. A PDB snapshot can be a full copy of a source PDB.

C. A PDB snapshot can be a sparse copy of a source PDB

D. A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.

E. A snapshot copy PDB can be created from a stand-alone clone PDB.

Which three RMAN persistent settings can be set for a database?

A. backup retention policy

B. default backup device type

C. default section size for backups

D. default destinations for backups

E. multiple backup device types for a single backup

Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment? (Choose three.)

A. ADDM can run in a nonroot container.

B. AWR snapshots can be created in CDB$ROOT.

C. AWR reports can be generated while connected to any container.

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

E. AWR snapshots can be created in a PDB.

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

Which three are true about the tools for diagnosing Oracle Database failure situations? (Choose three.)

A. The ADR command-line utility (ADRCI) can package incident information to send to Oracle Support.

B. The Automatic Diagnostic Repository (ADR) has a separate home directory for each instance of each Oracle product that is installed and uses it.

C. Flashback commands help with repairing physical errors.

D. RMAN can always repair corrupt blocks.

E. The ADR can store metadata in an Oracle Database repository.

F. The Data Recovery Advisor uses the ADR.