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 Questions & Answers as PDF & Test Engine
Updated: Oct 11, 2026
No. of Questions: 67 Questions & Answers with Testing 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
Knowing whether time is enough should happen before exam day, not during it. Timed sessions with ActualVCE turn pacing anxiety into pacing data.
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 Duration: | 90 minutes |
| Certificate Validity Period: | Lifetime |
| Available Languages: | English |
| Real Exam Qty: | 65 |
| Exam Price: | USD $245 |
| Passing Score: | 66% |
| Exam Format: | Scenario-Based Questions, Multiple Choice |
| Recommended Training: | Oracle Database 19c: Program with PL/SQL |
| Exam Registration: | Pearson VUE Scheduling Oracle University Registration |
| 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 |
|---|---|---|
| Creating Triggers | 8% | - Trigger restrictions and ordering - DML and INSTEAD OF triggers - DDL and system event triggers |
| Writing Control Structures | 10% | - Sequential control - Conditional statements - Iterative and loop statements |
| Handling Exceptions | 8% | - Exception propagation and handling - Predefined exceptions - User-defined exceptions |
| Writing SQL in PL/SQL | 12% | - Record types, %ROWTYPE, and collections - DML and transaction control statements - SELECT ... INTO clause usage |
| Managing PL/SQL Code | 8% | - ACCESSIBLE BY clause and access control - Conditional compilation - Dependency tracking and management - Performance optimizations: BULK COLLECT, FORALL |
| Writing Executable Statements | 10% | - Lexical units in PL/SQL blocks - Implicit and explicit data type conversion - Nested blocks and variable scoping - SQL functions and sequences in PL/SQL |
| Using Explicit Cursors | 10% | - Cursor attributes and FOR loops - Implicit vs explicit cursors - Cursor variables |
| Creating Procedures and Functions | 12% | - Parameter modes: IN, OUT, IN OUT - Creation and invocation of subprograms - Function return types and usage |
| Declaring PL/SQL Variables | 10% | - Data types, %TYPE and %ROWTYPE attributes - Variables, initialization, and bind variables - Valid and invalid identifiers |
| Working with Packages | 12% | - Package specification and body - Package variables, constants, and cursors - Overloading subprograms |
Oracle Database 19c: Program with PL/SQL Exam: Demo First, Decide Second
Recommended: Pass Oracle Database SQL Certified Associate (1Z0-071) or equivalent SQL knowledge Since requirements change over time, confirm the latest on the official Oracle exam page before scheduling.
The Oracle Database 19c: Program with PL/SQL exam contains 65 to complete within 90 minutes. Timed simulation in the ActualVCE Desktop Test Engine teaches that rhythm before exam day does.
The official Oracle Database 19c: Program with PL/SQL outline defines 10 domains. The leading three are Managing PL/SQL Code (8%), Working with Packages (12%), and Declaring PL/SQL Variables (10%). The full list is in the topics section above, and ActualVCE's 67 practice questions cover each one.
Online proctored or onsite at Pearson VUE testing centers Register for the Oracle Database 19c: Program with PL/SQL exam through these official channels:
After booking, ActualVCE delivers your practice questions within 1 minute — preparation starts the same day.
The Oracle Database 19c: Program with PL/SQL exam requires 66% to pass, and registration costs USD $245. A failed attempt means paying the same fee again — a readiness check with the ActualVCE engines before booking is the cheaper option.
The 1z1-149 exam is a Oracle certification exam validating the Oracle Database 19c: Program with PL/SQL syllabus shown above. It belongs to these credential paths: Oracle Database SQL Certified Associate. Candidates in 2026 start with ActualVCE's 67 practice questions, available as a printable PDF, a Windows Desktop Test Engine, and an Online Test Engine — three versions of the same materials.
Oracle recommends these training resources for the Oracle Database 19c: Program with PL/SQL exam:
Follow the training with steady self-testing — the 67 practice questions from ActualVCE help you apply theory and fill any gaps the training leaves.
ActualVCE issues a full refund if you take the Oracle Database 19c: Program with PL/SQL exam within 60 days of purchase and do not pass. 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 and keep your original update service. Orders arrive by email within 1 minute — contact support if nothing arrives within 2 hours.
Three versions of the same study materials: a printable, expert-prepared PDF with free demo download and instant access; a Desktop Test Engine for Windows with customizable simulation and timed modes that works offline; and an Online Test Engine for any browser on Windows, Mac, Android, and iOS with test history and performance review. All 67 practice questions are identical across versions. Every purchase includes 365 days of free updates, a 50% renewal discount afterward, and unlimited computer installations.
Oracle Database 19c: Program with PL/SQL Sample Questions:
Which three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with %ROWTYPE? (Choose three.)
- A. CREATE
- B. SELECT
- C. UPDATE
- D. DELETE
- E. DROP
- F. ALTER
- G. INSERT
Correct Answer: B,C,G 🗳️
Which two are true about INDEX-BY tables? (Choose two.)
- A. INDEX-BY table types can be created in PL/SQL blocks only.
- B. INDEX-BY table types can be created with the CREATE TYPE statement.
- C. INDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.
- D. The index can be integer or string.
- E. The index can be integer only.
Correct Answer: A,D 🗳️
User ORA41 executes these statements successfully:
Now, examine this statement which is executed successfully by user ORA61 after a successful login:
EXECUTE ora41.update_emp_proc(100,25000);
Which two are true? (Choose two.)
- A. The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA41.
- B. No update happens even though the procedure executes successfully.
- C. ORA61 will have been granted the UPDATE privilege explicitly on ORA41.EMPLOYEES before executing the statement.
- D. The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA61.
- E. The UPDATE privilege on ORA41.EMPLOYEES is not inherited by ORA61 through the procedure.
Correct Answer: D,E 🗳️
Which is true about counter variables in a FOR loop?
- A. It must explicitly be declared.
- B. It can be modified in the body of the loop.
- C. It cannot be NULL.
- D. It is accessible outside the body of the loop.
Correct Answer: C 🗳️
Which two are true about the PLSQL_CODE_TYPE parameter? (Choose two.)
- A. Changing the parameter setting automatically changes the setting for existing PL/SQL library units.
- B. If set to NATIVE, programs are stored in a PL/SQL bytecode format.
- C. If set to NATIVE, programs are stored in platform dependent machine code.
- D. The default value is NATIVE.
- E. It can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.
Correct Answer: C,E 🗳️
Viewing page 1 out of 14 pages.
Viewing questions 1-5 out of 67 questions.
1192 Customer ReviewsCustomers Feedback (* Some similar or old comments have been hidden.)
At last, the 1z1-149 dumps that are valid and help. I could also tell the dumps were updated regularly because most of the exam questions were from them. Using them was worth it.
Joseph
Thanks for your 1z1-149 practice questions.
Jason
Most of the questions are in the 1z1-149 dumps, but some answers are in correct.
Andrew
I read all your 1z1-149 questions and answers.
Hugo
I just pass 1z1-149 exam. I'm busy with my work, but ActualVCE really helped me save much time. Greatful!
Cedric
Some 1z1-149 exam questions are so likely and you should pay more attention on them. Outstanding 1z1-149 exam files!
Laura
I've finished my 1z1-149 examination. The questions from ActualVCE are almost indentical to the questions that were in my 1z1-149 exam. Thank you very much for providing with the best exam materials!
Deborah
Cool 1z1-149 study materials! I got a high score on this subject. Many thanks! Latest and helpful!
Bing
All the questions are from your 1z1-149 training material.
Kerwin
Great value for money spent. Pdf file for 1z1-149 certification exam contains detailed study materials and very similar exam questions.
Harlan
I passed the exam today. Most of the questions from 1z1-149 exam dumps came in the exam. I was lucky to find ActualVCE.
Mark
Passing 1z1-149 exam is hard for me, thanks for my firend introduce 1z1-149 exam materials to me, It help me pass my exam in a short time.
Deborah
Thank you for your help. It is the most useful 1z1-149 exam material i have used. I got full marks. It is amazing. Thanks again!
Mandy
It covers everything on the exam. Content all seems accurate to me. 1z1-149 exam is good dump.
Marsh
I just completed my 1z1-149 exam today and wanted to share the great news.
Tracy
By logging on to your website, I felt so relaxed and calm it guided me very properly regarding 1z1-149 exam.
Merle
98% of the exam are from these real exam questions.
Dale
The concrete knowledge was really interesting and kept me fresh through out the 1z1-149 preparations. I have already recommended your products to my friends and I will recommend where ever I will get a chance. Thanks!
Tiffany
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.
