You notice a performance change in your production Oracle database and you want to know which change has made this performance difference.
You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.
Which three findings would you get from the report?

• A.It detects any configuration change that caused a performance difference in both time periods.
• B.It identifies any workload change that caused a performance difference in both time periods.
• C.It detects the top wait events causing performance degradation.
• D.It shows the resource usage for CPU, memory, and I/O in both time periods.
• E.It shows the difference in the size of memory pools in both time periods.
• F.It gives information about statistics collection in both time periods.

Comment: *

Name: *

Email: *

Verification: *

DEFERRED_SEGMENT_CREATION is TRUE in one of your databases.
You execute this command:

Which three statements are true immediately after this statement executes successfully?

• A.No object definition is stored in the data dictionary.
• B.A database object is created.
• C.No database segment is created.
• D.The table and column definitions are stored in the data dictionary.
• E.No column definitions are stored in the data dictionary.
• F.No table definition is stored in the data dictionary.

Comment: *

Name: *

Email: *

Verification: *

You are connected using SQL* Plus to a multitenant container database (CDB) with
SYSDBA privileges and execute the following sequence statements:

What is the result of the last SET CONTAINER statement and why is it so?

• A.Itfails because local users are unable to use the SET CONTAINER statement.
• B.It succeeds because the PDB_ADMIN user has the required privileges.
• C.If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).
• D.It fails because common users are unable to use the SET CONTAINER statement.

Comment: *

Name: *

Email: *

Verification: *

You want execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter RESUMABLE_TIMEOUTto 3600.
Which two statements are true? (Choose two.)

• A.Before a statement executes in resumable mode, the ALTER SESSION ENABLE RESUMABLE statement must be issued in its session.
• B.Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
• C.A suspended statement will report an error if no corrective action has taken place during a timeout period.
• D.A resumable statement can be suspended and resumed only once during execution.
• E.Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.

Comment: *

Name: *

Email: *

Verification: *

Which statement is true about the Database as a Service (DBaaS) instances and Database instances in Oracle Public Cloud

• A.An Oracle database instance can support only one DBaaS instance.
• B.A DBaaS instance can support only one Oracle database instance.
• C.An Oracle database instance can support multiple DBaaS instances.
• D.A DBaaS instance runs in a pluggable database (PDB), which is contained in a multi- tenant container database (CDB).
• E.A DBaaS instance can support multiple Oracle database instances.

Comment: *

Name: *

Email: *

Verification: *