- Exam Code: 1Z0-144J
- Exam Name: Oracle Database 11g: Program with PL/SQL (1Z0-144日本語版)
- Updated: Sep 11, 2026
- Q & A: 103 Questions and Answers
Short on time before your 1Z0-144日本語 exam date? Actual4Dumps packs 103 focused practice questions for the Oracle Database 11g: Program with PL/SQL (1Z0-144日本語版) into a format you can work through whenever a spare hour appears, so even a busy schedule is no excuse.
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Oracle Database 11g: Program with PL/SQL |
| Exam Number: | 1Z0-144 |
| Exam Format: | Multiple Choice, Multiple Select |
| Related Certifications: | Oracle Advanced PL/SQL Developer Certified Professional |
| Exam Price: | USD 245 |
| Certificate Validity Period: | 18 months |
| Exam Duration: | 90 minutes |
| Real Exam Qty: | 63 |
| Available Languages: | Japanese, English, Simplified Chinese |
| Passing Score: | 65% |
| Recommended Training: | Oracle Database 11g: Program with PL/SQL (Oracle University) |
| Exam Registration: | Pearson VUE Registration Oracle Education |
| Sample Questions: | ![]() |
| Exam Way: | Onsite at Pearson VUE testing centers; Online proctored exam available |
| Pre Condition: | Recommended: Basic SQL knowledge; Oracle Database SQL Certified Associate (1Z0-071) or equivalent experience |
| Official Syllabus URL: | https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-144 |
| Section | Weight | Objectives |
|---|---|---|
| Composite Data Types | 11% | - Differentiate records, tables and collections - Use INDEX BY tables and collections - Create PL/SQL records and %ROWTYPE records |
| Introduction to PL/SQL | 10% | - Output messages using DBMS_OUTPUT - Explain the need and benefits of PL/SQL - Identify PL/SQL block types and structure |
| Declaring PL/SQL Variables | 12% | - Declare, initialize and use variables and bind variables - Use identifiers, data types, %TYPE attribute |
| Control Structures | 12% | - Use EXIT and CONTINUE statements - Use IF, CASE statements and expressions - Construct and manage loop structures |
| Executable Statements & SQL Integration | 13% | - Embed DML and transaction control statements - Handle implicit and explicit data type conversions - Use SELECT INTO clause - Use built-in SQL functions and sequences |
| Handling Exceptions | 10% | - Handle predefined and user-defined exceptions - Use RAISE and exception handling blocks - Understand exception types and propagation |
| Using Packages | 9% | - Manage package state and persistent data - Define package specification and body - Invoke packaged procedures and functions |
| Using Explicit Cursors | 13% | - Distinguish implicit vs explicit cursors - Use cursor FOR loops, parameters and FOR UPDATE - Control cursor attributes and fetch data |
| Creating Subprograms | 10% | - Understand subprogram dependencies and privileges - Create and invoke procedures and functions - Manage parameters and modes |
The Oracle Database 11g: Program with PL/SQL (1Z0-144日本語版) is the official Oracle exam that leads to the Oracle PL/SQL Developer Certified Associate certification at the Associate level. Passing it validates your skills against Oracle standards and proves your qualification to current and future employers. The credential is also connected with related certifications such as Oracle Advanced PL/SQL Developer Certified Professional, so it can serve as a solid step in a broader certification path.
The 1Z0-144日本語 exam has 63 questions in total and must be completed within 90 minutes. That leaves only a narrow time budget per item, so train yourself to flag a difficult question, move on, and circle back later instead of getting stuck. A week or two before your test date, run at least one full timed mock exam in the Actual4Dumps desktop or online test engine under the same 90 minutes limit, and repeat until you can finish with a few minutes left for review.
The passing score for the 1Z0-144日本語 exam is 65%, and the official registration fee is USD 245. Keep in mind that a failed attempt is not discounted — retaking the exam means paying the full fee again — so it is wise not to book your seat until your practice scores sit comfortably above the passing mark. Working through the 103 questions at Actual4Dumps in timed mode is a reliable way to judge when you are truly ready.
Oracle sets the following requirement for the 1Z0-144日本語 exam: Recommended: Basic SQL knowledge; Oracle Database SQL Certified Associate (1Z0-071) or equivalent experience. Eligibility rules can change from time to time, so always confirm the current prerequisites on the official exam page at https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-144 before you register.
You can register for the Oracle Database 11g: Program with PL/SQL (1Z0-144日本語版) through the following official channels:
The 1Z0-144日本語 exam is delivered as Onsite at Pearson VUE testing centers; Online proctored exam available, so review the technical and check-in requirements for that format when you schedule your appointment.
Oracle recommends the following official training options for the Oracle Database 11g: Program with PL/SQL (1Z0-144日本語版):
Official courses build the theory, and pairing them with the 103 practice questions from Actual4Dumps turns that knowledge into exam-ready answers.
Yes. Actual4Dumps offers a free PDF demo for the Oracle Database 11g: Program with PL/SQL (1Z0-144日本語版), so you can review real sample questions and judge the quality before paying anything. After your purchase, you receive 365 days of free updates — whenever the question pool changes, you get the latest version at no cost. Once that period expires, you can extend your update service at a 50% discount from your member zone.
If you take the 1Z0-144日本語 exam within 60 days of your purchase and do not pass, you can apply for a full refund under our 100% Money Back Guarantee. To qualify, submit a scanned copy of your exam enrollment slip together with your official Score Report (PDF) within 2 days after the exam date, and your claim will be processed within 7 days. Note that the guarantee applies only to the corresponding exam: attempts taken within 3 days of purchase, downloaded-but-unused materials, free resources, and expired orders are not eligible, and the candidate name must match the purchaser name. If you would rather not refund, you can exchange the product for two free exam products of equal value while keeping the update service on your original purchase.
Delivery is instant: your files are available to download right after payment and are also sent to your email within one minute. If nothing arrives within 2 hours, contact our support team (and check your spam folder first). There is no limit on the number of computers you can install the product on.
The Oracle Database 11g: Program with PL/SQL (1Z0-144日本語版) is organized into 9 domains. Among the first ones are Declaring PL/SQL Variables (12%), Using Packages (9%), Creating Subprograms (10%), and the remaining domains cover the rest of the official objectives. For the complete topic breakdown with every subtopic, see the full 1Z0-144日本語 exam outline above on this page.



CREATE OR REPLACE PROCEDURE add_dept(
p_id NUMBER, p_name VARCHAR2) IS
BEGIN
INSERT INTO departments VALUES <p_id, p_name, NULL, NULL);
END;
/
Correct Answer: A,C 🗳️

Correct Answer: B,D,F 🗳️

EMPLOYEES
DEPAERTMENT
EMP_BY_DEPT



Correct Answer: A 🗳️
Over 45369+ Satisfied Customers
Actual4Dumps Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
We are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
If you prepare for the exams using our Actual4Dumps testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Actual4Dumps offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.