匠人学院 JR Academy学AI来匠人
匠人学院 JR Academy学AI来匠人

Follow Us

linkedinfacebooktwitterinstagramyoutube

We Accept

/image/layout/pay-paypal.png/image/layout/pay-visa.png/image/layout/pay-master-card.png/image/layout/pay-airwallex.png/image/layout/pay-alipay.png
EN

Company

About UsMetaverse ClassroomNews & BlogJR CareersBecome a MentorOur MentorsContact UsJR Store J3.Club

Resources

Job ReferralsEvents1-on-1 TutoringIndustry WhitepapersOnline LearningInterview CenterShare Interview ExperienceInternshipMembership

AI Tools

AI ToolboxCert MasterJob HunterUniMate AI

AI Learning Paths

All Learning PathsAI EngineerContext EngineeringVibe CodingPrompt MasterAI BuilderAI Product ManagerPython Basics

AI in Practice

AI ProductivityAI Data AnalysisAI FinanceAI Content CreationAI Image CreationFrontend DevelopmentHermes AgentOpenClaw Local Agent

University Resources

University of MelbourneUniversity of QueenslandUNSW SydneyUniversity of SydneyMonash UniversityUniversity of AdelaideRMITQUTUTS

Kids AI Education

Airbotix — AI Coding for KidsAU Family Resource HubNAPLAN Report GuideMy School Data GuideSydney Private School Fees 2026Kids Coding Programs

Immigration Services

Australia ImmigrationSkilled Visa 189/190/491Employer Sponsored 482/186/494Business Visa 188/888UK ImmigrationUS ImmigrationCanada Immigration

Enterprise

P3 Career IncubatorEnterprise (EN)Corporate TrainingInternship PartnershipRecruitment PartnershipApply for Partnership

Job Application Agent

Job Application ServiceJob MonitoringLinkedIn ManagementLinkedIn NetworkingLearn about P3

Support

FAQsTerms & ConditionsPrivacy PolicyCancellation & Refund PolicySite map

Top Categories

Web Full-Stack BootcampDevOps BootcampData Engineering BootcampData Analysis BootcampCoding for BeginnersBusiness Analyst InternshipAlgorithm Bootcamp

Career Services

BA & PM InternshipData Science InternshipData Analysis InternshipMarketing InternshipResume ReviewInterview CoachingVIP Mentor Guidance

Addresses

Level 10b, 144 Edward Street, Brisbane CBD(Headquarter)
Level 2, 171 La Trobe St, Melbourne VIC 3000
45A13, Block B, Oriental Hope Tianxiang Plaza, 500 Tianfu Avenue Middle Section, Wuhou District, Chengdu, Sichuan, China
Business Hub, 155 Waymouth St, Adelaide SA 5000

Contact

hello@jiangren.com.au0421-672-555

Disclaimer

footer-disclaimerfooter-disclaimer

JR Academy acknowledges Traditional Owners of Country throughout Australia and recognises the continuing connection to lands, waters and communities. We pay our respect to Aboriginal and Torres Strait Islander cultures; and to Elders past and present. Aboriginal and Torres Strait Islander peoples should be aware that this website may contain images or names of people who have since passed away.

All content on the JR Academy website, including course materials, logos, and information provided, is protected under Australian intellectual property laws. Unauthorized use, sale, distribution, reproduction, or modification is strictly prohibited. Violations may result in legal action. By accessing our website, you agree to respect our intellectual property. JR Academy Pty Ltd reserves all rights, including patents, trademarks, and copyrights. Any infringement will be subject to legal prosecution. View Terms of Service

© 2017-2026 JR Academy Pty Ltd. All rights reserved.

ABN 26621887572

Certifications/Oracle/Oracle 1Z0-078
Oracle专业级💾 数据库

Oracle Database 19c: PL/SQL Developer Certified Professional (1Z0-078)

Oracle PL/SQL certification covering block structure, cursors, exceptions, stored procedures, functions, packages, triggers, dynamic SQL, and collections. Includes 73+ practice questions and a 120-minute exam format with a 63% passing score.

Start PracticeBrowse Learning Path
70
Questions per exam
73
Question bank total
120m
Exam Duration
63/100
Passing Score
$245
Exam Fee

At a glance

73 questions
Best forOracle developers writing PL/SQL in application projects, Database engineers who need reusable procedural code
Prep pace4-6 weeks with experience
Course pack7 chapters · 36 hours
Learner signal0 enrolled · 0/5
Exam Guide
?
Bottom line · It depends

