Understand the certification
Certification Overview
Oracle Database 12c: Advanced PL/SQL (1Z0-148) is an Oracle certification exam for people who already know the basics and want to go deeper. It focuses on higher-level PL/SQL work: collection types, bulk processing, advanced package design, advanced triggers, compiler behaviour, performance tuning, object types, and LOB handling.
Exam Information
- Exam code: 1Z0-148
- Exam length: 120 minutes
- Number of questions: about 70
- Passing score: 60%
- Exam fee: $245 USD
Who Is This For
This certification is aimed at Oracle developers and database professionals who already work with PL/SQL and want to prove they can build faster, cleaner, and more maintainable database code.
Exam at a glance
- Exam code
- 1Z0-148
- 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-148 exam with a focused study path
- Use advanced PL/SQL features with more confidence and less guesswork
- Write code that is easier to tune, extend, and maintain
- Strengthen your profile for Oracle development and database engineering roles
Who this is for
- Oracle developers who already use PL/SQL in real systems
- Database professionals moving beyond the basic PL/SQL exam
- IT staff who need deeper Oracle database programming skills
- Technical engineers who want to improve PL/SQL performance and design
Before you start
- You should already know standard PL/SQL blocks, cursors, and procedures
- Hands-on Oracle database development experience is recommended
- 1Z0-144 or equivalent PL/SQL knowledge is the right starting point
Your learning path
7 chapters
Plan your preparation
- Learning hours
- 36h
- With relevant experience
- 8-10 weeks
- Starting from scratch
- 12-16 weeks
- Daily study
- 1-2h
Included in your preparation
- 35 practice questions focused on advanced PL/SQL skills
- Coverage of collections, bulk operations, advanced packages, and advanced triggers
- Performance tuning topics such as profiling, result cache, and native compilation
- Object types and LOB management explained in practical terms
- Mock exam built around the official 70-question, 120-minute format
Preparation tips
- 70 题 120 分钟，平均每题 2 分钟，合理分配时间
- 及格分 60/100，不确定的题先标记跳过，回头再做
- 排除法非常有用 — 先排掉明显错误的选项，剩下的再分析
- 多选题会告诉你选几个，仔细看题目要求
Common mistakes
- 没有读完所有选项就选答案 — 题目经常有"最佳"答案和"正确但不最佳"的干扰项
- 备考只刷题不理解原理 — 考试场景题需要理解底层概念
- 忽略时间管理 — 在难题上卡太久，导致后面简单题没时间做
Before you register
How difficult is the 1Z0-148 exam?
The 1Z0-148 exam contains approximately 70 questions with a 120-minute time limit, requiring a passing score of 60%. It is recommended to study systematically and practice with a large number of questions.
What is the exam fee and validity period?
The 1Z0-148 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 $39