Oracle credentialCER0450Active

Oracle Database PL/SQL Developer Certified Professional

Exam code: 1Z0-149Oracle Database PL/SQLOracle Database
Official provider page
Oracle
Credential
Certification
Exam duration
90 min

credential overview

About this credential

Validates PL/SQL development skills for Oracle Database, including variables, executable statements, SQL in PL/SQL, control structures, cursors, exceptions, subprograms, procedures, functions, packages, dynamic SQL, triggers, compiler features, code management, and dependencies.

Assessment

Exam details

1Z0-149

Oracle Database PL/SQL Developer Certified Professional

Required exam
Duration
90 min
Format
Proctored exam
Delivery
Oracle University
Passing score
66%
Proctored
Yes
View exam details

Exam blueprint

Skills measured

Skills measured18 topics
  • Declaring PL/SQL Variables
  • Writing Executable Statements
  • Writing SQL in PL/SQL
  • Writing Control Structures
  • Working with Composite Data Types
  • Using Explicit Cursors
  • Handling Exceptions
  • Using PL/SQL Subprograms
  • Creating Procedures and Using Parameters
  • Creating Functions
  • Creating Packages
  • Working with Packages
  • Using Dynamic SQL
  • Design Considerations for PL/SQL Code
  • Creating Compound, DDL, and Event Database Triggers
  • Using the PL/SQL Compiler
  • Managing PL/SQL Code
  • Managing Dependencies

Before you certify

Requirements and recommended experience

Certification requirement

Oracle Database SQL Certified Associate

Certification requirement

Oracle AI Database SQL Certified Associate

Certification requirement

Oracle Database 12c: SQL Fundamentals | 1Z0-061 (Retired)

Certification requirement

Oracle Database 11g: Program with PL/SQL | 1Z0-144 (Retired)

Certification requirement

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

Reference
Recommended experience

A combination of Oracle training and hands-on experience attained via labs and/or field experience provides the best preparation for passing the exam.

Preparation

Official learning resources

Training course

Earn the Oracle Database PL/SQL Developer Certified Professional Credential

Credential lifecycle

Status, validity and renewal

Credential lifecycle

Corporate certification enablement

Turn this pathway into a team capability plan

We can align the learning path, instructor support, practice environment and delivery schedule to your team’s roles and certification target.