PDF Version DemoWhy wait for shipping? The moment your order is confirmed, Getcertkey emails the 1Z0-144 practice questions to your inbox, usually within a minute. You could be working through the 103 questions for the Oracle Database 11g: Program with PL/SQL exam tonight.
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 |
| Available Languages: | Japanese, Simplified Chinese, English |
| Certificate Validity Period: | 18 months |
| Passing Score: | 65% |
| Exam Format: | Multiple Choice, Multiple Select |
| Exam Duration: | 90 minutes |
| Real Exam Qty: | 63 |
| Exam Price: | USD 245 |
| Recommended Training: | Oracle Database 11g: Program with PL/SQL (Oracle University) |
| Exam Registration: | Oracle Education Pearson VUE Registration |
| 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 |
|---|---|---|
| Topic 1: Introduction to PL/SQL | 10% | - Identify PL/SQL block types and structure - Explain the need and benefits of PL/SQL - Output messages using DBMS_OUTPUT |
| Topic 2: Control Structures | 12% | - Construct and manage loop structures - Use IF, CASE statements and expressions - Use EXIT and CONTINUE statements |
| Topic 3: Using Explicit Cursors | 13% | - Use cursor FOR loops, parameters and FOR UPDATE - Distinguish implicit vs explicit cursors - Control cursor attributes and fetch data |
| Topic 4: Executable Statements & SQL Integration | 13% | - Use built-in SQL functions and sequences - Embed DML and transaction control statements - Handle implicit and explicit data type conversions - Use SELECT INTO clause |
| Topic 5: Declaring PL/SQL Variables | 12% | - Use identifiers, data types, %TYPE attribute - Declare, initialize and use variables and bind variables |
| Topic 6: Creating Subprograms | 10% | - Understand subprogram dependencies and privileges - Manage parameters and modes - Create and invoke procedures and functions |
| Topic 7: Composite Data Types | 11% | - Create PL/SQL records and %ROWTYPE records - Differentiate records, tables and collections - Use INDEX BY tables and collections |
| Topic 8: Handling Exceptions | 10% | - Handle predefined and user-defined exceptions - Understand exception types and propagation - Use RAISE and exception handling blocks |
| Topic 9: Using Packages | 9% | - Define package specification and body - Manage package state and persistent data - Invoke packaged procedures and functions |
1Z0-144 Exam FAQs for 2026 Candidates
Which certification does the 1Z0-144 exam lead to?
The 1Z0-144 exam is the official Oracle exam behind the Oracle PL/SQL Developer Certified Associate certification, validating the skills measured by the Oracle Database 11g: Program with PL/SQL credential. It sits at the Associate level of the Oracle certification program. It also connects to Oracle Advanced PL/SQL Developer Certified Professional, so the knowledge you build here carries over to those tracks as well.
How many questions are on the 1Z0-144 exam, and how much time do I get?
The 1Z0-144 exam contains 63 questions to be completed within 90 minutes. Before exam day, divide the available time by the question count to work out a comfortable per-question pace, and mark any item that eats into it so you can return later instead of getting stuck. Timed sessions in the Getcertkey test engines make that pacing automatic — run at least two full-length mock exams under the clock so time pressure never becomes the reason you drop points.
What score do I need to pass the 1Z0-144 exam, and what does it cost?
The passing score for the 1Z0-144 exam is 65%, and the official registration fee is USD 245. Retakes are not discounted — every new attempt means paying the full fee again — so it pays to measure yourself before you book. Work through the 103 practice questions on Getcertkey, sit a timed practice test, and schedule your exam only when your scores are consistently comfortable. That simple habit is the cheapest exam strategy there is.
Are there any prerequisites for the 1Z0-144 exam?
Recommended: Basic SQL knowledge; Oracle Database SQL Certified Associate (1Z0-071) or equivalent experience Requirements can change when Oracle revises its certification program, so confirm the current eligibility rules on the official exam page before you register.
How do I register for the 1Z0-144 exam?
You can book the Oracle Database 11g: Program with PL/SQL exam through the official registration channels below:
As for delivery, the exam is offered in the following format: Onsite at Pearson VUE testing centers; Online proctored exam available. Choose the option that suits you best when you book your seat.
What official training is recommended for the 1Z0-144 exam?
Oracle recommends the following training resources for the Oracle Database 11g: Program with PL/SQL exam:
Official courses build the foundation; the 103 practice questions from Getcertkey then show you how that knowledge is examined, so the two work best together.
Can I try the 1Z0-144 practice questions before I buy?
Yes. Getcertkey provides a free 1Z0-144 PDF demo so you can review the question style and answer quality before purchasing. Every purchase also includes 365 days of free updates — if Oracle revises the exam during that period, the updated material reaches you at no cost. Once the free-update year ends, you can extend your update service at a 50% discount.
What if I fail the 1Z0-144 exam, and how is my order delivered?
Every Oracle Database 11g: Program with PL/SQL purchase on Getcertkey is covered by a 100% money-back guarantee with clear conditions: if you take the corresponding exam within 60 days of your purchase and do not pass, you can claim a full refund by submitting a scanned copy of your exam enrollment slip and your official score report as a PDF within two days of the exam date; claims are processed within seven days of submission. The guarantee does not apply to exams taken within three days of purchase, to material that was downloaded but never used in an exam attempt, or to free products and expired orders, and the candidate name must match the payer name. If you would rather not take a refund, you can instead exchange your purchase for two free exam preparation products of equal value and keep the update service on your original product.
Delivery is instant: your download is sent to your email within one minute of payment, with no limit on how many computers you may install the material on. If nothing arrives within two hours, check your spam folder and contact customer service for help.
What topics are covered in the 1Z0-144 exam?
The Oracle Database 11g: Program with PL/SQL exam blueprint is organized into 9 domains. The first three are:
- Declaring PL/SQL Variables — 12% of the exam
- Handling Exceptions — 10% of the exam
- Introduction to PL/SQL — 10% of the exam
For the complete domain-by-domain breakdown, scroll up to the full exam topics outline above and use it to plan how you distribute your study time.
Oracle Database 11g: Program with PL/SQL Sample Questions:
Question 1
Which two statements are true about the exit statement encountered in loop? (Choose two)
A. The current iteration of the loop completes immediately and control passes to the next iteration of the loop.
B. The loop completes immediately and control passes to the statement after end loop
C. The PL/SQL block execution terminates immediately after the exit statement.
D. The statements after the exit statement in the Iteration are not executed before terminating the LOOP.
Question 2
View the exhibit and examine the structure of the EMPLOYEE table.
EMPLOYEE_SEQ is an existing sequence.
Examine the following block of code:
Which statement is true about the above block of code?
A. It gives an error on execution because sequences cannot be used in anonymous blocks.
B. The data is automatically committed after the block execution ends,
C. It consists of two transactions
D. It consists of a single transaction,
Question 3
Identify two features of obfuscation. (Choose two.)
A. Both the DBMS_DDL package and the Wrap utility can obfuscate multiple programs at a time.
B. The source code is visible only through the DBA_SOURCE view and not through the USER_SOURCE or ALL_SOURCE View
C. Only the wrap utility can obfuscate multiple programs at a time.
D. SQL' Plus cannot process the obfuscated source files.
E. The Import and Export utilities accept wrapped files.
Question 4
View the Exhibit and examine the structure of the SALGRADE table. Examine the following code:
What is the outcome?
A. It gives an error because the return clause condition is invalid.
B. It gives an error because the usage of the host variables is invalid.
C. It gives an error because the data type of the return clause is invalid.
D. It is created successfully.
Question 5
You want to create a trigger that fires whenever rows are deleted from the customer table and that displays the number of rows remaining in the table.
Which two statements are correct about the trigger to be created for the above requirement? (Choose two.)
A. It should be a statement-level trigger.
B. It should be an after trigger.
C. It should be a before trigger.
D. It should be a row-level trigger.
E. It can be a before or an after trigger.
Solutions:
| Question 1 Answer: A,B | Question 2 Answer: C | Question 3 Answer: C,E | Question 4 Answer: A | Question 5 Answer: B,D |
1245 Customer Reviews
Quality and ValueGetCertKey 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.
Tested and ApprovedWe 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.
Easy to PassIf you prepare for the exams using our GetCertKey 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.
Try Before BuyGetCertKey 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.