Oracle Database PL/SQL Developer Certified Professional

Practise Oracle PL/SQL (1Z0-149): blocks, cursors, exceptions, procedures, functions, packages and triggers

Free previewStudy guide

6 practice tests390 questions90 min per test66% to pass

What you’ll learn

  • PL/SQL Language Fundamentals (25%)
  • Advanced PL/SQL Programming Techniques (30%)
  • Performance Tuning and Optimization (25%)
  • Database Integration and Security (20%)

Practice tests

Exam-style questions with explanations and timed simulation.

6 tests

Study guide ebook

An EPUB ebook of this pack's exam-style questions, each with the correct answer and an explanation. It opens in Apple Books, Google Play Books and most ebook readers.

About this exam

Oracle Database PL/SQL Developer Certified Professional (exam 1Z0-149, Program with PL/SQL) validates the skills to build server-side applications in Oracle Database with PL/SQL. It covers PL/SQL basics (declaring variables and writing executable statements), SQL in PL/SQL, control structures, composite data types (records and collections), explicit cursors, exception handling, stored procedures and functions, packages, dependencies, triggers, compiler features and dynamic SQL. Oracle Database SQL knowledge (1Z0-071) is expected. The multiple-choice exam is taken online or at a Pearson VUE test centre.

6Practice tests
390Questions
90 minDuration
66%Passing score

Requirements

  • You don't need another certification first, but some hands-on time with data modelling, SQL, data quality and reporting will help a lot.
  • A laptop, tablet or phone with internet access.
  • Optional: Oracle's own exam guide or training, to study alongside the tests.

Description

What the Oracle Database PL/SQL Developer Certified Professional exam is about

Oracle Database PL/SQL Developer Certified Professional checks whether you can actually handle PL/SQL Language Fundamentals (25%), Advanced PL/SQL Programming Techniques (30%) and Performance Tuning and Optimization (25%), among other things, not just recognise the terms. These tests let you find that out before exam day.

The pack has 390 questions split into 6 tests of 65. Tests are timed at 90 minutes with a 66% pass mark. That way your practice score actually means something.

Inside these Oracle Database PL/SQL Developer Certified Professional practice tests

  • 6 timed tests with 390 questions (65 each)
  • Every question comes with an explanation of the correct answer and the traps in the wrong ones
  • Instant feedback in practice mode, and a timed exam mode for a proper dress rehearsal
  • Your scores and past attempts are saved, so you can see which topics keep tripping you up
  • The first test is free, so you can check the question style first
  • Pay once and keep it. It works on the website and in our mobile app with the same login

Oracle Database PL/SQL Developer Certified Professional exam domains

You'll be tested on all 4 domains in the official outline:

  • PL/SQL Language Fundamentals (25%)
  • Advanced PL/SQL Programming Techniques (30%)
  • Performance Tuning and Optimization (25%)
  • Database Integration and Security (20%)

How we suggest you study

  • Use practice mode first, so you see the answer and explanation straight away
  • Note which domains cost you the most marks
  • Work on those, then move on to the next test
  • Do your last few tests in exam mode with the full 90 minutes, without notes
  • If you can pass every test with room to spare (80% or so, not just 66%), you're probably ready to book

Why this helps

Data exams mix concepts with practical choices: how to model something, how to clean it, and who should own it. Most questions here are practical problems about preparing, governing, analysing and presenting data, which is far closer to the real exam than flashcards or notes.

Please note

We write our own questions based on the published exam objectives. They aren't real exam questions, and we don't use leaked or "dump" material. Certification Prep is independent and isn't affiliated with or endorsed by Oracle. Trademarks belong to their owners.

Who these practice tests are for

  • Anyone planning to sit the Oracle Database PL/SQL Developer Certified Professional exam
  • Data analysts, data engineers, BI developers and governance teams
  • People who've finished a course or book and want to check they're actually ready
  • Anyone who failed a previous attempt and wants to find out what went wrong

Frequently asked questions

How many Oracle Database PL/SQL Developer Certified Professional practice questions are there?

390 questions across 6 tests. Each one has a written explanation.

Are these real Oracle Database PL/SQL Developer Certified Professional exam questions?

No. We write original questions based on the official exam objectives. We don't use leaked exam content, and you wouldn't want us to: memorising answers doesn't help when the real questions are worded differently.

What score should I get before booking the exam?

The tests use a 66% pass mark. We'd suggest booking once you pass all of them with a margin, around 80% if you can.

Is there a free trial?

Practice Test 1 is free, explanations included. You don't need to buy anything to try it.

Can I use it on my phone, and how long do I have access?

It's a one-off payment with no expiry. Sign in with the same account on the website or in our mobile app and your purchase and scores are there.

What topics does the Oracle Database PL/SQL Developer Certified Professional exam cover?

The tests cover PL/SQL Language Fundamentals (25%), Advanced PL/SQL Programming Techniques (30%), Performance Tuning and Optimization (25%) and Database Integration and Security (20%).

CERTIFICATION PACK

Checkout

Log in to your Certification Prep account

Don't have an account?

Please confirm

Share this certification pack

Or share on