Oracle writes the blueprint; CertkingdomPDF builds the training ground on top of it. Every one of the Oracle Database 11g: Program with PL/SQL practice questions maps to the objectives the 1Z0-144 exam actually scores.
Oracle 1Z0-144 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Oracle Database 11g: Program with PL/SQL |
| Exam Number: | 1Z0-144 |
| Real Exam Qty: | 63 |
| Exam Format: | Multiple Choice, Multiple Select |
| Related Certifications: | Oracle Advanced PL/SQL Developer Certified Professional |
| Passing Score: | 65% |
| Exam Price: | USD 245 |
| Exam Duration: | 90 minutes |
| Available Languages: | English, Simplified Chinese, Japanese |
| Certificate Validity Period: | 18 months |
| 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 |
|---|---|---|
| Executable Statements & SQL Integration | 13% | - Embed DML and transaction control statements - Use SELECT INTO clause - Use built-in SQL functions and sequences - Handle implicit and explicit data type conversions |
| Composite Data Types | 11% | - Use INDEX BY tables and collections - Differentiate records, tables and collections - Create PL/SQL records and %ROWTYPE records |
| Control Structures | 12% | - Construct and manage loop structures - Use IF, CASE statements and expressions - Use EXIT and CONTINUE statements |
| Creating Subprograms | 10% | - Understand subprogram dependencies and privileges - Create and invoke procedures and functions - Manage parameters and modes |
| Using Packages | 9% | - Manage package state and persistent data - Invoke packaged procedures and functions - Define package specification and body |
| Introduction to PL/SQL | 10% | - Explain the need and benefits of PL/SQL - Output messages using DBMS_OUTPUT - Identify PL/SQL block types and structure |
| Handling Exceptions | 10% | - Understand exception types and propagation - Use RAISE and exception handling blocks - Handle predefined and user-defined exceptions |
| Declaring PL/SQL Variables | 12% | - Use identifiers, data types, %TYPE attribute - Declare, initialize and use variables and bind variables |
| Using Explicit Cursors | 13% | - Use cursor FOR loops, parameters and FOR UPDATE - Distinguish implicit vs explicit cursors - Control cursor attributes and fetch data |
Straight Answers About the Oracle 1Z0-144 Exam
The 1Z0-144 exam is Oracle's benchmark for awarding the Oracle PL/SQL Developer Certified Associate certification, a credential positioned at the Associate level. It measures whether you can apply the Oracle Database 11g: Program with PL/SQL objectives under exam conditions — not whether you recognize them in a textbook. It also connects to a wider certification path that includes Oracle Advanced PL/SQL Developer Certified Professional, so the effort you invest here keeps paying off. That is exactly why preparation built on realistic questions outperforms passive reading.
The Oracle Database 11g: Program with PL/SQL blueprint spans 9 domains, headlined by Introduction to PL/SQL (10%), Using Packages (9%), and Executable Statements & SQL Integration (13%). Read the weightings as a budget: the domains carrying more of the score deserve more of your week. The complete topic list lives in the exam topics section above — plan against it, not against guesswork.
The Oracle Database 11g: Program with PL/SQL exam gives you 90 minutes for 63 questions. Convert that into a rhythm before test day: minutes divided by questions is your per-item budget, and anything burning twice its budget gets flagged and revisited at the end. Rehearse the pacing under a real timer — every CertkingdomPDF engine session runs one — until finishing with spare review time becomes normal.
Passing Oracle Database 11g: Program with PL/SQL requires 65%, and each attempt costs USD 245 — retakes included, at full price. The financially rational move is arriving over-prepared: drill with CertkingdomPDF practice questions until your timed scores clear the bar several sessions in a row, then register. That's not caution; it's refusing to pay for the same exam twice.
Oracle lists the Oracle Database 11g: Program with PL/SQL question formats as: Multiple Choice, Multiple Select. Formats are not trivia — they change how you read. For long scenario stems, find the actual question sentence first; for multi-answer items, verify every option you select. CertkingdomPDF's 103 practice questions cover these formats thoroughly, so on exam day only the content is new.
The 1Z0-144 exam is offered in English, Japanese, Simplified Chinese. Pick the language where your reading speed holds up under time pressure — in a timed exam, slow comprehension is a hidden tax on every question. If you test in English, daily work with CertkingdomPDF's English 1Z0-144 practice questions doubles as targeted vocabulary training.
The certification earned through the Oracle Database 11g: Program with PL/SQL exam remains valid for 18 months. Note the expiry date early and research the recertification path well before it arrives — a planned renewal is an errand, an expired credential is a project. Oracle owns these policies, so confirm the current rules on the official certification page as your window approaches.
All three versions contain the same 103 expert-written questions — what you're choosing is a study environment:
- PDF version — printable, expert-prepared, instantly downloadable, readable anywhere, anytime. Includes 365 days of free updates and a free demo.
- Desktop Test Engine — Windows software that simulates the real exam environment, with two practice modes, offline access, and unlimited installations.
- Online Test Engine — runs in any web browser on Windows, Mac, Android, and iOS, with test history and performance review built in.
Many candidates combine formats — the PDF for reading, an engine for timed rehearsal.
Yes. CertkingdomPDF's free Oracle Database 11g: Program with PL/SQL PDF demo contains genuine sample questions with verified answers, so you can judge the quality before spending anything. Every purchase includes 365 days of free updates, and renewing after that costs 50% of the regular price from your member zone. Test-drive first — confident material has nothing to hide.
Continuously. As Oracle adjusts the Oracle Database 11g: Program with PL/SQL exam, our experts revise the bank to match, and customer feedback feeds the same review loop. Updates are free for 365 days through your member zone; track them via the New Releases section or the CertkingdomPDF newsletter, and re-check your version 3-4 days before your exam. Expired products repurchase at 50% off to restart the service.
Support runs around the clock: free online consultation whenever you need it, remote guidance for installation or usage issues, and patient responses to content questions by email — suggestions are genuinely welcomed. On privacy, your purchase information is firmly protected: transactions are secured by McAfee security services, customer data is never disclosed to third parties, and no spam or telemarketing follows your order.
Delivery first: your Oracle Database 11g: Program with PL/SQL practice questions are downloadable instantly and emailed within one minute of payment — if 2 hours pass, check spam and contact support. Install on as many computers as you need. If the exam doesn't go your way, the 100% Money Back Guarantee applies: take the corresponding exam within 60 days of purchase, and if you don't pass, submit a scanned enrollment slip and your official Score Report PDF within 2 days after the exam — full refunds are processed within 7 days. Not eligible: attempts within 3 days of purchase, exams never actually taken, free items, and expired orders; the candidate name must match the payer name. Prefer to keep preparing? Exchange for two free products of equal value and retain your update service.
Oracle Database 11g: Program with PL/SQL Sample Questions:
The STRING_TAB table has the following structure:
View the Exhibit and examine the code.
What is the outcome on execution?
- A. It does not display any of the MEMS_PUTPUT messages and gives an error because a
transaction control statement cannot be used in the exception section of a procedure. - B. It displays only
This is my test string. - Because EXCEPTION should have been defined in the anonymous
block to get the error message. - C. It displays
Output buffer not long enough.
This is my test string.-. - D. It displays only
Output buffer not long enough, and exits the anonymous block.
Correct Answer: C 🗳️
View the exhibit and examine the structure of the EMPLOYEES table
The salary of EMPLOYEE_ID 195 is 2800. You execute the following code
What is the outcome?
- A. It executes successfully and displays the resultant values in the following sequence1000, 2800 50000, 2800.
- B. It gives an error because the same variable name cannot be used across all the nested blocks.
- C. It gives an error because only the innermost block is labeled.
- D. It executes successfully and displays the resultant values in the following sequence: 1000, 2800, 50000, 1000.
Correct Answer: A 🗳️
View the Exhibit and examine the package code created by SCOTT. The execute privilege on this package is granted to green.
Examine the following sequence of commands issued by SCOTT:
What is the outcome?
- A. SCOTT'S session displays 5, and then 5 again, green's session displays 0.
- B. SCOTT'S session displays 5, and then 0; green's session displays 5.
- C. SCOTT'S session displays 5, and then 5 again; green's session displays 5.
- D. SCOTT'S session displays 5, and then 0, greets session displays 0.
Correct Answer: B 🗳️
View Exhibit1 and examine the structure of the EMP table.
View Exhibit2 and examine the PIVSQL block of code.
What is the outcome?
- A. It gives an error because the record type is not defined within the function
- B. It gives an error because the function call in DBMS_OUTPUT. PUT__LINE is not valid
- C. It executes successfully but does not display the names and salaries of all employees who earn the highest salary.
- D. It gives an error because the return type is not valid.
- E. It executes successfully and displays the names and salaries of all employees who earn the highest salary.
Correct Answer: E 🗳️
View Exhibit1 and examine the structure of the EMP table.
View Exhibit2 and examine the code created by the user SCOTT:
SCOTT grants the necessary privileges to green to access the EMP table and execute the package.
Examine the following sequence of activities:
SCOTT starts a session and issues the SQL>EXEC CURS_PKG.OPEN command.
SCOTT then issues the SQL>EXEC CURS_PKG.NEXT command.
green starts a session while SCOTT's session is running and issues THE SQL>EXEC
CURS_PKG.NEXT command.
SCOTT issues the SQI>>EXEC SCOTT.CURS_PKG.NEXT command.
The EMP table contains sequential EMPNOS from 100 through 108.
Which statement correctly describes the output?
- A. SCOTT's session shows the EMPNO 100, GREEN'S session shows EMPNO 100, and SCOTT's session shows the EMPNO 101.
- B. SCOTT's session shows the EMPNO 100, GREEN'S session shows an error, and SCOTT's session shows the second EMPNO 101.
- C. SCOTT's session shows the EMPNO 100, GREEN'S session shows an error, and SCOTT's session shows an error.
- D. SCOTT's session shows the EMPNO 100, GREEN'S session shows EMPNO 101, and SCOTT's session shows the second EMPNO 102.
Correct Answer: B 🗳️
Viewing page 1 out of 21 pages.
Viewing questions 1-5 out of 103 questions.
Harold 
Ogden 
Irma 
Greg 
Paula 
Kerwin 
Hilary 
Elsa 
Nat 
Ursula 
Kyle 
Simona 
Luther 
Willie 
Sheila 
Ingrid 
