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
- 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)

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 simulatorTimed mode
A shuffled deck with a countdown that mirrors the real exam. Your score is saved to your attempt history.
Open in the simulatorFlashcards
Question on the front, answer on the back. Good for the last week before the exam.
Open in the simulator