1Z0-078 是 Oracle 19c PL/SQL OCP 认证 — 基于最新长期支持版 19c，比旧版 1Z0-149 更贴近当前市场。如果要考 PL/SQL OCP，优先选 1Z0-078。

What this certification covers

This page is structured for quick scanning first: exam format, fit, prep time, and the actual study scope.

Oracle Database 19c: PL/SQL Developer Certified Professional (1Z0-078) 是基于 Oracle 19c（当前最广泛部署的 Oracle 版本，长期支持至 2027 年）的 PL/SQL 开发 OCP 考试。70 题 / 120 分钟，及格线 63%（约 44 题），费用 $245 USD。

和旧版 1Z0-149 的主要区别：1Z0-078 新增了 Oracle 19c 的 PL/SQL 增强特性 — Polymorphic Table Functions（多态表函数，允许函数返回动态列结构）、实时 SQL 监控增强、JSON 处理函数（JSON_TABLE/JSON_VALUE/JSON_QUERY 在 PL/SQL 中的使用）。同时，1Z0-078 更强调实际开发场景 — 性能调优（Bulk Collect/FORALL 批量处理）、安全编码（AUTHID CURRENT_USER vs DEFINER 权限模型、SQL 注入防护）。

Oracle 19c 目前是全球企业级 Oracle 部署量最大的版本（IDC 2024 数据），比 12c 和 21c 都多。银行、电信、政府的核心系统大部分运行在 19c 上。

You will work with

Oracle 技术数据库管理系统架构性能优化故障排除

After preparation

  • Earn the Oracle PL/SQL Developer certification
  • Write PL/SQL code with more confidence and less trial-and-error
  • Use cursors, exceptions, packages, triggers, and collections correctly
  • Build a stronger base for Oracle development and database engineering work

Exam details

Exam Code
1Z0-078
Provider
Oracle
Duration
120 minutes
Question Count
70 questions
Passing Score
63/100
Validity
0 years
Exam Fee
$245 USD
Question Types
Single choice, Multiple select
Languages
English, 日本語
Official Page
Open AWS page

Who should take it

Good fit

  • Oracle developers writing PL/SQL in application projects
  • Database engineers who need reusable procedural code
  • IT professionals preparing for Oracle PL/SQL certification
  • Application teams working directly with Oracle Database logic

Before you start

  • Basic Oracle SQL knowledge is recommended
  • You should be comfortable reading and writing simple PL/SQL blocks
  • Some programming experience will help

Is it worth it? Career value

Salary ranges, target job titles, and the real career impact of holding Oracle 1Z0-078.

澳洲
$100K-145KAUD
美国
$95K-140KUSD
中国
¥220K-400KCNY
PL/SQL DeveloperOracle 19c Database DeveloperERP Technical ConsultantOracle 数据库开发工程师

1Z0-078 相比 1Z0-149 在简历上更有时效性 — 标注 "Oracle 19c" 表明你的技能是当前版本。Oracle 19c 的长期支持至 2027 年（延长支持可到 2030 年），这意味着 19c 相关岗位至少还有 3-5 年需求。

通过 1Z0-078 + 1Z0-071（或 1Z0-082）可以获得 Oracle Database 19c PL/SQL Developer OCP 认证。

不适合的人群：同 1Z0-149 — 不做 Oracle 数据库开发的人不需要考。已经持有 1Z0-149 的人 — 两张证的含金量差异不大，不需要重复考。

Study preparation

With hands-on AWS

4-6 weeks

From scratch

8-12 weeks

Daily pace

1-2 hours/day

Learning path preview

7 chapters
1
1Z0-078 Exam Overview and Study Plan
30 min
2
PL/SQL Basics and Program Structure
60 min
3
Cursors and Exception Handling
70 min
4
Stored Procedures and Functions
80 min
5
Packages and Triggers
90 min
6
Dynamic SQL and Collection Types
100 min
+ 1 more chapters inside the full path

Step-by-step preparation

A concrete week-by-week plan from past test-takers — not generic advice.

1

第一阶段：PL/SQL 核心 + 19c 新特性（3 周）

在 Oracle 19c XE（免费下载）上练习。覆盖所有 1Z0-149 的核心内容（游标/异常/包/触发器），额外学习 19c 新增特性：Polymorphic Table Functions 的创建和使用、JSON_TABLE 在 PL/SQL 块中的应用、DBMS_OUTPUT 的增强。

