Oracle Database 12c: Advanced PL/SQL (1Z0-148)
Oracle Database 12c advanced PL/SQL exam prep covering collections, bulk operations, advanced packages, advanced triggers, performance tuning, object types, and LOBs. Includes 73+ practice questions with explanations, a 120-minute exam format, and a 60% passing score.
JR Academy Membership
Unlock all certifications, courses & tools at a fraction of the cost
- All certification exam prep included
- Course discounts up to 50%
- AI tools & Chrome extensions
- Priority 1-on-1 coaching
What this certification covers
This page is structured for quick scanning first: exam format, fit, prep time, and the actual study scope.
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.
You will work with
After preparation
- 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
Exam details
Who should take it
Good fit
- 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
Study preparation
With hands-on AWS
From scratch
Daily pace
Learning path preview
7 chaptersCertification comparison
| Oracle 1Z0-148 | Oracle 1Z0-071 | Oracle 1Z0-078 | |
|---|---|---|---|
| Provider | Oracle | Oracle | Oracle |
| Level | 专业级 | 助理级 | 专业级 |
| Fee | $245 | $245 | $245 |
| Duration | 120 min | 120 min | 120 min |
| Question count | 70 | 73 | 70 |
| Validity | 0 yrs | 0 yrs | 0 yrs |
Study tips and common mistakes
70 题 120 分钟，平均每题 2 分钟，合理分配时间
及格分 60/100，不确定的题先标记跳过，回头再做
排除法非常有用 — 先排掉明显错误的选项，剩下的再分析
多选题会告诉你选几个，仔细看题目要求
没有读完所有选项就选答案 — 题目经常有"最佳"答案和"正确但不最佳"的干扰项
备考只刷题不理解原理 — 考试场景题需要理解底层概念
忽略时间管理 — 在难题上卡太久，导致后面简单题没时间做
FAQ
Frequently Asked Questions
If you plan to take Oracle 1Z0-148, start with real practice.
73+ questions, chapter-by-chapter learning, mock exams, wrong-question review, and AI tutor support live in the exam page.
Go to exam prepFrom $39 · 2 free chapters