Question 1

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 2

Which of the following is a benefit of using SQL Plan Management (SPM)?

Options :

A : Prevents plan regression

B :

Improves query performance

C : Automatically tunes SQL statements

D : Manages index usage

Answer: A

Question 3

Accessing the SALES tables causes excessive db file sequential read wait events. Examine this AWR except:

Now, examine these attributes displayed by querying dba_tables:

Finally, examine these parameter settings:

Which two must both be used to reduce these excessive waits?

Options :

A : Partition the SALES table.

B : Increase PCTFREE for the SALES table.

C : Re-create the SALES table.

D : Compress the SALES table.

E : Coalesce all sales table indexes.

Answer: A,D

Question 4

Which Real Application Testing feature enables the creation of a real-time test environment that closely mimics the actual production workload?

Options :

A : SQL Performance Analyzer

B : Database Replay

C : Workload Capture and Replay

D : SQL Tuning Advisor

Answer: B

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

Free 1Z0-084 Mock Exam – Practice Online Confidently