Oracle 1Z0-149 Exam Details & Actual Exam Questions

Exam Code/Number: 1Z0-149
Exam Name/Title: Oracle Database 19c: Program with PL/SQL
Certification Provider: Oracle
Corresponding Certification: Oracle Database PL/SQL Developer Certified Professional

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

92% student found the test questions almost same

All the information you need to pass Oracle Database 19c: Program with PL/SQL 1Z0-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

(42 Up Votes)

Certification Vendor:	Oracle
Exam Name:	Oracle Database 19c: Program with PL/SQL
Exam Number:	1Z0-149
Exam Format:	Multiple choice
Real Exam Qty:	60
Exam Price:	USD 245
Exam Duration:	120 minutes
Available Languages:	Japanese, English
Certificate Validity Period:	Does not expire
Related Certifications:	Oracle Database PL/SQL Developer Certified Professional
Passing Score:	68%
Sample Questions:	Oracle 1Z0-149 Sample Questions
Exam Way:	Online proctored exam or in-person testing through Oracle-authorized testing providers.
Pre Condition:	No mandatory prerequisite. Knowledge of SQL and Oracle Database fundamentals is strongly recommended.
Official Syllabus URL:	https://education.oracle.com/oracle-database-19c-program-with-pl-sql/pexam_1Z0-149

Section	Objectives
Control Structures and Composite Data Types	- Advanced Programming Elements 1. Collections 2. VARRAYs 3. Nested Tables 4. Associative Arrays 5. Records
Handle Exceptions	- Error Management 1. RAISE Statement 2. User-Defined Exceptions 3. Exception Propagation 4. Predefined Exceptions
Use Explicit Cursors	- Cursor Processing 1. Cursor FOR Loops 2. Cursor Attributes 3. Parameterized Cursors 4. Explicit Cursors
Write Executable Statements	- Program Structure 1. PL/SQL Blocks 2. Loop Constructs 3. Operators and Expressions 4. Conditional Processing
Declare and Use Variables	- PL/SQL Variable Fundamentals 1. Identifiers and Naming Rules 2. Bind Variables 3. Anchored Declarations 4. Scalar Data Types
Interact with the Oracle Database Server	- SQL in PL/SQL 1. SELECT Statements 2. Transaction Control 3. DML Statements 4. SQL Functions in PL/SQL
Manage Dependencies and Security	- Program Unit Administration 1. Granting Execute Privileges 2. Dependency Management 3. Invoker Rights and Definer Rights
Use Dynamic SQL and Bulk Processing	- Performance-Oriented Programming 1. BULK COLLECT 2. FORALL Statement 3. Native Dynamic SQL 4. Bulk Exception Handling
Create Stored Procedures, Functions, Packages and Triggers	- Database Program Units 1. Database Triggers 2. Functions 3. Packages 4. Stored Procedures