ExamDumpster

1Z0-084

Oracle Database 19c: Performance Management and Tuning practice test

307 Oracle 1Z0-084 and 1z0-064 practice questions with explanations, in study, timed and flashcard modes. 20 sample questions are free.

Full access

$99

  • All 307 questions across 1Z0-084 and 1z0-064, with explanations
  • Study, timed and flashcard modes
  • Progress saved, resume any time
Try the free samples first
Oracle logo
Total questions
307
Free samples
20
Versions
2
Updated
Oct 2026

Exam simulator

Practice 1Z0-084 in the simulator.

Study, timed and flashcard modes. Answers and explanations as you go, and your progress saves.

At a glance

1Z0-084, by the numbers.

Official specifications published by Oracle.

Duration
90 min
Questions
55
Passing score
60%
Exam fee
$245
In the bank
1Z0-084 (188), 1z0-064 (119)
Open the full exam guide

Exam guide

Everything about 1Z0-084.

1Z0-084 · Oracle · v1.0

What is 1Z0-084?

1Z0-084 tests whether you can find and fix performance problems in Oracle Database 19c. Most candidates are senior database administrators (DBAs) who run busy production systems. A pass makes you an Oracle Certified Professional in Performance Management and Tuning. The exam asks you to diagnose slow systems with the Automatic Workload Repository (AWR), a built-in store of regular performance snapshots. You also tune memory areas such as the shared pool, buffer cache and PGA. For example, you may read an execution plan to see why a query scans a whole table instead of using an index. The practice test works through diagnostics, problem SQL, the optimizer and memory tuning.

What you'll practise

  • Diagnose slow databases with AWR, ADDM and ASH reports.
  • Find problem SQL statements and read their execution plans and trace files.
  • Influence the optimizer with statistics, parameters and the SQL Tuning Advisor.
  • Tune the shared pool, buffer cache and PGA, or let automatic memory management do it.
  • Test the effect of a change with SQL Performance Analyzer and Database Replay.
  • Set metric thresholds, alerts and AWR baselines that warn you before users notice.

Requirements

  • No formal prerequisites: anyone can book the exam.
  • Recommended: experience as an Oracle Database administrator and a good grasp of its architecture.
  • Recommended: working knowledge of SQL and PL/SQL.
  • Recommended: hands-on time with Oracle Database 19c.

Who it's for

  • Database administrators who look after busy Oracle Database 19c systems.
  • Performance tuning specialists and senior DBAs who fix slow queries and workloads.
  • Database architects and consultants who plan and review Oracle database performance.

Exam details

Published by Oracle, plus what is in our question bank.

Duration
90 min
Questions
55
Passing score
60%
Level
Professional

Three ways to practise

Study mode

Work through the bank at your own pace with the answer and explanation one tap away. Flag questions, add notes, bookmark the hard ones.

Open in the simulator

Timed mode

A shuffled deck with a countdown that mirrors the real exam. Your score is saved to your attempt history.

Open in the simulator

Flashcards

Question on the front, answer on the back. Good for the last week before the exam.

Open in the simulator

1Z0-084 questions, answered