Understand the certification
Certification Overview
Oracle Database 11g: Program with PL/SQL (1Z0-144) is an Oracle certification exam that checks whether you can write and maintain PL/SQL code with confidence. It covers the core skills that matter in day-to-day database development: block structure, variables, cursors, exceptions, subprograms, packages, triggers, and dynamic SQL.
Exam Information
- Exam code: 1Z0-144
- Exam length: 120 minutes
- Number of questions: about 70
- Passing score: 63%
- Exam fee: $245 USD
Who Is This For
This certification is for Oracle developers, database professionals, and technical staff who need a solid PL/SQL foundation and want an Oracle-recognised credential for database programming work.
Exam at a glance
- Exam code
- 1Z0-144
- Provider
- Oracle
- Format
- Single choice / Multiple select
- Language
- English / 日本語
- Validity
- No expiry
- Exam fee
- $245
Skills in focus
Learning outcomes
- Prepare for the Oracle 1Z0-144 certification exam with a structured path
- Write PL/SQL blocks, subprograms, packages, and triggers with more confidence
- Understand how to use cursors, exceptions, and dynamic SQL in Oracle 11g
- Improve your fit for Oracle database development and support roles
Who this is for
- Oracle developers writing PL/SQL in production systems
- Database administrators who need stronger PL/SQL skills
- IT professionals preparing for Oracle database programming roles
- Cloud and operations engineers who work with Oracle-backed applications
Before you start
- Basic Oracle database knowledge is helpful
- Some hands-on programming or database experience is recommended
- You should understand basic SQL and database concepts before starting
Your learning path
7 chapters
Plan your preparation
- Learning hours
- 36h
- With relevant experience
- 4-6 weeks
- Starting from scratch
- 8-10 weeks
- Daily study
- 1-2h
Included in your preparation
- 29 practice questions focused on the actual PL/SQL exam topics
- Coverage of cursors, exceptions, procedures, packages, triggers, and dynamic SQL
- Mock exam built around the 70-question, 120-minute format
- Clear explanations that show how PL/SQL features behave in practice
- Study flow that moves from fundamentals to exam-style application
Preparation tips
- 70 题 120 分钟，平均每题 2 分钟，合理分配时间
- 及格分 63/100，不确定的题先标记跳过，回头再做
- 排除法非常有用 — 先排掉明显错误的选项，剩下的再分析
- 多选题会告诉你选几个，仔细看题目要求
Common mistakes
- 没有读完所有选项就选答案 — 题目经常有"最佳"答案和"正确但不最佳"的干扰项
- 备考只刷题不理解原理 — 考试场景题需要理解底层概念
- 忽略时间管理 — 在难题上卡太久，导致后面简单题没时间做
Before you register
How difficult is the 1Z0-144 exam?
The 1Z0-144 exam contains approximately 70 questions with a 120-minute time limit, requiring a passing score of 63%. It is recommended to study systematically and practice with a large number of questions.
What is the exam fee and validity period?
The 1Z0-144 exam fee is $245 USD. Oracle certifications typically do not have a fixed expiration date, but it is recommended to update regularly to keep your skills current.
How do I register for the exam?
You can register through the Oracle University website or Pearson VUE testing centers. Both online proctored and in-person testing center options are available.
Learner experiences
Loading reviews…
Start with the first chapter.
2 free chapters · Full preparation from $29