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

• A.when the total number of logons exceeds a specific value
• B.when free space in a dictionary managed tablespace falls below a specified percentage
• C.when a resumable statement is suspended
• D.when the number of logons per second exceeds a specific value
• E.when free space in a locally managed tablespace falls below a specified percentage
• F.when the total number of locked user account exceeds a specific value

Comment: *

Name: *

Email: *

Verification: *

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

• A.They can be gathered by the DBMS_STATS package.
• B.They provide real-time data about schema objects.
• C.They are ignored by Optimizer if they are stale.
• D.They are gathered by the SQL Tuning Advisor.
• E.By default, they are automatically gathered by a maintenance job.

Comment: *

Name: *

Email: *

Verification: *

Automatic Shared Memory Management is disabled for one of your database instances.
Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance. What would be your next step?

• A.Run the SQL Access Advisor.
• B.Run the Memory Advisor for the shared pool.
• C.Run the Memory Advisor for the System Global Area.
• D.Run the SQL Tunning Advisor.
• E.Run the Memory Advisor for the Program Global Area.

Comment: *

Name: *

Email: *

Verification: *

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 snapshot copy PDB can be a full copy of a source PDB
• C.A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.
• D.A PDB snapshot can be a sparse copy of a source PDB
• E.APDB snapshot can be a full copy of a source 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 PDB1 have been rolled back.
• B.CDB1 is shut down.
• C.PDB1 is closed.
• D.Uncommitted transactions in CDB1 and PDB1 have been rolled back.
• E.CDB1 is in MOUNT state

Comment: *

Name: *

Email: *

Verification: *