Free demo, instant delivery, a year of free updates, 24/7 customer service, and a written refund policy: TestsDumps wraps Oracle Database 11g: Program with PL/SQL preparation into one risk-conscious purchase for 2026 1Z0-144 candidates.
Oracle 1Z0-144 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Oracle Database 11g: Program with PL/SQL |
| Exam Number: | 1Z0-144 |
| Passing Score: | 65% |
| Real Exam Qty: | 63 |
| Exam Price: | USD 245 |
| Exam Format: | Multiple Select, Multiple Choice |
| Related Certifications: | Oracle Advanced PL/SQL Developer Certified Professional |
| Exam Duration: | 90 minutes |
| Certificate Validity Period: | 18 months |
| Available Languages: | Simplified Chinese, Japanese, English |
| 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 |
|---|---|---|
| Topic 1: Using Packages | 9% | - Manage package state and persistent data - Invoke packaged procedures and functions - Define package specification and body |
| Topic 2: Control Structures | 12% | - Use IF, CASE statements and expressions - Use EXIT and CONTINUE statements - Construct and manage loop structures |
| Topic 3: Declaring PL/SQL Variables | 12% | - Use identifiers, data types, %TYPE attribute - Declare, initialize and use variables and bind variables |
| Topic 4: Handling Exceptions | 10% | - Use RAISE and exception handling blocks - Understand exception types and propagation - Handle predefined and user-defined exceptions |
| Topic 5: Creating Subprograms | 10% | - Create and invoke procedures and functions - Manage parameters and modes - Understand subprogram dependencies and privileges |
| Topic 6: Using Explicit Cursors | 13% | - Control cursor attributes and fetch data - Distinguish implicit vs explicit cursors - Use cursor FOR loops, parameters and FOR UPDATE |
| Topic 7: Introduction to PL/SQL | 10% | - Identify PL/SQL block types and structure - Output messages using DBMS_OUTPUT - Explain the need and benefits of PL/SQL |
| Topic 8: Composite Data Types | 11% | - Use INDEX BY tables and collections - Create PL/SQL records and %ROWTYPE records - Differentiate records, tables and collections |
| Topic 9: Executable Statements & SQL Integration | 13% | - Embed DML and transaction control statements - Use SELECT INTO clause - Handle implicit and explicit data type conversions - Use built-in SQL functions and sequences |
Oracle 1Z0-144 Exam: Frequently Asked Questions
Oracle Database 11g: Program with PL/SQL is an official Oracle exam, identified by exam code 1Z0-144. Passing it earns the Oracle PL/SQL Developer Certified Associate certification at the Associate level. It also relates to Oracle Advanced PL/SQL Developer Certified Professional. Certifications like this one remain a reliable route to standing out: they prove ability in a way resumes alone cannot.
The Oracle Database 11g: Program with PL/SQL exam contains 63 questions to complete within 90 minutes. The candidates who run out of time are usually the ones who never practiced against a clock. The TestsDumps software engine lets you limit your test time exactly like the real exam, exposing pacing weaknesses while they are still free to fix.
You need 65% to pass Oracle Database 11g: Program with PL/SQL, and the official registration fee is USD 245. Retakes charge the full USD 245 again, which makes failing a genuinely expensive outcome. Reduce that risk the rational way: practice with the TestsDumps questions until your scores sit consistently above the requirement, then book.
Recommended: Basic SQL knowledge; Oracle Database SQL Certified Associate (1Z0-071) or equivalent experience
Vendor requirements change from time to time, so verify the current conditions before registering via the official exam page.
Registration for Oracle Database 11g: Program with PL/SQL runs through the official channels below.
One practical note: the exam is delivered Onsite at Pearson VUE testing centers; Online proctored exam available.
Oracle recommends the following training for Oracle Database 11g: Program with PL/SQL candidates.
Whatever training you take, anchor it with the 103 practice questions in the TestsDumps 1Z0-144 package, each with a detailed explanation that turns every mistake into a lesson.
Yes. You can download the free demo of the Oracle Database 11g: Program with PL/SQL questions before you buy, and after purchase you have the right to one year of free updates. When your product expires, extending the update service costs 50% of the regular price. Three versions, PDF, software, and online APP, let you study the way that suits you.
A 100% money-back guarantee protects you under clear conditions. Take the Oracle Database 11g: Program with PL/SQL exam within 60 days of purchase; if you fail, you can claim a full refund, provided the exam matches your product. Attempts within 3 days of purchase are ineligible, as are downloaded-but-unused products, free materials, and expired orders; the candidate name must match the payer name. Submit a scanned enrollment slip and the official Score Report PDF within 2 days of the exam, and claims are processed within 7 days. Alternatively, exchange for two other exam products of equal value, free, while keeping the update service on your original purchase.
Delivery is instant: files unlock for download at payment and are automatically emailed within one minute. If nothing arrives within 2 hours, check spam and contact customer service, available 24/7. Installation is unlimited across your computers.
The Oracle Database 11g: Program with PL/SQL syllabus divides into 9 domains. The leading areas are Control Structures (12%), Executable Statements & SQL Integration (13%), and Creating Subprograms (10%). The complete outline is published above; knowing your shortcomings starts with knowing the syllabus.
Oracle Database 11g: Program with PL/SQL Sample Questions:
Which two statements are true about anonymous blocks and named subprograms?
(Choose two)
- A. Subprograms are by default executed with definer's rights.
- B. The declare section is mandatory for anonymous blocks and optional for subprograms.
- C. The declare section is optional for both anonymous blocks and subprograms.
- D. Both anonymous blocks and subprograms execute by default with invoker's rights.
Correct Answer: A,C 🗳️
/temp/my_files is an existing folder in the server, facultylist.txt is an existing text file in this folder
Examine the following commands that are executed by the DBA:
SQL>CREATE DIRECTION my_dir AS ' /temp/my_files': SQL>GRANT READ ON DIRECTORY my_dir To pubiic:
View the Exhibit and examine the procedure created by user SCOTT to read the list of faculty names from the text file.
SCOTT executes the procedure as follows:
SQL>SET SERVEROUTPUT ON
SQL>EXEC read_file ('MY_DIR', FACULTYLIST.TXT')
What is the outcome?
- A. It executes successfully and displays only the list of faculty names.
- B. It executes successfully and displays the list of faculty names followed by a "no data found" error message.
- C. It goes into an infinite loop.
- D. It does not execute and displays an error message because the end-of-file condition is not taken care of.
Correct Answer: A 🗳️
Examine the following code:
Which statement is true about the execution of the above code?
- A. It fails because no value is assigned to the v_myage variable.
- B. It executes and the condition returns true.
- C. It executes and displays null.
- D. It executes and control goes to the else statement.
Correct Answer: D 🗳️
View the Exhibit and examine the structure of the customer table.
Examine the following trigger code:
What is the outcome when the above trigger is compiled?
- A. It gives an error because when cannot be used for row-level triggers.
- B. It compiles successfully.
- C. It gives an error because the when condition is not valid.
- D. It gives an error because the statements under updating are not valid.
- E. It gives an error because the new qualifier in the when clause requires a colon prefix.
Correct Answer: B 🗳️
User SCOTT has been granted CREATE ANY TRIGGER AND ALTER ANY TABLE by the DBA. HR is an existing schema in the database.
SCOTT creates the following trigger: CREATE OR REPLACE TRIGGER drop_trigger BEFORE DROP ON hr.SCHEMA
BEGIN
RAISE_APPLICATION_ERROR (-20000, 'Cannot drop object');
END:
SCOTT does not grant the execute privilege on this trigger to any other users.
For which user(s) would this trigger fire by default when they drop an object in the hr schema?
- A. SCOTT, HR, and SYS
- B. SCOTT and HR
- C. Only HR
- D. Only SCOTT
Correct Answer: C 🗳️
Jesse 
Quentin 
Marcia 
Mary 
Beryl 
Rebecca 
Broderick 
Darlene 
Tabitha 
Otis 
Vita 
Albert 
Lena 
Chester 
