ExamDumpster

1z0-064

Oracle Database 12c: Performance Management and Tuning practice test

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

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
–
Versions
2
Updated
Oct 2026

Exam simulator

Practice 1z0-064 in the simulator.

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

At a glance

1z0-064, by the numbers.

Official specifications published by Oracle.

In the bank
1Z0-084 (188), 1z0-064 (119)
Open the full exam guide

Exam guide

Everything about 1z0-064.

1z0-064 · Oracle

What is 1z0-064?

1z0-064 tested whether you could find and fix performance problems in Oracle Database 12c. Oracle retired it in March 2021, and 1Z0-084 now covers the same skills for Database 19c. It was taken by experienced DBAs who tune production databases. A core tool was the Automatic Workload Repository (AWR), which stores performance statistics in snapshots you can compare. For example, you might read an AWR report and find the SQL statement that uses the most time. The practice questions here still focus on 12c tuning: AWR, SQL tuning, memory and I/O.

What you'll practise

  • Use AWR, ADDM and other diagnostic tools to find what slows a database.
  • Find problem SQL statements and help the optimizer pick better plans.
  • Test changes with SQL Performance Analyzer and Database Replay.
  • Tune memory areas such as the shared pool, buffer cache and PGA.
  • Reduce I/O and segment space problems.

Requirements

  • Recommended: hands-on experience tuning Oracle Database 12c.

Who it's for

  • Experienced DBAs who tune Oracle Database 12c systems.
  • Performance specialists reviewing 12c tuning before 1Z0-084.

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-064 questions, answered