SQLMentor // cert practice
← All certifications
// 1Z0-149 practice

Oracle Database Program with PL/SQL (1Z0-149)

Full-length timed practice exams modelled on the Oracle Database Program with PL/SQL (1Z0-149) certification. Each set has 65 questions and a 90-minute window. Three difficulty sets — Basic, Medium, and Advanced — so you can build progressively.

65questions per exam
90minute timer (auto-submit)
60%passing score
3difficulty sets

About this certification

The Oracle Database Program with PL/SQL (1Z0-149) is Oracle's PL/SQL developer certification. It validates that you can design, build, and maintain procedural code inside Oracle — including stored procedures, functions, packages, triggers, cursors, and Oracle's built-in packages. The natural next step for developers who already hold the 1Z0-071 SQL certification.

Register on Oracle University ↗

Exam format

  • Questions: 65 multiple choice
  • Duration: 90 min (≈ 1 min 23 s / question)
  • Pass mark: 60%
  • Delivery: Pearson VUE or Oracle Online Proctoring
  • Cost: US$245 (varies by region)
  • Prerequisite: 1Z0-071 SQL knowledge assumed
Topics covered & study plan

Topics covered

PL/SQL block structure, variables, control structures, cursors (implicit, explicit, FOR loop, REF cursors), stored procedures, functions, packages (overloading, forward declarations), triggers (DML, INSTEAD OF, compound, system), exception handling (PRAGMA EXCEPTION_INIT, SQLCODE/SQLERRM), bulk operations (BULK COLLECT, FORALL), dynamic SQL (EXECUTE IMMEDIATE), collections, and Oracle built-in packages (DBMS_OUTPUT, UTL_FILE, DBMS_SCHEDULER).

Recommended study plan

  1. Work through the PL/SQL tutorial in order.
  2. Type every example in sqlplus — don't copy-paste.
  3. Build a real project: a package with 5 procedures, a trigger, and a function.
  4. Take Practice Set 1 under timing; review every wrong answer.
  5. Cycle through Sets 2 and 3 over a week.
  6. You're ready when scoring ≥ 70% on cold practice sets.

Pick a set to begin

Loading exam sets…
How the exam works
  • The 90-minute timer starts the moment you click Start exam.
  • Use the question grid to jump between questions; flag any you want to revisit.
  • Click Submit exam at any time to finish early; if the timer reaches zero, the exam auto-submits.
  • After submission you'll see your score, pass/fail status, weak topics, and per-question feedback.
  • Start with Basic to build PL/SQL block fundamentals, then progress to Advanced.
  • Your progress is kept in the browser only — refreshing during an exam will reset it.

Frequently asked questions — 1Z0-149

How many questions are on the 1Z0-149 exam?
The 1Z0-149 exam contains 65 multiple-choice questions to be answered in 90 minutes. SQLMentor's free practice sets mirror that format so the timing feels familiar on exam day.
What is the passing score for 1Z0-149?
The official passing score for the 1Z0-149 exam is 60%. Each SQLMentor practice set is scored against that same threshold and shows a clear PASS or FAIL on the results screen.
How long should I prepare for the 1Z0-149 exam?
Most candidates prepare for 4 to 8 weeks with consistent daily study. We recommend reading through the SQLMentor tutorials first, then running timed practice sets in the final two weeks until you score above 60% consistently.
Is the SQLMentor 1Z0-149 practice exam free?
Yes. Every 1Z0-149 practice set on SQLMentor is 100% free with no sign-up, no email gate and no paywall. Your progress is saved locally in your browser.
What topics does 1Z0-149 cover?
PL/SQL blocks, cursors, exception handling, packages, procedures, functions, triggers, dynamic SQL, BULK COLLECT/FORALL, autonomous transactions and PL/SQL performance tuning. The SQLMentor sets are organised so each set samples across all of these areas to give you a realistic mix on every attempt.