Free Oracle 1Z0-084 Exam Questions

Become Oracle Certified with updated 1Z0-084 exam questions and correct answers

Page: 1 / 76

Total 378 Questions | Updated On: Aug 01, 2026

Add To Cart

Question 1

Which statement regarding SQL Plan Management (SPM) is true?

A : SPM automatically creates and maintains execution plans for SQL statements.

B : SPM requires the OPTIMIZER_FEATURES_ENABLE initialization parameter to be set to the current Oracle Database release level.

C : SPM captures execution plans and uses them to compare with new plans generated for the same SQL statement.

D : SPM automatically updates execution plans based on changes in the database environment.

Answer: C

Question 2

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

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

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

A : SQL Performance Analyzer

B : Database Replay

C : Workload Capture and Replay

D : SQL Tuning Advisor

Answer: B

Question 4

Which tool can be used to identify inefficient SQL statements and tune them for improved performance?

A : SQL*Plus

B : AWR Report

C : Oracle Enterprise Manager

D : Explain Plan

Answer: D

Question 5

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

A : Prevents plan regression

B : Improves query performance

C : Automatically tunes SQL statements

D : Manages index usage

Answer: A

Page: 1 / 76

Total 378 Questions | Updated On: Aug 01, 2026

Add To Cart