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

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.
What does 1Z0-149 cover?
18 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-149 earns the Oracle Database PL/SQL Developer Certified Professional in the Database Development track.
How to study for this exam?
Use the 1Z0-149 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
- ACTIVE
- Last content update
- Nov 1, 2025
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