Which three are true about Automatic Workload Repository (AWR) snapshots?

Answer(s): B,D,F

Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PDB) starting from Oracle 19c?

creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned
creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned
backing up the cloned PDB
opening the cloned PDB
leaving the cloned PDB in mount state

Answer(s): A,D

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

All metrics are instance related.
Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.
A space usage management alert is automatically cleared after the underlying problem is resolved
They are generated by SMON when a tablespace is 97% full.
Metrics are statistical counts for a specific unit.
STATISTICS_LEVEL must be set to ALL to generate alerts.

Answer(s): B,C,E

Choose three. In which three situations can you use threshold server-generated alerts to help diagnose and fix problems?

when free space in a dictionary managed tablespace falls below a specified percentage
when free space in a locally managed tablespace falls below a specified percentage
when the total number of locked user account exceeds a specific value
when the number of logons per second exceeds a specific value
when a resumable statement is suspended
when the total number of logons exceeds a specific value

Answer(s): B,C,D

Free Oracle 1z0-083 Exam Questions (page: 3)