Question 1

Which feature of the Oracle Database allows you to capture database workload and replay it in a test environment to analyze the impact of system changes?

Options :

A : Real Application Testing

B : Oracle Data Guard

C : Oracle Automatic Storage Management

D : Oracle Advanced Security

Answer: A

Question 2

Which of the following options allows you to manage and control the execution plans used by the Oracle database optimizer?

Options :

A : Automatic Workload Repository (AWR)

B : SQL Performance Analyzer (SPA)

C : SQL Plan Management (SPM)

D : Automatic Database Diagnostic Monitor (ADDM)

Answer: C

Question 3

When using Automatic Memory Management in Oracle Database 19c, what is the purpose of the MEMOPTIMIZE_POOL_SIZE parameter?

Options :

A : It specifies the maximum size of the SGA.

B : It determines the size of the shared pool.

C : It controls the amount of memory reserved for PGA usage.

D : It adjusts the amount of memory allocated to the memoptimize pool.

Answer: D

Question 4

Which of the following is the best practice when creating indexes in Oracle Database?

Options :

A : Create indexes on all columns of a table.

B : Create indexes on frequently queried columns.

C : Create indexes on columns with high cardinality.

D : Create indexes on all columns used in join conditions.

Answer: B

Question 5

Which approach is recommended for tuning SQL statements that perform poorly?

Options :

A : Running the SQL Access Advisor

B : Running the SQL Tuning Advisor

C : Running the SQL Performance Analyzer

D : Running the SQL Plan Management

Answer: B