2

第二阶段：性能优化 + 安全编码（2 周）

Bulk Collect + FORALL 的使用（将逐行处理变为批量处理，性能提升 10-100 倍）。NOCOPY hint 的作用（避免 OUT/IN OUT 参数的值拷贝）。AUTHID CURRENT_USER vs DEFINER 的安全含义（DEFINER 以创建者权限执行，CURRENT_USER 以调用者权限执行）。DBMS_ASSERT 包防止 SQL 注入。

3

第三阶段：动态 SQL + 模考（2 周）

EXECUTE IMMEDIATE 的 USING/INTO/RETURNING INTO 子句。DBMS_SQL 包的完整调用流程（OPEN_CURSOR → PARSE → BIND_VARIABLE → EXECUTE → FETCH_ROWS → CLOSE_CURSOR）。Native Dynamic SQL vs DBMS_SQL 的选型。用题库做 2 次模考，目标稳定 70%+。

Real test-taker experiences

What it actually took for real candidates to pass — prep time, scores, and lessons learned.

19c 新特性的题不多（3-4 道），但 Bulk Collect/FORALL 的题比 1Z0-149 明显多了 — 考了 5 道性能优化相关的场景题。AUTHID CURRENT_USER 的权限模型也出了 2 道。整体比 1Z0-149 更偏实战。

PL/SQL 开发 6 年78%
电信计费系统 · 4 weeks prep

有 1Z0-149 基础后准备 1Z0-078 很快，核心知识点 80% 重叠。19c 新增的 Polymorphic Table Function 考了 1 道，JSON 处理考了 2 道。建议已有 1Z0-149 的人不需要再考 1Z0-078，除非想刷新认证版本。

1Z0-149 持证者，升级到 19c72%
Oracle DBA/Dev · 3 weeks prep

Certification comparison

Oracle 1Z0-078Oracle 1Z0-149Oracle 1Z0-071
ProviderOracleOracleOracle
Level专业级助理级助理级
Fee$245$245$245
Duration120 min120 min120 min
Questions per exam706373
Validity0 yrs0 yrs0 yrs

Study tips and common mistakes

💡

70 题 120 分钟，约 1.7 分钟/题。性能优化场景题需要仔细分析"逐行处理 vs 批量处理"的对比。

💡

JSON 处理题不会很深入，只需要会用 JSON_TABLE 和 JSON_VALUE 从 JSON 文档提取数据。

💡

如果你之前考过 1Z0-149，大约 70% 的知识点可以直接复用，重点补 19c 新特性和性能优化部分。

⚠️

**Bulk Collect 的 LIMIT 子句遗忘** — 不加 LIMIT 的 Bulk Collect 会一次性将所有数据加载到 PGA 内存，数据量大时直接 ORA-04030 内存不足。考试经常问"如何优化 Bulk Collect 的内存使用"。

⚠️

**FORALL 不是 FOR ALL** — FORALL 是 PL/SQL 特有的批量 DML 语句，语法和 FOR 循环不同。FORALL 后面只能跟一条 DML 语句，不能嵌套多条。

⚠️

**AUTHID DEFINER 的安全风险** — 以创建者权限执行意味着调用者可能获得超出其自身权限的数据访问能力。考试场景题会问"如何防止存储过程的权限提升风险"。

Frequently Asked Questions

If you plan to take Oracle 1Z0-078, 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 prep

From $39 · 2 free chapters

Student reviews

Loading reviews…

Related certifications

Oracle 1Z0-149

Oracle · 助理级
$24563 questions120 min

Oracle 1Z0-071

Oracle · 助理级
$24573 questions120 min

Oracle 1Z0-082

Oracle · 助理级
$24568 questions120 min
EXAM PREP

Oracle 1Z0-078 Question Bank

Chapter-by-chapter learning + mock exams + AI tutor

73
Questions
7
Chapters
36h
Study
AI
Tutor
  • First 2 chapters free
  • Real exam format mock tests
  • AI-powered wrong answer review
  • Chapter progress tracking
From $39
Start Practice Now

Prep snapshot

Study chapters7
Practice questions73
Estimated hours36h

What is inside

  • 7 structured chapters covering the full PL/SQL exam scope
  • 73+ practice questions with explanations
  • Coverage of blocks, cursors, procedures, functions, packages, triggers, dynamic SQL, and collections
  • Mock exam practice aligned to the 70-question, 120-minute format
  • Examples focused on writing code that works in real Oracle environments