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

• A.AWR snapshots can be created in CDB$ROOT.
• B.AWR snapshots can be created in a PDB.
• C.ADDM can run in a nonroot container.
• D.No AWR data is stored in the CDB$ROOT SYSAUX tablespace.
• E.All AWR data is stored in the CDB$ROOT SYSAUX tablespace.
• F.AWR reports can be generated while connected to any container.

Comment: *

Name: *

Email: *

Verification: *

Choose two. Some archived log backups have been accidentally deleted from storage. Which two commands should be used to update the status of backups in the recovery catalog to display only the missing backups?

• A.REPORT OBSOLETE
• B.CROSSCHECK BACKUP OF ARCHIVELOG ALL
• C.LIST ARCHIVELOG
• D.LIST ARCHIVELOG ALL
• E.RESYNC CATALOG
• F.LIST EXPIRED

Comment: *

Name: *

Email: *

Verification: *

Choose two. In performance management, which two factors might reduce the ability of an application to scale to a larger number of users?

• A.the number of data files containing extents belonging to tables updated by a transaction
• B.issuing multiple savepoints during a transaction
• C.the number of tablespaces containing tables updated by a transaction
• D.poorly trained users who do not commit transactions
• E.poorly written SQL

Comment: *

Name: *

Email: *

Verification: *

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

• A.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in PDB$SEED.
• B.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.
• C.System statistics can be gathered only while the CDB is in MOUNT state.
• D.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs).
• E.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/ write mode gathers object statistics for that PDB.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
CDB1 is a container database.
PDB1 and PDB2 are pluggable databases in CDB1.
PDB1 and PDB2 are OPEN in READ WRITE mode.
You execute these commands successfully:

Which two are true? (Choose two.)

• A.Uncommitted transactions in CDB1 and PDB1 have been rolled back.
• B.Uncommitted transactions in PDB1 have been rolled back.
• C.CDB1 is shut down.
• D.PDB1 is closed.
• E.CDB1 is in MOUNT state

Comment: *

Name: *

Email: *

Verification: *