PracticeVideosBlogFlashcardsEspañol
All Practice Exams

100+ Free Oracle 1Z0-084 Practice Questions

Pass your Oracle Database 19c: Performance Management and Tuning (1Z0-084) exam on the first try — instant access, no signup required.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately
100+ Questions
100% Free

Loading practice questions...

Same family resources

Explore More Oracle Certifications

Continue into nearby exams from the same family. Each card keeps practice questions, study guides, flashcards, videos, and articles in one place.

Oracle SQL

Practice Questions1 blog

OCI AI Foundations

Practice Questions

OCI Architect

Practice Questions

OCI Foundations

Practice Questions

Oracle DBA

Practice Questions

OCI 2025 Data Science Professional (1Z0-1110-25)

Practice Questions

More From This Family

Videos and articles for deeper review.

ArticleOracle SQL 1Z0-071 Exam Guide 2026: Official Facts, Topic Traps, and Practice Plan12 min read
2026 Statistics

Key Facts: Oracle 1Z0-084 Exam

55 questions

The 1Z0-084 exam contains 55 multiple-choice questions

Oracle University - 1Z0-084 exam page

90 minutes

Candidates have 90 minutes to complete 1Z0-084

Oracle University - 1Z0-084 exam page

60%

The published passing score for 1Z0-084 is 60%

Oracle University - 1Z0-084 exam page

USD 245

Typical US exam fee per attempt for 1Z0-084

Oracle certification exam pricing

OCP prerequisite

An Oracle Database Administrator OCP credential is required to earn the certification

Oracle University - Performance Management and Tuning track

Oracle Database 19c

The exam is validated for product version Oracle Database 19c

Oracle University - 1Z0-084 exam page

Professional level

1Z0-084 earns an Oracle Certified Professional (OCP) credential

Oracle University - certification track

100

Free original practice questions in this bank

OpenExamPrep

Oracle 1Z0-084 is the Oracle Certified Professional exam for Oracle Database 19c performance management and tuning. It has 55 multiple-choice questions, a 90-minute time limit and a 60% passing score, and costs about USD 245 per attempt. The exam requires an existing Oracle Database Administrator OCP credential and tests AWR/ASH/ADDM diagnostics, SQL tuning, the optimizer and statistics, indexing, memory and instance tuning, SQL Plan Management and Real Application Testing. This 100-question bank gives original, scenario-based practice with a full explanation for every answer option.

Sample Oracle 1Z0-084 Practice Questions

Try these sample questions to test your Oracle 1Z0-084 exam readiness. Each question includes a detailed explanation. Start the interactive quiz above for the full 100+ question experience with AI tutoring.

