ExamDumpster

1Z0-149

Oracle Database Program with 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
Try the free samples first
Oracle logo
Total questions
320
Free samples
–
Versions
2
Updated
Jan 2026

Exam simulator

Practice 1Z0-149 in the simulator.

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

At a glance

1Z0-149, by the numbers.

Official specifications published by Oracle.

Duration
90 min
Questions
65
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-149.

1Z0-149 · Oracle · Oracle Database 19c

What is 1Z0-149?

1Z0-149 tests whether you can write and manage PL/SQL programs on Oracle Database 19c. Passing it earns Oracle's PL/SQL Developer Certified Professional title. Most candidates are database developers who put business logic inside the database. PL/SQL is Oracle's own language that adds variables, loops and error handling to SQL. The exam asks you to build procedures, functions, packages and triggers, and to handle the errors they raise. For example, you might write a cursor loop that updates each order and logs any row that fails. Questions in this practice test cover control structures, cursors, exceptions and packages.

What you'll practise

  • Declare variables and write IF, CASE and loop structures.
  • Hold related data in records and collections.
  • Open, fetch from and close explicit cursors, including cursors with parameters.
  • Catch predefined and user-defined exceptions and report them clearly.
  • Build procedures, functions and packages with public and private parts.
  • Write compound, DDL and event triggers, and track dependencies between objects.

Requirements

  • Required: pass 1Z0-071, Oracle Database SQL, or hold an equivalent SQL certification.
  • Recommended: Oracle's Database Program with PL/SQL training.
  • Recommended: hands-on experience writing PL/SQL programs.

Who it's for

  • Database developers who write stored procedures and triggers in Oracle.
  • SQL developers who want to add programming logic to their database work.
  • DBAs who review or maintain PL/SQL code.

Exam details

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

Duration
90 min
Questions
65
Passing score
66%
Level
Professional
Question types
multiple_choice

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