Question 1

Which feature of Oracle Database can be used to capture and analyze database activity, providing insights into the performance of SQL statements and database objects?

Options :

A : Oracle Enterprise Manager

B : Automatic Database Diagnostic Monitor (ADDM)

C : SQL Tuning Advisor

D : Real-Time Database Operations (Real-Time SQL Monitoring)

Answer: B

Question 2

Which statement regarding Automatic Workload Repository (AWR) is correct?

Options :

A : AWR data can only be accessed using the Oracle Enterprise Manager.

B : AWR automatically collects and stores performance data at regular intervals.

C : AWR data is stored in the system tablespace by default.

D : AWR data is kept in memory and is not written to disk.

Answer: B

Question 3

What is the purpose of the shared pool in the Oracle Database and what is the recommended value for the SHARED_POOL_SIZE parameter in the init.ora file? A. The shared pool is used to store parsed SQL statements, and the recommended value for the SHARED_POOL_SIZE parameter is 256 MB B. The shared pool is used to store parsed SQL statements, and the recommended value for the SHARED_POOL_SIZE parameter varies depending on the size of the database C. The shared pool is used to store user session information, and the recommended value for the SHARED_POOL_SIZE parameter is 1 GB D. The shared pool is used to store database buffer cache, and the recommended value for the SHARED_POOL_SIZE parameter is 512 MB

Options :

A : The shared pool is used to store parsed SQL statements, and the recommended value for the SHARED_POOL_SIZE parameter is 256 MB

B : The shared pool is used to store parsed SQL statements, and the recommended value for the SHARED_POOL_SIZE parameter varies depending on the size of the database

C : The shared pool is used to store user session information, and the recommended value for the SHARED_POOL_SIZE parameter is 1 GB

D : The shared pool is used to store database buffer cache, and the recommended value for the SHARED_POOL_SIZE parameter is 512 MB

Answer: A

Question 4

Which feature of Oracle Database 19c can be used to maximize query performance by automatically creating and maintaining optimal indexes?

Options :

A : Table Compression

B : Query Rewrite

C : Real Application Testing

D : Automatic Indexing

Answer: D

Question 5

Which is the default memory management mode in Oracle Database 19c?

Options :

A : Automatic Shared Memory Management (ASMM)

B : Automatic Memory Management (AMM)

C : Manual Memory Management

D : Dynamic Memory Management

Answer: B