Which two are true about server-generated alerts? (Choose two.)

• A.Stateful alerts must be created by a DBA after resolving the problem.
• B.Stateless alerts can be purged manually from the alert history.
• C.Stateless alerts can be cleared manually.
• D.Stateless alerts are automatically cleared.
• E.Stateful alerts are purged automatically from the alert history.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about upgrading an application in an application container?

• A.An application name and version number must be specified to upgrade the application.
• B.After an application upgrade, the application container's PDBs remain synchronized with the existing application root.
• C.After an application upgrade, the application container's PDBs are automatically synchronized with the application root clone.
• D.The upgrade must be performed when connected to CDB$ROOT.
• E.An application root clone gets created automatically.
• F.The upgrade can be performed when connected either to CDB$ROOT or to PDB$SEED.

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

Comment: *

Name: *

Email: *

Verification: *

In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you f ind that buffer busy waits is caused by contention on data blocks.
Which option would you consider first to decrease the wait event immediately?

• A.Decreasing PCTUSED
• B.Using Automatic Segment Space Management (ASSM)
• C.Decreasing PCTFREE
• D.Increasing db_buffer_cache based on t he V$DB_CACHE_ADVICE recommendation
• E.Increasing the number of DBWN process

Comment: *

Name: *

Email: *

Verification: *

A user complains about poor database performance.
You want to verify if the user's session has waited for certain types of I/O activity.
Which view displays all waits waited on by a session at least once?

• A.VSSESSION_EVENT
• B.V$SESSION_WAIT
• C.VSSESSION
• D.VSSESSTAT
• E.VSSESSION_WAIT_CLASS

Comment: *

Name: *

Email: *

Verification: *