Exam Name: Oracle Database 11g: Program with PL/SQL
Certification Provider: Oracle
Corresponding Certification: Other Oracle Certification
Over 170131+ Satisfied Customers
Oracle Database 11g: Program with PL/SQL: 1Z0-144 Exam Premium File as PDF & Test Engine
1181 Customer Reviews
Last Updated: Sep 06, 2026
No. of Questions: 103 Questions & Answers with Testing Engine
Download Limit: Unlimited
Instant Download: Upon successful payment, Our systems will automatically send the product you have purchased to your mailbox by email. (If not received within 12 hours, please contact us. Note: don't forget to check your spam.)
100% Money Back Guarantee
Fast2test has an unprecedented 99.6% first time pass rate among our customers. 
We're so confident of our products that we provide no hassle product exchange.
- Best 1Z0-144 exam practice materials
- Three formats are optional
- 10 years of excellence
- 365 Days Free Updates
- Learn anywhere, anytime
- 100% Safe shopping experience
- Printable 1Z0-144 PDF Format
- Prepared by Oracle Experts
- Instant Access to Download 1Z0-144 PDF
- Study Anywhere, Anytime
- 365 Days Free Updates
- Free 1Z0-144 PDF Demo Available
- Online Tool, Convenient, easy to study.
- Instant Online Access 1Z0-144 Dumps
- Supports All Web Browsers
- 1Z0-144 Practice Online Anytime
- Test History and Performance Review
- Supports Windows / Mac / Android / iOS, etc.
- Installable Software Application
- Simulates Real 1Z0-144 Exam Environment
- Builds 1Z0-144 Exam Confidence
- Supports MS Operating System
- Two Modes For 1Z0-144 Practice
- Practice Offline Anytime
Whether you study best on paper or on screen, Fast2test has a Oracle Database 11g: Program with PL/SQL format that fits: a printable PDF, a desktop test engine for Windows, and an online test engine that runs in any browser. All three cover the same 103 1Z0-144 practice questions.
Oracle 1Z0-144 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Oracle Database 11g: Program with PL/SQL |
| Exam Number: | 1Z0-144 |
| Exam Duration: | 90 minutes |
| Real Exam Qty: | 63 |
| Passing Score: | 65% |
| Exam Price: | USD 245 |
| Available Languages: | English, Simplified Chinese, Japanese |
| Exam Format: | Multiple Choice, Multiple Select |
| Certificate Validity Period: | 18 months |
| Related Certifications: | Oracle Advanced PL/SQL Developer Certified Professional |
| Recommended Training: | Oracle Database 11g: Program with PL/SQL (Oracle University) |
| Exam Registration: | Pearson VUE Registration Oracle Education |
| Sample Questions: | Oracle 1Z0-144 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 Explicit Cursors | 13% | - Control cursor attributes and fetch data - Distinguish implicit vs explicit cursors - Use cursor FOR loops, parameters and FOR UPDATE |
| Composite Data Types | 11% | - Differentiate records, tables and collections - Create PL/SQL records and %ROWTYPE records - Use INDEX BY tables and collections |
| Executable Statements & SQL Integration | 13% | - Use SELECT INTO clause - Use built-in SQL functions and sequences - Handle implicit and explicit data type conversions - Embed DML and transaction control statements |
| Using Packages | 9% | - Define package specification and body - Invoke packaged procedures and functions - Manage package state and persistent data |
| Creating Subprograms | 10% | - Understand subprogram dependencies and privileges - Manage parameters and modes - Create and invoke procedures and functions |
| Control Structures | 12% | - Construct and manage loop structures - Use IF, CASE statements and expressions - Use EXIT and CONTINUE statements |
| Handling Exceptions | 10% | - Understand exception types and propagation - Use RAISE and exception handling blocks - Handle predefined and user-defined exceptions |
| 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 |
Oracle Database 11g: Program with PL/SQL Exam FAQs and Straight Answers
The 1Z0-144 exam, officially titled Oracle Database 11g: Program with PL/SQL, is the qualifying test for the Oracle PL/SQL Developer Certified Associate certification from Oracle, a credential at the Associate level. Passing it proves you have the skills employers look for in certified professionals, and it can also support progress toward related credentials such as Oracle Advanced PL/SQL Developer Certified Professional.
The Oracle Database 11g: Program with PL/SQL exam gives you 90 minutes to work through 63 questions. That is a steady pace with little room for second-guessing, so train yourself to read each question once, flag the difficult ones, and keep moving. Before exam day, sit at least two full timed sessions in the Fast2test test engine — when the clock feels familiar, it stops being a threat.
You need 65% to pass, and the official registration fee is USD 245. Fall short and you pay that fee in full again for every retake, which makes solid preparation the cheaper option by far. Work through the Fast2test practice questions until you score comfortably above the passing mark, then book your seat.
Recommended: Basic SQL knowledge; Oracle Database SQL Certified Associate (1Z0-071) or equivalent experience Eligibility rules can change over time, so before you register, confirm the latest requirements on the official exam page: Oracle 1Z0-144 exam overview.
You can book your 1Z0-144 exam through any of these official registration channels:
The exam is delivered as Onsite at Pearson VUE testing centers; Online proctored exam available, so you can pick the option that fits your schedule when you book.
Oracle recommends the following training for Oracle Database 11g: Program with PL/SQL candidates:
Pair that training with the 103 practice questions from Fast2test and you can check your readiness topic by topic before exam day.
Yes. Fast2test offers a free PDF demo for the Oracle Database 11g: Program with PL/SQL exam so you can judge the quality of our questions and answers before paying anything. Every purchase also comes with 365 days of free updates, and once that period expires you can extend your update service at a 50% discount.
Your purchase is protected by a 100% money-back guarantee. If you sit the corresponding 1Z0-144 exam within 60 days of buying and do not pass, send us a scan of your exam enrollment slip together with your official Score Report (PDF) within 2 days of the exam date — the candidate name must match the payer's name — and we will process your full refund within 7 days. Please note that exams taken within 3 days of purchase, materials downloaded without ever sitting the exam, free products, and expired orders are not covered. If you would rather not have a refund, you can exchange your order for two exam products of equal value, free of charge, and keep the update service on your original purchase.
Delivery is instant: your files are emailed to you within one minute of payment and can also be downloaded directly, with no limit on the number of computers you install them on. If nothing has arrived within 2 hours, contact our customer service team and we will sort it out.
The Oracle Database 11g: Program with PL/SQL syllabus is organized into 9 domains. The main areas include Introduction to PL/SQL (10%), Creating Subprograms (10%), and Composite Data Types (11%). Scroll up to the Exam Topics section above for the complete, current outline before you plan your study schedule.
Oracle Database 11g: Program with PL/SQL Sample Questions:
Question 1
Examine the following partial declare section from a block of PL/SQL code
Which line(s) in the above code are NOT valid? (Choose all that apply.)
A. line 5
B. line 4
C. line 2
D. line 3
Question 2
Examine the following PL/SQL code:
The server output is on for the session. Which statement is true about the execution of the code?
A. It displays an error because the select into clause cannot be used to populate the PL/SQL record type.
B. It displays null if no employee with employee_id 123 exists.
C. It produces the ora-01403: no data found error if no employee with employee_id 123 exists.
D. The code executes successfully even if no employee with employee_id 123 exists and displays Record Not Found.
Question 3
Which type of exceptions is qualified as no predefined Oracle server errors?
A. an exception that the developer determines as abnormal, are in the declarative section and raised explicitly
B. the exceptions that are raised implicitly by the Oracle server and can be caught by the exception handler
C. the exceptions that are explicitly raised by the program and can be caught by the exception handler
D. an exception that is raised automatically when the PL/SQL program violates a database rule or exceeds a system-dependent limit
Question 4
Identify two features of obfuscation. (Choose two.)
A. The source code is visible only through the DBA_SOURCE view and not through the USER_SOURCE or ALL_SOURCE View
B. Only the wrap utility can obfuscate multiple programs at a time.
C. The Import and Export utilities accept wrapped files.
D. SQL' Plus cannot process the obfuscated source files.
E. Both the DBMS_DDL package and the Wrap utility can obfuscate multiple programs at a time.
Question 5
Which statements are true about PL/SQL procedures? (Choose all that apply.)
A. A PL/SQL procedure executing on the Oracle database can call an external procedure or function that is written in a different programming language, such as C or Java.
B. Depending on the number of calls, multiple copies of the procedure are loaded into memory for execution by multiple users to speed up performance.
C. Users with definer's rights who are granted access to a procedure that updates a table must be granted access to the table itself.
D. Reuse of parsed PL/SQL code that becomes available in the shared SQL area of the server avoids the parsing overhead of SQL statements at run time.
Solutions:
| Question 1 Answer: A,D | Question 2 Answer: C | Question 3 Answer: A | Question 4 Answer: B,C | Question 5 Answer: A,D |
1181 Customer ReviewsCustomers Feedback (* Some similar or old comments have been hidden.)
I wouldn't be ready for the 1Z0-144 exam if i hadn't prapared with the 1Z0-144 exam materials. Thank you! I passed the exam perfectly! It is all due to your good work!
Benson
I am pleased to tell you that I got high
marks in the 1Z0-144 test all because of you.
Malcolm
I passed my 1Z0-144 exam today with your valid 1Z0-144 exam questions. I loved the fact that I could practice as like i am sitting for the actual exam. Thanks Fast2test for all this!
Baron
I got free update for one year for 1Z0-144 training materials, and I have got free update for several times, quite convenient.
Jonas
I prepared and passed the 1Z0-144 exam with these latest 1Z0-144 practice exam questions. This rehearsal is the best way to evaluate your preparation. I am sure you will pass your exam on the first attempt. Good luck!
Elizabeth
I just passed the 1Z0-144 exam in one go and found the majority of the Q&A are valid. Fast2test is the best website for learning and studying 1Z0-144 exam. Many thanks!
Breenda
Your 1Z0-144 sample questions and answers facilitated me a lot on my 1Z0-144 exam.
Enid
I passed the 1Z0-144 exam with flying colors on my first attempt. You never let me down! Thanks sicerely!
Selena
I just passed my exam yesterday. It was an amazing idea by my friend to try 1Z0-144 exam questions and i was not confident that I can pass it. But once I study it and memorize all the questions then i had a feeling that i can pass it. And I passed it with 85% marks. Thanks 1Z0-144 exam questions once again. 100% recommended to everyone.
Renee
I have found that your Oracle dump resources are probably the best on the market.
Eric
The 1Z0-144 exam dump worked like charm and I got a satisfied score to pass. All my thanks to you.
Otis
Thanks to the original questions of Fast2test I pass 1Z0-144 exam. I will purchase 1z0-100 too.
Ed
I will try 1Z0-144 exam later.
Winni
Thank you so much!
Thank you guys, you are always the best dumps provider! I have passed 1Z0-144 exam.
Linda
I would not have passed without the materials.
I will wait for your reply.
Amelia
Getting these 1Z0-144 exam dumps was a great risk but I am happy that I did. Passing the exam was all because of Fast2test help.
Archer
Great 1Z0-144 training dumps and great content as well! I cleared my 1Z0-144 exam without difficulty. Thanks!
Gustave
When I ordered the 1Z0-144 exam materials, I am still a little worried about it. But, after I used the exam dumps, I changed my idea. Because it covers all the key knowledge points. Eventually, I passed my exam. Thanks!
Ed
Instant Download 1Z0-144
After Payment, our system will send you the products you purchase in mailbox in a minute after payment. If not received within 2 hours, please contact us.
365 Days Free Updates
Free update is available within 365 days after your purchase. After 365 days, you will get 50% discounts for updating.
Money Back Guarantee
Full refund if you fail the corresponding exam in 60 days after purchasing. And Free get any another product.
Security & Privacy
We respect customer privacy. We use McAfee's security service to provide you with utmost security for your personal information & peace of mind.
Related Exams
Contact Us
If you have any question please leave me your email address, we will reply and send email to you in 12 hours.
Our Working Time: ( GMT 0:00-15:00 ) From Monday to Saturday
Support: Contact now