1z0-148
Oracle Database 12c: Advanced PL/SQL practice test
320 Oracle 1Z0-149 and 1z0-148 practice questions with explanations, in study, timed and flashcard modes.
Full access
$99
- All 320 questions across 1Z0-149 and 1z0-148, with explanations
- Study, timed and flashcard modes
- Progress saved, resume any time
- Total questions
- 320
- Free samples
- –
- Versions
- 2
- Updated
- Jan 2026
1z0-148 is retired as of Dec 31, 2019. It is replaced by 1Z0-149. The question bank stays available for reference.
Exam simulator
Practice 1z0-148 in the simulator.
Study, timed and flashcard modes. Answers and explanations as you go, and your progress saves.
At a glance
1z0-148, by the numbers.
Official specifications published by Oracle.
- Duration
- 110 min
- Questions
- 60-70
- Passing score
- 66%
- Exam fee
- $245
- In the bank
- 1Z0-149 (246), 1z0-148 (74)

Exam guide
Everything about 1z0-148.
1z0-148 · Oracle · v1.0
What is 1z0-148?
1Z0-148 tested advanced PL/SQL programming on Oracle Database 12c until Oracle retired it at the end of 2019. Developers who want the same PL/SQL Developer Certified Professional title now take 1Z0-149. Its candidates were database developers who already wrote PL/SQL every day. The exam went past the basics into speed and safety. You had to guard code against SQL injection, an attack that slips harmful SQL into a program's input. A typical task was rewriting a slow row-by-row loop to use bulk processing. This practice test still covers the retired objectives, from result caching to calls out to Java and C.
What you'll practise
- Cache function results with the PL/SQL result cache so repeated calls run faster.
- Protect PL/SQL code from SQL injection with bind variables and input checks.
- Speed up code with bulk processing and subprogram inlining.
- Store complex data in collections and large objects (LOBs).
- Design cursors, including cursor variables, for flexible queries.
- Call Java methods and external C procedures from PL/SQL.
Requirements
- None now: Oracle retired the exam, so it can no longer be booked.
- Recommended for review: solid Oracle SQL and PL/SQL basics.
- Recommended for review: experience with Oracle Database 11g or 12c.
- Recommended for review: Oracle's Database 12c: Program with PL/SQL course.
Who it's for
- Database developers who write PL/SQL and want to review advanced topics.
- Developers who still maintain PL/SQL code on Oracle Database 11g or 12c.
- Learners who want to compare the old advanced syllabus with 1Z0-149.
Exam details
Published by Oracle, plus what is in our question bank.
What does 1z0-148 cover?
8 weighted domains. Open a domain for its topics, and a topic for its objectives. Practice questions are tagged to these.
How do I earn this certification?
Passing 1z0-148 earns the Oracle Database PL/SQL Developer Certified Professional in the Database Development track.
How to study for this exam?
Use the 1z0-148 practice test alongside the official material below.
What's changed on this exam?
Status and coverage changes that affect what you should study.
- Current status
- RETIRED→ 1Z0-149
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