Oracle PL/SQL Developer Certified Professional

Exam format

Oracle logo

Oracle PL/SQL Developer Certified Professional Exam Format

1Z0-149

Everything the official exam blueprint specifies: question count, time limit, scoring and the weight each domain carries. The Oracle PL/ Developer Certified Professional certification validates a candidate's ability to design, implement, and optimize complex procedural logic within the Oracle Database ecosystem. As businesses move toward more data-intensive applications, the ability to offload logic to the database layer becomes critical. This exam goes beyond basic syntax, requiring candidates to demonstrate a profound understanding of how to minimize context switching between the and PL/ engines, how to leverage collections for high-speed data manipulation, and how to architect modular, reusable code using sophisticated package structures. It tests the developer's ability to handle complex error scenarios and ensures they can maintain high-performance database environments through advanced tuning and debugging methodologies. Candidates must demonstrate mastery over the entire development lifecycle, from initial block design to the final optimization of bulk processing operations.

65 questions
90 min
66% to pass
7 domains

Exam facts at a glance

What we know about this exam, and where the information comes from.

SpecificationValue
Questions65
Time limit90 minutes (83s per question)
Passing score66%
Domains7
LevelProfessional
Question bank here65 questions
SourceCertilum's own record — the vendor does not publish this figure

Official domain weights

The percentage of the exam each domain carries. Weight your revision by these numbers, not by what you find hardest.

DomainWeightTopicsPractice Qs
SQL in PL/SQL10%
  • DML and transaction control in PL/SQL
  • SELECT INTO for data retrieval
  • Implicit and explicit data type conversion
7
Code Management10%
  • PL/SQL code management
  • Conditional compilation
  • Code-based access control
  • +1 more
6
Working with Data15%
  • Composite data types - records, INDEX BY tables
  • Explicit cursors and cursor FOR loops
  • Cursor parameters and FOR UPDATE
  • +1 more
10
Exception Handling10%
  • PL/SQL exception handling
  • Predefined and user-defined exceptions
  • Exception propagation
6
PL/SQL Fundamentals15%
  • Declaring PL/SQL variables and data types
  • %TYPE and %ROWTYPE attributes
  • Writing executable statements
  • +3 more
10
Subprograms and Packages25%
  • Stored procedures and functions
  • Package specification and body
  • Overloading and forward declarations
  • +2 more
16
Dynamic SQL and Advanced Topics15%
  • Native Dynamic SQL (NDS)
  • Bulk binding and FORALL
  • Autonomous transactions
  • +3 more
10

The heaviest domain is SQL in PL/SQL at 10%, and that is where lost points cost you the most. Certilum scores you per domain so you can see the difference between a knowledge gap and a formatting problem.

Note from the vendor record: Technology exam under 'Oracle Cloud Infrastructure and Technology Exams' at USD 245 per single attempt (6 months). Base Exam Price $245 / Delta $125. (Oracle PL/SQL Developer) Local pricing by region via Pearson VUE. Official exam page

More about the Oracle PL/SQL Developer Certified Professional exam

Explore the rest of this page series: format, cost, difficulty, requirements and how to prepare.

Exam costPass rateWho can take itStudy plan

Related certifications

Explore other certifications in the same category and see how they stack up.

AWS Certified Developer – Associate
AWS Certified Developer – Associate
Amazon Web ServicesAmazon Web Services
Java SE 17 Developer
Java SE 17 Developer
OracleOracle
Java SE 21 Developer
Java SE 21 Developer
OracleOracle
MongoDB Certified Associate Developer
MongoDB Certified Associate Developer
MongoDBMongoDB
Oracle Cloud Infrastructure 2026 Developer Professional
Oracle Cloud Infrastructure 2026 Developer Professional
OracleOracle

Frequently asked questions

Everything you need to know about the Oracle PL/SQL Developer Certified Professional exam.