Oracle 1Z1-144 Exam Details & Actual Exam Questions
- Exam Code/Number: 1Z1-144
- Exam Name/Title: Oracle Database 11g: Program with PL/SQL
- Certification Provider: Oracle
- Corresponding Certification: Other Oracle Certification
- Exam Questions: 103
- Updated On: Sep,22 2026
- Certification Level: Associate
Oracle Database 11g: Program with PL/SQL Exam Questions
View 1Z1-144 actual exam questions, answers and explanations for free.
91% student found the test questions almost same
All the information you need to pass Oracle Database 11g: Program with PL/SQL 1Z1-144 exam and free practice exam verified by EduDump exam experts.
Said the test questions were almost same
Passed the exams with the material
Found the study quides effective and helpful
(32 Up Votes)Oracle 1Z1-144 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Oracle Database 11g: Program with PL/SQL |
| Exam Number: | 1Z0-144 |
| Certificate Validity Period: | 18 months |
| Related Certifications: | Oracle Advanced PL/SQL Developer Certified Professional |
| Available Languages: | English, Japanese, Simplified Chinese |
| Exam Duration: | 90 minutes |
| Exam Format: | Multiple Choice, Multiple Select |
| Passing Score: | 65% |
| Real Exam Qty: | 63 |
| Exam Price: | USD 245 |
| Recommended Training: | Oracle Database 11g: Program with PL/SQL (Oracle University) |
| Exam Registration: | Pearson VUE Registration Oracle Education |
| Sample Questions: | Oracle 1Z1-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 1Z1-144 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Control Structures | 12% | - Use EXIT and CONTINUE statements - Use IF, CASE statements and expressions - Construct and manage loop structures |
| Executable Statements & SQL Integration | 13% | - Handle implicit and explicit data type conversions - Use SELECT INTO clause - Use built-in SQL functions and sequences - Embed DML and transaction control statements |
| 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% | - Use identifiers, data types, %TYPE attribute - Declare, initialize and use variables and bind variables |
| Composite Data Types | 11% | - Use INDEX BY tables and collections - Differentiate records, tables and collections - Create PL/SQL records and %ROWTYPE records |
| Using Explicit Cursors | 13% | - Use cursor FOR loops, parameters and FOR UPDATE - Control cursor attributes and fetch data - Distinguish implicit vs explicit cursors |
| Creating Subprograms | 10% | - Create and invoke procedures and functions - Understand subprogram dependencies and privileges - Manage parameters and modes |
| Handling Exceptions | 10% | - Handle predefined and user-defined exceptions - Understand exception types and propagation - Use RAISE and exception handling blocks |
| Using Packages | 9% | - Define package specification and body - Invoke packaged procedures and functions - Manage package state and persistent data |
0
0
0
10