You are connected to a pluggable database (PDB) as a common user with DBA privileges.
The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:
SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = '*' SCOPE = SPFILE;
Which is true about the result of this command?

• A.The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.
• B.The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.
• C.The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.
• D.Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.

Comment: *

Name: *

Email: *

Verification: *

The performance of your database degrades between 11:00 AM and 3:00 PM. Automatic Workload Repository (AWR) snapshots are collected on an hourly basis.
What is the most efficient way of diagnosing this problem?

• A.Create a custom ADDM task for the period defined by the snapshots taken between 11:00 AM and 3:00 PM.
• B.Analyze the latest Automatic Database Diagnostic Monitor (ADDM) report.
• C.Create a SQL Tuning Set (STS) for the currently cached SQL statements in the shared pool and run SQL Performance Analyzer (SPA) to generate recommendations.
• D.Analyze the hourly ADDM reports generated between 11:00 AM and 3:00 PM.

Comment: *

Name: *

Email: *

Verification: *

What is the benefit of running the catctl.plscript during an upgrade of a pre-12c database to an Oracle 12c database?

• A.It provides a summary of the upgrade results.
• B.It recompiles all invalid PL/SQL and Java code.
• C.It generates a log file containing the fixes that can be made to the source database.
• D.It provides parallel upgrade options to finish the upgrade process with a reduced down time.
• E.It generates fix-up scripts to be run on the source database before upgrade.

Comment: *

Name: *

Email: *

Verification: *

Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:

What are three possible causes for the latch-related wait events?

• A.There are frequent logons and logoffs.
• B.The buffers are being read into the buffer cache, but some other session is changing the buffers.
• C.A large number COMMITS are being performed.
• D.The size of the shared pool is too small.
• E.Cursors are not being shared.

Comment: *

Name: *

Email: *

Verification: *

You execute the commands:

Which two statements are true? (Choose two.)

• A.The create usercommand fails if any role with the name Sidney exists in the database.
• B.The user Sidneycan connect to the database instance but cannot perform sort operations because no space quota is specified for the temptablespace.
• C.The user Sidneyis created but cannot connect to the database instance because no profile is assigned to the user.
• D.The user Sidneycan connect to the database instance but requires relevant privileges to create objects in the userstablespace.
• E.The user Sidneyis created and authenticated by the operating system.

Comment: *

Name: *

Email: *

Verification: *