1Which Oracle Database feature automatically captures snapshots of performance statistics at regular intervals and stores them for later analysis?
A.Automatic Workload Repository (AWR)
B.Active Session History (ASH)
C.SQL Tuning Set (STS)
D.Database Resource Manager
Explanation: AWR automatically captures performance statistics snapshots (by default every 60 minutes) and retains them (by default 8 days) for diagnostic analysis. ADDM and AWR reports are built on these snapshots.
2By default, how often does Oracle Database take an AWR snapshot, and how long are snapshots retained?
A.Every 30 minutes, retained 7 days
B.Every 60 minutes, retained 8 days
C.Every 15 minutes, retained 30 days
D.Every 60 minutes, retained 1 day
Explanation: The default AWR snapshot interval is 60 minutes and the default retention is 8 days (11520 minutes). Both can be changed with DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS.
3Active Session History (ASH) samples which kind of sessions, and how often?
A.All connected sessions, once per minute
B.Only active sessions, once per second
C.Only blocked sessions, on every wait
D.All sessions, on every commit
Explanation: ASH samples the state of active sessions (those on the CPU or waiting on a non-idle event) once per second and keeps the samples in a circular buffer in the SGA. This makes ASH ideal for diagnosing short-lived or transient performance spikes.
4Which advisor runs automatically after each AWR snapshot to analyze the period and report the top performance problems with recommendations?
A.SQL Tuning Advisor
B.Automatic Database Diagnostic Monitor (ADDM)
C.SQL Access Advisor
D.Segment Advisor
Explanation: ADDM runs automatically after each AWR snapshot, analyzes the time interval between the last two snapshots, identifies the root causes of the biggest performance problems (using DB time as the metric), and provides recommendations such as SQL tuning or configuration changes.
5ADDM measures and ranks performance problems primarily by which metric?
A.Buffer cache hit ratio
B.DB time
C.Number of logical reads
D.Parse count
Explanation: ADDM uses DB time (the total time spent by sessions on database calls, including CPU and non-idle waits) as the common currency for ranking problems. Reducing DB time is the goal, which lets ADDM compare very different problems on one scale.
6You need to compare performance between two different time periods to find what changed after a deployment. Which AWR-based report is designed for this?
A.AWR report
B.AWR Compare Periods report
C.ASH report
D.ADDM report
Explanation: The AWR Compare Periods report (awrddrpt.sql) compares statistics between two pairs of snapshots, highlighting differences in load profile, top events, SQL and configuration. It is the standard tool for before-and-after analysis.
7Which view exposes the in-memory Active Session History samples for the current instance?
A.DBA_HIST_ACTIVE_SESS_HISTORY
B.V$ACTIVE_SESSION_HISTORY
C.V$SESSION
D.DBA_ADDM_FINDINGS
Explanation: V$ACTIVE_SESSION_HISTORY exposes the recent ASH samples held in the SGA circular buffer. Older samples that have been flushed to disk by AWR are available in DBA_HIST_ACTIVE_SESS_HISTORY.
8Which lightweight alternative to AWR can be installed when AWR (a Diagnostics Pack feature) is not licensed?
A.Statspack
B.SQL Trace
C.Automatic Memory Management
D.Resource Manager
Explanation: Statspack is the non-licensed predecessor of AWR. It collects performance snapshots into its own schema and produces reports, providing AWR-like analysis for sites without the Diagnostics Pack.
9An AWR report's Top Timed Events section shows 'db file sequential read' as the dominant wait. What does this typically indicate?
A.Full table scans reading large multiblock chunks
B.Single-block reads, often from index access or rows fetched by ROWID
C.Excessive hard parsing in the shared pool
D.Log writer contention during commits
Explanation: 'db file sequential read' is a single-block read wait, typically caused by index access paths and table access by ROWID. High totals can indicate heavy index lookups or I/O latency on those reads.
10The 'db file scattered read' wait event is most directly associated with which operation?
A.Index unique scans
B.Multiblock reads during full table or fast full index scans
C.Redo log writes
D.Library cache pin waits
Explanation: 'db file scattered read' is a multiblock read into non-contiguous buffer cache buffers, characteristic of full table scans and index fast full scans. A high level may point to missing indexes or appropriate large-scan workload.

About the Oracle 1Z0-084 Exam

Oracle Database 19c: Performance Management and Tuning (1Z0-084) is the Oracle Certified Professional exam for DBAs who diagnose, manage and tune Oracle Database 19c performance. It validates the ability to apply a structured tuning methodology using the right tools to monitor, diagnose and resolve instance-level and SQL-level performance problems. The exam covers AWR, ASH and ADDM, Statspack, metrics, alerts and baselines, identifying and tuning problem SQL with the SQL Tuning and SQL Access advisors, managing and influencing the optimizer and its statistics, indexing and reducing the cost of SQL operations, tuning the shared pool, buffer cache and PGA, Automatic Memory Management and the In-Memory Column Store, SQL Plan Management, and Real Application Testing with SQL Performance Analyzer and Database Replay. Candidates must already hold a qualifying Oracle Database Administrator Certified Professional credential.

Assessment

55 multiple-choice questions covering diagnostic and AWR-based tools, SQL identification and tuning, the optimizer and statistics, indexes and SQL operation cost, instance and memory tuning, SQL Plan Management and Real Application Testing.

Time Limit

90 minutes.

Passing Score

60%.

Exam Fee

USD 245 per attempt (price varies by country and may change; an Oracle Certification Exam subscription is also available). (Oracle Corporation (Oracle University), delivered through an authorized testing partner.)

Oracle 1Z0-084 Exam Content Outline

20%

Performance Diagnostics & AWR-Based Tools

AWR snapshots, retention and reports; Active Session History (ASH) for time-model and wait analysis; ADDM findings and recommendations; AWR Compare Periods; Statspack as an alternative; and metrics, alerts and baselines to detect and characterise performance regressions.

18%

Identifying & Tuning SQL Statements

