Question 1

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 2

Which of the following techniques is most effective for improving query performance in an Oracle database?

Options :

A : Using optimizer hints

B : Increasing the SGA size

C : Adding more indexes to the tables

D : Rewriting the SQL queries

Answer: B

Question 3

Which technique can be used to improve the performance of SQL queries?

Options :

A : Parallel Execution

B : Materialized Views

C : Database Replay

D : Database Resource Manager

Answer: A

Question 4

Which feature of Oracle Database 19c provides a mechanism for analyzing the impact on database performance of real-life workloads, such as batch jobs or online transaction processing (OLTP)?

Options :

A :

Automatic Workload Repository (AWR)

B :

Real Application Testing (RAT)

C : Automatic Database Diagnostic Monitor (ADDM)

D : SQL Performance Analyzer (SPA)

Answer: B

Question 5

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

Fill Preparation Gaps with Free Online 1Z0-084 Exam Practice

Buying Options: