SAP

Oracle Database Program with PL/SQL (1Z0-149)

SAP

Last Updated

05 June 2026

Rating

4.7 (2160)

Exam Code: 1Z0-149
Exam Name: Oracle Database Program with PL/SQL

Passing Score: 66%
Duration: 90 Minute

ALL ITprep Provides 100% Valid Oracle Exam Questions and answers which can helps you to Pass Your Certification Exam in First Attempt.

100% Money Back Guarantee
24/7 Customer Support
Free Sample
Free 3 month Product Updates
Updated & Verified
Special Discount offer

Total Questions in Exams: 65
Total Questions in Dumps: 65

PDF Downloadable Format

2999, ($40.53) ~~5000~~

Download Sample Add To Cart

Course Description

Exam topics covered

Declaring PL/SQL Variables

Recognize valid and invalid identifiers
List the uses of variables, declare and initialize variables, use bind variables
List and describe various data types using the %TYPE and %ROWTYPE attributes

Writing Executable Statements

Identify lexical units in a PL/SQL block
Use built-in SQL functions in PL/SQL and sequences in PL/SQL expressions
Describe when implicit conversions take place and when explicit conversions have to be dealt with
Write nested blocks and qualify variables with labels
Write readable code with appropriate indentation

Writing SQL in PL/SQL

Create PL/SQL executable blocks using DML and transaction control statements
Make use of the INTO clause to hold the values returned by a SQL statement

Writing Control Structures

Identify the uses and types of control structures (IF, CASE statements and expressions)
Construct and identify loop statements
Use EXIT and CONTINUE statements inside loops

Working with Composite Data Types

Create user-defined PL/SQL records
Create a record with the %ROWTYPE attribute
Create an INDEX BY table and INDEX BY table of records
Describe the differences among records, collections, and collections of records
Initialize collections and records

Using Explicit Cursors

Distinguish between implicit and explicit cursors and use SQL cursor attributes
Declare and control explicit cursors, use simple loops and cursor FOR loops to fetch data
Declare and use cursors with parameters
Lock rows with the FOR UPDATE clause and reference the current row with the WHERE CURRENT OF clause

Handling Exceptions

Define PL/SQL exceptions
Recognize unhandled exceptions
Handle different types of exceptions (internally defined exceptions, predefined exceptions and user-defined exceptions)
Propagate exceptions

Using PL/SQL Subprograms

Differentiate between anonymous blocks and subprograms
Create a simple procedure and invoke it from an anonymous block
Identify benefits of subprograms

Creating Procedures and Using Parameters

Create a procedure with parameterrs
Use named notation
Work with procedures (create, invoke and remove procedures)
Handle exceptions in procedures and display a procedure's information

Creating Functions

Differentiate between a procedure and a function
Describe the uses of functions
Work with functions (create, invoke and remove functions)

Creating Packages

Identify the benefits and the components of packages
Work with packages (create package specification and body, invoke package subprograms, remove a package and display package information)
Overload package subprograms and use forward declarations

Working with Packages

Use package types and variables
Use packaged constants and functions in SQL
Use ACCESSIBLE BY to restrict access to package subprograms

Using Dynamic SQL

Describe the execution flow of SQL statements
Use Native Dynamic SQL (NDS)
Bind PL/SQL types in SQL statements

Design Considerations for PL/SQL Code

Create standard constants and exceptions
Write and call local subprograms
Control the run-time privileges of a subprogram
Perform autonomous transactions
Use NOCOPY hint, PARALLEL ENABLE hint and DETERMINISTIC clause
Use bulk binding and the RETURNING clause with DML

Creating Compound, DDL, and Event Database Triggers

Create triggers on DDL statements
Create triggers on system events
Describe different types of triggers and their uses

Using the PL/SQL Compiler

Describe the PL/SQL compiler and features
Use the PL/SQL compiler initialization parameters
Use the PL/SQL compile time warnings

Managing PL/SQL Code

Describe and use conditional compilation
Code-based access control: granting roles to program units
Whitelist code access with the ACCESSIBLE BY clause
Mark code as deprecated

Managing Dependencies

Track and manage procedural dependencies

Exam topics covered

Declaring PL/SQL Variables

Recognize valid and invalid identifiers
List the uses of variables, declare and initialize variables, use bind variables
List and describe various data types using the %TYPE and %ROWTYPE attributes

Writing Executable Statements