Finding high-load SQL from AWR and ASH, reading execution plans and cardinality estimates, and using the SQL Tuning Advisor and SQL Access Advisor to generate SQL profiles, index, materialized-view and partitioning recommendations.

16%

Optimizer & Statistics

Gathering and managing optimizer statistics (table, column, index, system and extended statistics and histograms), using the Optimizer Statistics Advisor, and influencing the optimizer with hints, parameters, adaptive features and statistics to produce stable, efficient plans.

12%

Indexes & Reducing the Cost of SQL Operations

Selecting B-tree, bitmap, function-based and composite indexes, understanding access paths and join methods, and reducing the cost of sorts, aggregations and full scans through indexing, partitioning and rewriting.

18%

Instance & Memory Tuning

Tuning the shared pool and library cache, the buffer cache and its advisories, and the PGA for sorts and hashes; Automatic Memory Management; the In-Memory Column Store; and diagnosing I/O and wait-event bottlenecks at instance level.

8%

SQL Plan Management

Capturing SQL plan baselines automatically or from cursor cache, AWR or SQL Tuning Sets; controlling accepted plans; and evolving baselines to adopt better plans while preventing plan regressions.

8%

Real Application Testing

Using SQL Performance Analyzer to predict the SQL impact of changes such as upgrades or parameter changes, and Database Replay to reproduce a production workload on a test system before rollout.

How to Pass the Oracle 1Z0-084 Exam

What You Need to Know

  • Passing score: 60%.
  • Assessment: 55 multiple-choice questions covering diagnostic and AWR-based tools, SQL identification and tuning, the optimizer and statistics, indexes and SQL operation cost, instance and memory tuning, SQL Plan Management and Real Application Testing.
  • Time limit: 90 minutes.
  • Exam fee: USD 245 per attempt (price varies by country and may change; an Oracle Certification Exam subscription is also available).

Keys to Passing

  • Complete 500+ practice questions
  • Score 80%+ consistently before scheduling
  • Focus on highest-weighted sections
  • Use our AI tutor for tough concepts

Oracle 1Z0-084 Study Tips from Top Performers

1Build a tuning methodology habit: start from AWR or ASH to find the biggest time consumers before changing anything, so you tune the real bottleneck rather than a symptom.
2Practise reading execution plans end to end, including the order of operations, access paths, join methods and the difference between estimated and actual rows.
3Know exactly which advisor solves which problem: ADDM for whole-instance findings, SQL Tuning Advisor for a specific statement, and SQL Access Advisor for indexing and materialized-view design.
4Memorise how optimizer statistics, histograms and extended statistics change cardinality estimates, and when stale or missing statistics cause bad plans.
5Understand SQL Plan Management thoroughly: how baselines are captured, why a plan can be enabled but not accepted, and how evolving baselines prevents regressions.
6Do hands-on labs for SQL Performance Analyzer and Database Replay so you can explain how to test changes such as upgrades or parameter changes before production.

Frequently Asked Questions

How many questions are on the Oracle 1Z0-084 exam and how long is it?

The exam has 55 multiple-choice questions and a 90-minute time limit. The published passing score is 60%.

What is the passing score for 1Z0-084?

Oracle publishes a passing score of 60% for 1Z0-084. Oracle scales and may recalibrate passing scores over time, so always confirm on the official exam page.

Do I need a prerequisite certification before taking 1Z0-084?

Yes. You must already hold a qualifying Oracle Database Administrator Certified Professional credential (such as Oracle Database 19c, 18c, 12c R2 or 12c Administration OCP) to earn the Performance Management and Tuning certification.

What topics does 1Z0-084 cover?

It covers AWR, ASH and ADDM diagnostics, Statspack, metrics and baselines, identifying and tuning SQL with the SQL Tuning and SQL Access advisors, the optimizer and statistics, indexes, shared pool, buffer cache and PGA tuning, Automatic Memory Management, the In-Memory Column Store, SQL Plan Management and Real Application Testing.

How much does the 1Z0-084 exam cost?

The exam costs about USD 245 per attempt in the US; pricing varies by country and may change. Many candidates use the Oracle Certification Exam subscription, which bundles attempts and practice exams.

Are these official Oracle exam questions?

No. These are original OpenExamPrep practice questions written to the published 1Z0-084 objectives, with explanations for every option. They are not copied from Oracle's confidential exam bank.