ExamDumpster

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. 12 sample questions are free.

Full access

$99

  • All 320 questions across 1Z0-149 and 1z0-148, with explanations
  • Study, timed and flashcard modes
  • Progress saved, resume any time
Try the free samples first
Oracle logo
Total questions
320
Free samples
12
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)
Open the full exam guide

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.

Duration
110 min
Questions
60-70
Passing score
66%
Level
Professional
Question types
multiple_choice, multiple_response

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