Exam Name: Oracle Database 19c: Program with PL/SQL
Certification Provider: Oracle
Corresponding Certification: Oracle Database PL/SQL Developer Certified Professional
Over 42920+ Satisfied Customers
Instant Download Oracle : 1z1-149
Check Updated on: Oct 11, 2026
No. of Questions: 67 Questions & Answers with Exam 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
ActualVCE 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 exam practice material
- Three formats are optional
- 10+ years of excellence
- 365 Days Free Updates
- Learn anywhere, anytime
- 100% Safe shopping experience
Authoritative material is not a slogan — it is a process. The 1z1-149 bank at ActualVCE is authored and maintained by a large team of subject professionals, updated continuously, and supported by 67 practice questions whose answers are verified before they reach you.
Oracle 1z1-149 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Oracle Database 19c: Program with PL/SQL |
| Exam Number: | 1Z0-149 |
| Related Certifications: | Oracle Database SQL Certified Associate |
| Exam Format: | Multiple Choice, Scenario-Based Questions |
| Real Exam Qty: | 65 |
| Passing Score: | 66% |
| Certificate Validity Period: | Lifetime |
| Exam Duration: | 90 minutes |
| Available Languages: | English |
| Exam Price: | USD $245 |
| Recommended Training: | Oracle Database 19c: Program with PL/SQL |
| Exam Registration: | Oracle University Registration Pearson VUE Scheduling |
| Sample Questions: | DOWNLOAD DEMO |
| Exam Way: | Online proctored or onsite at Pearson VUE testing centers |
| Pre Condition: | Recommended: Pass Oracle Database SQL Certified Associate (1Z0-071) or equivalent SQL knowledge |
| Official Syllabus URL: | https://education.oracle.com/oracle-database-19c-program-with-pl-sql/pexam_1Z0-149 |
Oracle 1z1-149 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Managing PL/SQL Code | 8% | - Performance optimizations: BULK COLLECT, FORALL - Dependency tracking and management - ACCESSIBLE BY clause and access control - Conditional compilation |
| Topic 2: Declaring PL/SQL Variables | 10% | - Variables, initialization, and bind variables - Data types, %TYPE and %ROWTYPE attributes - Valid and invalid identifiers |
| Topic 3: Writing Executable Statements | 10% | - Lexical units in PL/SQL blocks - Implicit and explicit data type conversion - SQL functions and sequences in PL/SQL - Nested blocks and variable scoping |
| Topic 4: Working with Packages | 12% | - Package specification and body - Overloading subprograms - Package variables, constants, and cursors |
| Topic 5: Using Explicit Cursors | 10% | - Cursor variables - Implicit vs explicit cursors - Cursor attributes and FOR loops |
| Topic 6: Creating Procedures and Functions | 12% | - Creation and invocation of subprograms - Function return types and usage - Parameter modes: IN, OUT, IN OUT |
| Topic 7: Writing Control Structures | 10% | - Sequential control - Conditional statements - Iterative and loop statements |
| Topic 8: Handling Exceptions | 8% | - Exception propagation and handling - Predefined exceptions - User-defined exceptions |
| Topic 9: Creating Triggers | 8% | - Trigger restrictions and ordering - DML and INSTEAD OF triggers - DDL and system event triggers |
| Topic 10: Writing SQL in PL/SQL | 12% | - Record types, %ROWTYPE, and collections - DML and transaction control statements - SELECT ... INTO clause usage |
1z1-149 Exam Questions — Answered
Three full versions of the 67 practice questions for the Oracle Database 19c: Program with PL/SQL exam, all in one moderately priced package: a printable, expert-prepared PDF with instant download; a Desktop Test Engine for Windows that simulates the real exam with two practice modes and works offline; and an Online Test Engine for any browser on Windows, Mac, Android, and iOS with test history and performance review. You also receive a free demo, 365 days of free updates, a 50% renewal discount afterward, and unlimited computer installations.
The passing score for the Oracle Database 19c: Program with PL/SQL exam is 66%, and registration runs USD $245. Retakes mean paying again, so it pays to check your readiness first — the ActualVCE engines show your level honestly before you book.
Oracle recommends these training resources for the Oracle Database 19c: Program with PL/SQL exam:
Combine the official training with the 67 practice questions from ActualVCE — the questions reveal how well the training actually settled.
The Oracle Database 19c: Program with PL/SQL exam gives you 90 minutes to answer 65. Time management is part of the test — rehearse with the timed mode in the ActualVCE Desktop Test Engine until pacing becomes automatic.
Yes, under written conditions. Take the Oracle Database 19c: Program with PL/SQL exam within 60 days of purchase, and if you do not pass, ActualVCE refunds you in full. The policy does not apply if the exam is taken within 3 days of purchase, if the exam was never actually taken, or to free materials or expired orders, and the candidate name must match the payer name. Submit a scan of your enrollment slip and the official Score Report PDF within 2 days of the exam; claims are processed within 7 days. Alternatively, exchange for two free exam products of equal value while keeping your original update service. Orders are delivered by email within 1 minute — if nothing arrives within 2 hours, contact support.
The 1z1-149 exam is an official Oracle certification exam covering the Oracle Database 19c: Program with PL/SQL syllabus detailed above. It counts toward these credentials: Oracle Database SQL Certified Associate. As the certification grows more important in its field, the exam stays demanding — which is exactly why structured practice matters. ActualVCE prepares you with 67 practice questions in PDF, Desktop Test Engine, and Online Test Engine formats.
Online proctored or onsite at Pearson VUE testing centers Sign up for the Oracle Database 19c: Program with PL/SQL exam through these official channels:
Booked? Your ActualVCE practice questions arrive by email within 1 minute, so the countdown to exam day can start immediately.
Recommended: Pass Oracle Database SQL Certified Associate (1Z0-071) or equivalent SQL knowledge Since policies evolve, confirm the current requirements on the official Oracle exam page before scheduling.
The official Oracle Database 19c: Program with PL/SQL outline defines 10 content domains. The three heaviest are Creating Triggers (8%), Handling Exceptions (8%), and Writing Control Structures (10%). The full list is in the topics section above, and the 67 practice questions at ActualVCE cover each domain.
Oracle Database 19c: Program with PL/SQL Sample Questions:
Which two are true about using the ACCESSIBLE BY clause? (Choose two.)
- A. It can be used in the declaration of object types.
- B. It must be specified in the heading of a package specification.
- C. The check is enforced by this clause for direct access and access through dynamic SQL.
- D. It must be specified in the heading of a package body.
- E. It can be used for individual procedures and functions declared in a package specification.
Correct Answer: A,E 🗳️
Explanation: Only visible for ActualVCE members. You can sign-up / login (it's free).
Which three are true about PL/SQL subprograms? (Choose three.)
- A. Users granted execute privilege on a procedure compiled with definer's rights require grants to access objects belonging to the definer that are referenced in the procedure.
- B. Subprograms are cached by default and shared among users, thereby reducing memory requirements.
- C. A subprogram's session state is retained even if any of the session's instantiated subprograms are invalidated and revalidated.
- D. Results of a subprogram can be cached in the SGA such that sessions connected to the same instance can reuse these results when available.
- E. Reuse of parsed PL/SQL code from the shared SQL area reduces parsing overhead.
- F. Host variables can be referenced inside any PL/SQL subprogram.
- G. A PL/SQL procedure can invoke an external code block written in a different programming language.
Correct Answer: B,E,G 🗳️
Which is true about EXIT and CONTINUE statements?
- A. They have the same effect on the execution of a loop.
- B. They must have a WHEN condition.
- C. They must use labels.
- D. They can be used in any type of loop.
Correct Answer: D 🗳️
Which two are true about named notations in a PL/SQL subprogram? (Choose two.)
- A. Specifying actual parameters in the wrong order results in the subprogram terminating with an exception.
- B. Only trailing optional parameters can be omitted in the invocation call.
- C. The subprogram invocations must be changed when the formal parameter list acquires new required parameters.
- D. The actual parameters must be specified in the same order as the formal parameters are declared.
- E. Any optional parameters can be omitted in the invocation call.
Correct Answer: D,E 🗳️
Which code will successfully create a BODILESS PACKAGE to standardize CONSTANTS and EXCEPTIONS declarations?
- A.
- B.
- C.
- D.
Correct Answer: B 🗳️
Viewing page 1 out of 14 pages.
Viewing questions 1-5 out of 67 questions.
994 Customer ReviewsCustomers Feedback (* Some similar or old comments have been hidden.)
I wasn't sure of my success when I started preparing for 1z1-149 certification exam. But ActualVCE's state of the art study guide Secured the best certification of my career!
Monica
Exam testing software is the best. Purchased the bundle file for 1z1-149 and scored 92% marks in the exam. Thank you ActualVCE for this amazing tool.
Tiffany
ActualVCE is the best website i have ever visited. Your services are very prompt and helped me a lot. I passed my 1z1-149 exam with high marks! So joyful!
Cliff
I took the 1z1-149 exam on Monday. Well the good news is that I have passed 1z1-149 exam. The dumps from ActualVCE is very helpful for me.
Antonia
I think I must give my positive feedback on ActualVCE practice tests. I do not feel that I could get such high grades without ActualVCE real exam questions and answer
Maximilian
great Oracle help! Still valid.
Sebastian
There was a decent amount of these questions in my exam. Use 1z1-149 exam cram along which is sufficient to pass.
Belinda
Really really really want to share with the ActualVCE to you, i am not a new customer!
Ivan
I used all the time I could save from other responsibilities and using 1z1-149 exam preparation materials.
Hunter
Only 2 news question are out of the 1z1-149 exam guide. I have confidence in other questions. And I pass the 1z1-149 exam with a wonderful score! Much appreciated!
Joshua
I passed the 1z1-149 exam last week with your help. If there are someone looking for a good material to guide your certification exam, this is a good choice.
Regina
I have some trouble in understanding the 1z1-149 exam, with the help of ActualVCE, i totally understand it, and passed it yesterday.
Simon
I have already registered for the exam (taking it this weekend) and it went smooth as you assured.
Cyril
Passed 1z1-149 exam yesterday with 96% points! Actually i was preparing this exam since a week ago, so it´s the reason i did it easily. Highly recommend!
Nelson
After studying all the 1z1-149 exam questions from ActualVCE, I have passed the 1z1-149 exam with good marks. Thanks!
Ruby
Related Exams
Instant Download 1z1-149
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.
