Oracle 1z1-149 Exam Details & Actual Exam Questions

  • Exam Code/Number: 1z1-149
  • Exam Name/Title: Oracle Database 19c: Program with PL/SQL
  • Certification Provider: Oracle
  • Corresponding Certification: Oracle Database PL/SQL Developer Certified Professional
  • Exam Questions: 67
  • Updated On: Aug,29 2026
  • Certification Level: Professional

Oracle Database 19c: Program with PL/SQL Exam Questions

View 1z1-149 actual exam questions, answers and explanations for free.

users 93% student found the test questions almost same

All the information you need to pass Oracle Database 19c: Program with PL/SQL 1z1-149 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
(38 Up Votes)

Oracle 1z1-149 Exam Overview:

Certification Vendor:Oracle
Exam Name:Oracle Database 19c: Program with PL/SQL
Exam Number:1Z0-149
Passing Score:Approximately 65%
Certificate Validity Period:Non-expiring (Oracle Database certification track, subject to Oracle policy updates)
Available Languages:Simplified Chinese, English, Japanese
Exam Duration:90 minutes
Exam Format:Scenario-based Questions, Multiple Response, Multiple Choice
Real Exam Qty:50-60
Related Certifications:Oracle Database 19c: SQL (1Z0-071)
Oracle PL/SQL Developer Certified Professional
Exam Price:USD 245 (may vary by region)
Recommended Training:Oracle PL/SQL Training Courses
Oracle Learning Explorer
Exam Registration:Oracle Certification Registration
Sample Questions:Oracle 1z1-149 Sample Questions
Exam Way:Online proctored or test center (Pearson VUE authorized centers)
Pre Condition:No strict prerequisite. Recommended: Oracle Database 19c: SQL (1Z0-071) or equivalent SQL knowledge.
Official Syllabus URL:https://education.oracle.com

Oracle 1z1-149 Exam Syllabus Topics:

SectionObjectives
Procedures, Functions, and Packages- Stored program units
  • 1. Packages specification and body
    • 2. Procedures and functions
      Exception Handling- Error management in PL/SQL
      • 1. User-defined exceptions
        • 2. Predefined exceptions
          Triggers- Database triggers
          • 1. Trigger timing and events
            • 2. DML triggers
              Collections and Records- PL/SQL data structures
              • 1. Associative arrays, nested tables, VARRAYs
                • 2. Records and composite types
                  PL/SQL Fundamentals- PL/SQL block structure and syntax
                  • 1. Anonymous blocks and named blocks
                    • 2. Declarations and execution sections
                      Dynamic SQL and Advanced Topics- Dynamic SQL execution
                      • 1. Native dynamic SQL usage
                        • 2. EXECUTE IMMEDIATE
                          Control Structures- Conditional logic and loops
                          • 1. IF, CASE statements
                            • 2. LOOP, WHILE, FOR loops
                              Cursors- Implicit and explicit cursors
                              • 1. Parameterized cursors
                                • 2. Cursor FOR loops


                                  0
                                  0
                                  0
                                  10