Your database instance has Automatic Memory Management enabled and supports shared server connections.
Examine the following:
1 . Parallel execution messages and control structures
2 . Local variables for a process
3 . Security and resource usage information
4 . Runtime memory values, such as rows retrieved for a SQL statement using a serial execution plan
5. SQL execution work areas
Which option indicates what is allocated from the large pool in this instance?

• A.1, 2, 3, and 5
• B.1, 2, and 4
• C.only 1
• D.1, 2, and 5

Comment: *

Name: *

Email: *

Verification: *

Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container.
The steps to recover the tablespace are as follows:
1. Mount the CDB.
2. Close all the PDBs.
3. Open the database.
4. Apply the archive redo logs.
5. Restore the data file.
6. Take the SYSAUX tablespace offline.
7. Place the SYSAUX tablespace online.
8. Open all the PDBs with RESETLOGS.
9. Open the database with RESETLOGS.
10. Execute the command SHUTDOWN ABORT.
Which option identifies the correct sequence to recover the SYSAUX tablespace?

• A.6, 5, 4, 7
• B.10, 1, 2, 5, 8
• C.10, 1, 2, 5, 4, 9, 8
• D.10, 1, 5, 8, 10

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

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the logical storage structure of an Oracle database? (Choose two.)

• A.An extent contains data blocks that are always physically contiguous on disk.
• B.An extent can span multiple segments.
• C.Each data block always corresponds to one operating system block.
• D.It is possible to have tablespaces of different block sizes.
• E.A data block is the smallest unit of I/O in data files.

Comment: *

Name: *

Email: *

Verification: *

Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.
What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?

• A.Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.
• B.Run the Automatic Workload Repository Monitor (ADDM).
• C.Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.
• D.Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.

Comment: *

Name: *

Email: *

Verification: *