Life rarely leaves a clear slot for exam preparation — work runs late, family needs you, friends deserve your evenings — and that is exactly why the 1Z1-144日本語 materials at VCETorrent are built for self-paced study: 103 practice questions for the 1Z1-144日本語 exam that bend around your schedule instead of breaking it.
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Oracle Database 11g: Program with PL/SQL |
| Exam Number: | 1Z0-144 |
| Certificate Validity Period: | 18 months |
| Exam Format: | Multiple Choice, Multiple Select |
| Exam Duration: | 90 minutes |
| Passing Score: | 65% |
| Exam Price: | USD 245 |
| Real Exam Qty: | 63 |
| Available Languages: | English, Japanese, Simplified Chinese |
| Related Certifications: | Oracle Advanced PL/SQL Developer Certified Professional |
| 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 |
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: 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 |
| Topic 2: Executable Statements & SQL Integration | 13% | - Handle implicit and explicit data type conversions - Embed DML and transaction control statements - Use SELECT INTO clause - Use built-in SQL functions and sequences |
| Topic 3: Composite Data Types | 11% | - Differentiate records, tables and collections - Use INDEX BY tables and collections - Create PL/SQL records and %ROWTYPE records |
| Topic 4: Using Explicit Cursors | 13% | - Use cursor FOR loops, parameters and FOR UPDATE - Control cursor attributes and fetch data - Distinguish implicit vs explicit cursors |
| Topic 5: Using Packages | 9% | - Invoke packaged procedures and functions - Manage package state and persistent data - Define package specification and body |
| Topic 6: Creating Subprograms | 10% | - Create and invoke procedures and functions - Understand subprogram dependencies and privileges - Manage parameters and modes |
| Topic 7: Control Structures | 12% | - Use IF, CASE statements and expressions - Use EXIT and CONTINUE statements - Construct and manage loop structures |
| Topic 8: Handling Exceptions | 10% | - Handle predefined and user-defined exceptions - Use RAISE and exception handling blocks - Understand exception types and propagation |
| Topic 9: Declaring PL/SQL Variables | 12% | - Use identifiers, data types, %TYPE attribute - Declare, initialize and use variables and bind variables |



Correct Answer: B 🗳️
Explanation: Only visible for VCETorrent members. You can sign-up / login (it's free).
Viewing page 1 out of 21 pages.
Viewing questions 1-5 out of 103 questions.
Over 24455+ Satisfied Customers
VCETorrent 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.
We 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.
If you prepare for the exams using our VCETorrent 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.
VCETorrent 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.