Why Study with PlanetCert?
The Latest Questions
Practice questions and exam topics aligned with the current exam objectives.
Detailed Explanations
Go beyond the answer. Master the material with comprehensive learning and professional explanations for every concept.
AI-Powered Insights
Personalized preparation guidance that adapts to your performance and identifies weak spots automatically.
Exam Information
Official specifications published by Oracle
Exam Format
90 min
65
66%
Professional
Registration
$245 USD
Pearson VUE or online proctoring
Validity
Lifetime (no recertification required)
Not required - certification does not expire; Consider pursuing advanced Oracle certifications; Stay updated with Oracle Cloud certifications
1Z0-149 Exam Topics and Domains
1Z0-149 is organized into 18 weighted domains. Expect to work with PL/SQL Compiler, PL/SQL Access Control, PL/SQL Collections, PL/SQL Control Structures, and more.
1
Declaring PL/SQL Variables
8%
Variable Identifiers and Declarations
Valid and Invalid IdentifiersVariable Declaration and InitializationData Types and Attributes
- Recognize valid and invalid identifiers
- Declare and initialize variables correctly
- Use bind variables effectively
- Apply %TYPE and %ROWTYPE attributes appropriately
2
Writing Executable Statements
10%
PL/SQL Block Structure
Lexical UnitsBuilt-in Functions and SequencesType ConversionsNested Blocks and Code Readability
- Identify lexical units in PL/SQL blocks
- Use built-in SQL functions and sequences
- Apply implicit and explicit conversions correctly
- Write readable code with proper structure and indentation
3
Writing SQL in PL/SQL
8%
DML and Transaction Control
DML in PL/SQLTransaction Control
- Create PL/SQL blocks using DML statements
- Use transaction control statements appropriately
- Handle the INTO clause correctly in SELECT statements
4
Writing Control Structures
12%
Conditional Control
IF StatementsCASE Statements and Expressions
- Identify uses and types of control structures
- Implement IF statements correctly
- Use CASE statements and expressions appropriately
Loop Structures
Loop TypesLoop Control
- Construct and identify different loop types
- Use EXIT and CONTINUE statements appropriately
- Control loop execution effectively
5
Working with Composite Data Types
12%
Records
User-Defined Records%ROWTYPE Records
- Create user-defined PL/SQL records
- Use %ROWTYPE attribute for record creation
- Initialize and manipulate records
Collections
INDEX BY TablesCollections of RecordsCollection Methods
- Create INDEX BY tables and collections of records
- Understand differences among records, collections, and collections of records
- Initialize collections and records properly
- Use collection methods effectively
6
Using Explicit Cursors
12%
Cursor Fundamentals
Implicit vs Explicit CursorsCursor Operations
- Distinguish between implicit and explicit cursors
- Use SQL cursor attributes
- Declare and control explicit cursors
- Use simple loops and cursor FOR loops to fetch data
Advanced Cursor Features
Parameterized CursorsCursors for Update
- Declare and use cursors with parameters
- Lock rows with FOR UPDATE clause
- Reference current row with WHERE CURRENT OF clause
7
Handling Exceptions
10%
Exception Types and Handling
Predefined ExceptionsUser-Defined ExceptionsException Propagation
- Define PL/SQL exceptions
- Recognize unhandled exceptions
- Handle different types of exceptions
- Propagate exceptions appropriately
8
Using PL/SQL Subprograms
6%
Subprogram Basics
Anonymous Blocks vs SubprogramsSimple Procedures
- Differentiate between anonymous blocks and subprograms
- Create simple procedures
- Invoke procedures from anonymous blocks
- Identify benefits of using subprograms
9
Creating Procedures and Using Parameters
8%
Procedures with Parameters
Parameter ModesNamed NotationProcedure Management
- Create procedures with parameters
- Use named notation for procedure calls
- Work with procedures (create, invoke, remove)
- Handle exceptions in procedures
- Display procedure information
10
Creating Functions
6%
Function Implementation
Functions vs ProceduresFunction Operations
- Differentiate between procedures and functions
- Describe uses of functions
- Work with functions (create, invoke, remove)
11
Creating Packages
8%
Package Structure
Package ComponentsPackage Features
- Identify benefits and components of packages
- Work with packages (create specification and body)
- Invoke package subprograms
- Remove packages
- Display package information
- Overload package subprograms
- Use forward declarations
12
Working with Packages
6%
Package Variables and Access Control
Package Types and VariablesACCESSIBLE BY Clause
- Use package types and variables
- Use packaged constants and functions in SQL
- Use ACCESSIBLE BY to restrict access to package subprograms
13
Using Dynamic SQL
6%
Native Dynamic SQL
Dynamic SQL ExecutionSQL Statement Execution Flow
- Describe execution flow of SQL statements
- Use Native Dynamic SQL (NDS)
- Bind PL/SQL types in SQL statements
14
Design Considerations for PL/SQL Code
8%
Code Quality and Performance
Standards and Local SubprogramsPrivileges and Autonomous TransactionsPerformance Optimization
- Create standard constants and exceptions
- Write and call local subprograms
- Control run-time privileges of subprograms
- Perform autonomous transactions
- Use NOCOPY, PARALLEL_ENABLE, and DETERMINISTIC
- Use bulk binding and RETURNING clause with DML
15
Creating Compound, DDL, and Event Database Triggers
6%
Advanced Trigger Types
DDL TriggersSystem Event TriggersTrigger Types and Uses
- Create triggers on DDL statements
- Create triggers on system events
- Describe different types of triggers and their uses
16
Using the PL/SQL Compiler
4%
Compiler Features
Compiler Parameters and Warnings
- Describe PL/SQL compiler and features
- Use PL/SQL compiler initialization parameters
- Use PL/SQL compile-time warnings
17
Managing PL/SQL Code
4%
Code Management Features
Conditional CompilationAccess Control and Deprecation
- Describe and use conditional compilation
- Implement code-based access control
- Whitelist code access with ACCESSIBLE BY
- Mark code as deprecated
18
Managing Dependencies
2%
Dependency Tracking
Procedural Dependencies
- Track and manage procedural dependencies
- Identify dependencies using data dictionary
- Handle invalid objects due to dependency changes
How do I earn this certification?
Passing 1Z0-149 earns the Oracle Database PL/SQL Developer Certified Professional certification. It sits in the Database Development track.
Current Level Exams
Next Level Options
Advanced Oracle Database Certifications Complement PL/SQL skills with DBA or cloud expertise
Alternative Paths
- 1Z0-082 - Oracle Database Administration IFor developers wanting to expand into database administration
- 1Z0-083 - Oracle Database Administration IIAdvanced DBA certification complementing development skills
- 1Z0-997-25 - Oracle Cloud Infrastructure Architect ProfessionalFor developers moving to cloud-based Oracle solutions
- 1Z0-1085-25 - Oracle Cloud Infrastructure 2025 Foundations AssociateEntry point to Oracle Cloud certifications
Practice with Precision
The PlanetCert Simulator mirrors the real exam environment with authentic questions and timed pressure.
How to study for this exam?
The most effective way to prepare for 1Z0-149 is by using the PlanetCert Simulator to practice questions and review detailed explanations.
What's changed on this exam?
Current Status
- ACTIVE
- Last content update: 2025-11-01
Updates
- Oracle Database 19c 19c 1Z0-149 validates for Oracle Database 19c - current long-term support release • Release date: 2019-02-01
- Oracle Database 21c 21c Innovation release - PL/SQL concepts from 1Z0-149 remain applicable • Release date: 2021-08-01
- Oracle Database 23ai 23ai Latest innovation release - builds on PL/SQL foundation tested in 1Z0-149 • Release date: 2023-05-01
- Oracle Autonomous Database Current Cloud service that supports PL/SQL - 1Z0-149 skills directly applicable • Release date: Ongoing
Who should take this exam?
1Z0-071 - Oracle Database SQL (or equivalent SQL certification)
- Oracle Database SQL knowledge
- Basic understanding of database concepts
- Completion of Oracle Database Program with PL/SQL training
- Hands-on experience with PL/SQL programming