Oracle 1Z0-149 Exam Topics

Oracle 1Z0-149 Exam Overview :

Exam Name:	Oracle Database 19c: Program with PL/SQL
Exam Code:	1Z0-149
Certifications:	Oracle PL/SQL Developer Certified Professional Certification
Actual Exam Duration:	90 minutes
Expected no. of Questions in Actual Exam:	65
See Expected Questions:	Oracle 1Z0-149 Expected Questions in Actual Exam

Oracle 1Z0-149 Exam Objectives :

Section	Objectives
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
Official Information	https://education.oracle.com/oracle-database-19c-program-with-pl-sql/pexam_1Z0-149

Updates in the Oracle 1Z0-149 Exam Topics:

Oracle 1Z0-149 exam questions and practice test are the best ways to get fully prepared. Study4exam's trusted preparation material consists of both practice questions and practice test. To pass the actual Oracle PL/SQL Developer Certified Professional 1Z0-149 exam on the first attempt, you need to put in hard work on these questions as they cover all updated Oracle 1Z0-149 exam topics included in the official syllabus. Besides studying actual questions, you should take the Oracle 1Z0-149 practice test for self-assessment and actual exam simulation. Revise actual exam questions and remove your mistakes with the Oracle Database 19c: Program with PL/SQL 1Z0-149 exam practice test. Online and Windows-based formats of the 1Z0-149 exam practice test are available for self-assessment.

Limited Time Offer

50%

Off

Get Premium 1Z0-149 Questions as Interactive Practice Test or PDF