Identify lexical units in a PL/SQL block
Use built-in SQL functions in PL/SQL and sequences in PL/SQL expressions
Describe when implicit conversions take place and when explicit conversions have to be dealt with
Write nested blocks and qualify variables with labels
Write readable code with appropriate indentation

Writing SQL in PL/SQL

Create PL/SQL executable blocks using DML and transaction control statements
Make use of the INTO clause to hold the values returned by a SQL statement

Writing Control Structures

Identify the uses and types of control structures (IF, CASE statements and expressions)
Construct and identify loop statements
Use EXIT and CONTINUE statements inside loops

Working with Composite Data Types

Create user-defined PL/SQL records
Create a record with the %ROWTYPE attribute
Create an INDEX BY table and INDEX BY table of records
Describe the differences among records, collections, and collections of records
Initialize collections and records

Using Explicit Cursors

Distinguish between implicit and explicit cursors and use SQL cursor attributes
Declare and control explicit cursors, use simple loops and cursor FOR loops to fetch data
Declare and use cursors with parameters
Lock rows with the FOR UPDATE clause and reference the current row with the WHERE CURRENT OF clause

Handling Exceptions

Define PL/SQL exceptions
Recognize unhandled exceptions
Handle different types of exceptions (internally defined exceptions, predefined exceptions and user-defined exceptions)
Propagate exceptions

Using PL/SQL Subprograms

Differentiate between anonymous blocks and subprograms
Create a simple procedure and invoke it from an anonymous block
Identify benefits of subprograms

Creating Procedures and Using Parameters

Create a procedure with parameterrs
Use named notation
Work with procedures (create, invoke and remove procedures)
Handle exceptions in procedures and display a procedure's information

Creating Functions

Differentiate between a procedure and a function
Describe the uses of functions
Work with functions (create, invoke and remove functions)

Creating Packages

Identify the benefits and the components of packages
Work with packages (create package specification and body, invoke package subprograms, remove a package and display package information)
Overload package subprograms and use forward declarations

Working with Packages

Use package types and variables
Use packaged constants and functions in SQL
Use ACCESSIBLE BY to restrict access to package subprograms

Using Dynamic SQL

Describe the execution flow of SQL statements
Use Native Dynamic SQL (NDS)
Bind PL/SQL types in SQL statements

Design Considerations for PL/SQL Code

Create standard constants and exceptions
Write and call local subprograms
Control the run-time privileges of a subprogram
Perform autonomous transactions
Use NOCOPY hint, PARALLEL ENABLE hint and DETERMINISTIC clause
Use bulk binding and the RETURNING clause with DML

Creating Compound, DDL, and Event Database Triggers

Create triggers on DDL statements
Create triggers on system events
Describe different types of triggers and their uses

Using the PL/SQL Compiler

Describe the PL/SQL compiler and features
Use the PL/SQL compiler initialization parameters
Use the PL/SQL compile time warnings

Managing PL/SQL Code

Describe and use conditional compilation
Code-based access control: granting roles to program units
Whitelist code access with the ACCESSIBLE BY clause
Mark code as deprecated

Managing Dependencies

Track and manage procedural dependencies

Steps for downloading the IT Certification exam dump:

Click on “Add to Cart” button of course.

Go to Cart and click on “Checkout” Button.

Once the payment is made, you will receive a confirmation E-Mail with instant access to course.

Go to Account->My Courses.

You will see your course.

7 reviews for Oracle Database Program with PL/SQL

Samuel

March 20, 2025 at 06:37 am

1Z0-149 dumps were extremely useful. Helped me understand complex concepts easily.
Bharti Kapoor

February 17, 2025 at 07:37 pm

I cleared 1Z0-149 using ALL ITprep . Their content made the preparation process easy!
Bharti Kapoor

February 06, 2025 at 07:37 pm

I cleared 1Z0-149 with the help of ALL ITprep . The dumps were a great resource and helped me pass easily.
Isaac

January 29, 2025 at 04:21 am

1Z0-149 exam was straightforward with ALL ITprep' materials.
Mr. Kartik

January 21, 2025 at 01:32 pm

1Z0-149 exam preparation was straightforward with ALL ITprep . Their material mirrored the actual test.

WhatsApp us

Oracle Database Program with PL/SQL (1Z0-149)

Course Description

Steps for downloading the IT Certification exam dump:

7 reviews for Oracle Database Program with PL/SQL

Samuel

Bharti Kapoor

Bharti Kapoor

Isaac

Mr. Kartik

Links

Follow Us On

Subscribe to our newsletter

Disclaimer