From a free demo to 2026 updates and a 60-day money back guarantee, Actual4Exams covers the full 1Z0-144 preparation journey. Get the 103 Oracle Database 11g: Program with PL/SQL practice questions in PDF, desktop, or online format and study on your own terms.
Oracle 1Z0-144 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Oracle Database 11g: Program with PL/SQL |
| Exam Number: | 1Z0-144 |
| Related Certifications: | Oracle Advanced PL/SQL Developer Certified Professional |
| Exam Price: | USD 245 |
| Exam Format: | Multiple Select, Multiple Choice |
| Available Languages: | Japanese, Simplified Chinese, English |
| Certificate Validity Period: | 18 months |
| Exam Duration: | 90 minutes |
| Passing Score: | 65% |
| Real Exam Qty: | 63 |
| 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 |
Oracle 1Z0-144 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Using Packages | 9% | - Manage package state and persistent data - Invoke packaged procedures and functions - Define package specification and body |
| Executable Statements & SQL Integration | 13% | - Handle implicit and explicit data type conversions - Use built-in SQL functions and sequences - Embed DML and transaction control statements - Use SELECT INTO clause |
| Using Explicit Cursors | 13% | - Control cursor attributes and fetch data - Use cursor FOR loops, parameters and FOR UPDATE - Distinguish implicit vs explicit cursors |
| Handling Exceptions | 10% | - Understand exception types and propagation - Handle predefined and user-defined exceptions - Use RAISE and exception handling blocks |
| Introduction to PL/SQL | 10% | - Explain the need and benefits of PL/SQL - Identify PL/SQL block types and structure - Output messages using DBMS_OUTPUT |
| Creating Subprograms | 10% | - Understand subprogram dependencies and privileges - Create and invoke procedures and functions - Manage parameters and modes |
| Composite Data Types | 11% | - Differentiate records, tables and collections - Create PL/SQL records and %ROWTYPE records - Use INDEX BY tables and collections |
| Declaring PL/SQL Variables | 12% | - Use identifiers, data types, %TYPE attribute - Declare, initialize and use variables and bind variables |
| Control Structures | 12% | - Use IF, CASE statements and expressions - Use EXIT and CONTINUE statements - Construct and manage loop structures |
1Z0-144 Exam FAQ: What Candidates Ask About Oracle Database 11g: Program with PL/SQL
The 1Z0-144 exam, officially known as Oracle Database 11g: Program with PL/SQL, is the Oracle test that leads to the Oracle PL/SQL Developer Certified Associate certification at the Associate level. Passing it validates the skills employers expect from a certified professional. It is also associated with related credentials such as Oracle Advanced PL/SQL Developer Certified Professional.
The 1Z0-144 exam contains 63 questions, and you have 90 minutes to complete them. Work out your per-question pace before test day, and flag slow items instead of stalling on them — time pressure, not knowledge, sinks many first attempts. Timed mock exams in the Actual4Exams test engines are the most reliable way to build that rhythm.
The passing score for the 1Z0-144 exam is 65%, and the official registration fee is USD 245. If you miss the mark, a retake means paying the full fee again, so book your seat only when you are ready. A practical benchmark: score consistently above the passing line on timed practice tests before scheduling the real exam.
Recommended: Basic SQL knowledge; Oracle Database SQL Certified Associate (1Z0-071) or equivalent experience
Entry requirements can change, so confirm the latest conditions on the official exam page: https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-144.
You can book the 1Z0-144 exam through the official registration channels below:
Exam delivery: Onsite at Pearson VUE testing centers; Online proctored exam available. Seats at popular test centers fill quickly, so schedule early once your preparation is on track.
Oracle recommends the following training options for Oracle Database 11g: Program with PL/SQL candidates:
Pair any course with the 103 practice questions from Actual4Exams to measure how ready you really are before paying the exam fee.
Yes. A free PDF demo of the Oracle Database 11g: Program with PL/SQL questions is available, so you can check the question style and answer quality before you pay. Every purchase also includes 365 days of free updates, and if the product expires you can renew the update service at a 50% discount from your member zone.
If you take the corresponding 1Z0-144 exam within 60 days of purchase and do not pass, you can apply for a full refund under the 100% Money Back Guarantee: submit a scan of your enrollment slip and your official Score Report (PDF) within 2 days of the exam date, and the claim is processed within 7 days. Attempts made within 3 days of purchase, downloads without an actual exam attempt, free materials, and expired orders are not eligible, and the candidate name must match the payer name. Prefer new material instead of a refund? You can exchange your purchase for two free products of equal value and keep the update service on your original product. As for delivery, the files are available for instant download and are also emailed to you within one minute of payment — if nothing arrives within 2 hours, contact customer service. There is no limit on how many computers you can install the product on.
The official Oracle Database 11g: Program with PL/SQL outline is organized into 9 domains. The first three are:
- Handling Exceptions — 10% of the exam
- Introduction to PL/SQL — 10% of the exam
- Creating Subprograms — 10% of the exam
See the complete exam topics section above for the full outline and the weighting of every domain.
Oracle Database 11g: Program with PL/SQL Sample Questions:
Which statements are true about database triggers? (Choose all that apply.)
- A. They are implicitly fired by an event that must occur within an application
- B. They are implicitly fired when a triggering event occurs, depending on which user is connected
- C. They can include SQL and PL/SQL or calls to Java procedures.
- D. They can invoke only PL/SQL procedures
Correct Answer: B,D 🗳️
Explanation: Only visible for Actual4Exams members. You can sign-up / login (it's free).
View the Exhibit and examine the package code created by SCOTT. The execute privilege on this package is granted to green.
Examine the following sequence of commands issued by SCOTT:
What is the outcome?
- A. SCOTT'S session displays 5, and then 5 again; green's session displays 5.
- B. SCOTT'S session displays 5, and then 5 again, green's session displays 0.
- C. SCOTT'S session displays 5, and then 0, greets session displays 0.
- D. SCOTT'S session displays 5, and then 0; green's session displays 5.
Correct Answer: D 🗳️
What is the correct definition of the persistent state of a packaged variable?
- A. It is a public variable in a package specification whose value is always consistent across all current active sessions.
- B. It is a private variable in a package body whose value is consistent across all current active sessions.
- C. It is a private variable defined in a procedure or function within a package body whose
value is consistent within a user session. - D. It is a public variable in a package specification whose value is consistent within a user session.
Correct Answer: D 🗳️
View the Exhibits and examine the structure of the EMPLOYEES, DEPARTMENTS AND EMP_BY_DEPT tables.
EMPLOYEES
DEPAERTMENT
EMP_BY_DEPT
Examine the following code:
What is the outcome on execution of the above code?
- A. It executes successfully but the output statements show different values.
- B. It gives an error because the SQL%ROWCOUNT attribute cannot be used with BULK COLLECT.
- C. It gives an error because the INSERT SELECT construct cannot be used with the FORALL
- D. It executes successfully and both output statements show the same values.
Correct Answer: A 🗳️
Identify two situations where the DBMS_SQL package should be used. (Choose two.)
- A. You do not know how many columns a select statement will return, or what their data types will.
- B. The SELECT list is not known until run time.
- C. You must use the %found SQL cursor attribute after issuing a dynamic SQL statement that is an insert or update statement.
- D. The dynamic SQL statement retrieves rows into records.
Correct Answer: A,B 🗳️
No help, Full refund!
Actual4Exams confidently stands behind all its offerings by giving Unconditional "No help, Full refund" Guarantee. Since the time our operations started we have never seen people report failure in the Oracle 1Z0-144 exam after using our products. With this feedback we can assure you of the benefits that you will get from our products and the high probability of clearing the 1Z0-144 exam.
We still understand the effort, time, and money you will invest in preparing for your certification exam, which makes failure in the Oracle 1Z0-144 exam really painful and disappointing. Although we cannot reduce your pain and disappointment but we can certainly share with you the financial loss.
This means that if due to any reason you are not able to pass the 1Z0-144 actual exam even after using our product, we will reimburse the full amount you spent on our products. you just need to mail us your score report along with your account information to address listed below within 7 days after your unqualified certificate came out.
