1. Home
  2. Oracle
  3. 1Z0-149 Exam Syllabus

Oracle 1Z0-149 Exam Syllabus

Start Free 1Z0-149 Exam Practice After Reviewing the Topics

Before starting your 1Z0-149 exam preparation, it is recommended to review the complete Oracle Database 19c: Program with PL/SQL exam syllabus and carefully go through the exam objectives listed below. Once you understand the exam structure and objectives, you should practice using our free 1Z0-149 questions. We also provide premium 1Z0-149 practice test, fully updated according to the latest exam objectives, to help you accurately assess your preparedness for the actual exam.

Oracle
Vendor
1Z0-149
Exam Code
65
Total Questions
18
Total Exam Domains

START FREE 1Z0-149 EXAM PRACTICE

NO SIGNUP REQUIRED  •  100% FREE TO START

1Z0-149 EXAM QUESTIONS

Oracle 1Z0-149 Exam Objectives

Section 1: Declaring PL/SQL Variables
Weight:
-
  •     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
Section 2: Writing Executable Statements
Weight:
-
  •     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
Section 3: Writing SQL in PL/SQL
Weight:
-
  •     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
Section 4: Writing Control Structures
Weight:
-
  •     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
Section 5: Working with Composite Data Types
Weight:
-
  •     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
Section 6: Using Explicit Cursors
Weight:
-
  •     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
Section 7: Handling Exceptions
Weight:
-
  •     Define PL/SQL exceptions
  •     Recognize unhandled exceptions
  •     Handle different types of exceptions (internally defined exceptions, predefined exceptions and user-defined exceptions)
  •     Propagate exceptions
Section 8: Using PL/SQL Subprograms
Weight:
-
  •     Differentiate between anonymous blocks and subprograms
  •     Create a simple procedure and invoke it from an anonymous block
  •     Identify benefits of subprograms
Section 9: Creating Procedures and Using Parameters
Weight:
-
  •     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
Section 10: Creating Functions
Weight:
-
  •     Differentiate between a procedure and a function
  •     Describe the uses of functions
  •     Work with functions (create, invoke and remove functions)
Section 11: Creating Packages
Weight:
-
  •     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
Section 12: Working with Packages
Weight:
-
  •     Use package types and variables
  •     Use packaged constants and functions in SQL
  •     Use ACCESSIBLE BY to restrict access to package subprograms
Section 13: Using Dynamic SQL
Weight:
-
  •     Describe the execution flow of SQL statements
  •     Use Native Dynamic SQL (NDS)
  •     Bind PL/SQL types in SQL statements
Section 14: Design Considerations for PL/SQL Code
Weight:
-
  •     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
Section 15: Creating Compound, DDL, and Event Database Triggers
Weight:
-
  •     Create triggers on DDL statements
  •     Create triggers on system events
  •     Describe different types of triggers and their uses
Section 16: Using the PL/SQL Compiler
Weight:
-
  •     Describe the PL/SQL compiler and features
  •     Use the PL/SQL compiler initialization parameters
  •     Use the PL/SQL compile time warnings
Section 17: Managing PL/SQL Code
Weight:
-
  •     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
Section 18: Managing Dependencies
Weight:
-
  •     Track and manage procedural dependencies
Info
https://education.oracle.com/oracle-database-19c-program-with-pl-sql/pexam_1Z0-149