Oracle Database 11g: Program with PL/SQL (1Z0-144) Practice Exam

Oracle Database 11g: Program with PL/SQL (1Z0-144)

About Oracle Database 11g: Program with PL/SQL (1Z0-144)

1Z0-144 exam will you in becoming Oracle Advanced PL/SQL Developer Certified Professional and Oracle PL/SQL Developer Certified Associate. In which the Oracle PL/SQL Developer Certified Associates demonstrate expertise in building database-centric Internet applications for Oracle Database 10g, 11g and 12c. 

Course Structure

1 Oracle Database 11g: PL/SQL Fundamentals

The Oracle Database 11g: Program with PL/SQL (1Z0-144) Exam covers the following topics - 

• Introduction to PL/SQL

• Explain the need for PL/SQL

• Explain the benefits of PL/SQL

• Identify the different types of PL/SQL blocks

• Output messages in PL/SQL

• 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 attribute

• 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

• Interacting with the Oracle Database Server

• 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

• Apply guidelines when using conditional control structures

• 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, tables, and tables of records

• Using Explicit Cursors

• Distinguish between usage of implicit and explicit cursors, 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

• Propagate exceptions in nested blocks and call applications

• Creating Stored Procedures and Functions

• Differentiate between anonymous blocks and subprograms

• Create a simple procedure and invoke it from an anonymous block

• Create a simple function

• Create a simple function that accepts a parameter

• Differentiate between procedures and functions

2 Oracle Database 11g: Develop PL/SQL Program Units

• Creating Procedures

• Differentiate between anonymous blocks and subprograms, use a modularized and layered subprogram design, and identify the benefits of subprograms

• Create a simple procedure and invoke it from an anonymous block

• Work with procedures

• Handle exceptions in procedures, remove a procedure, 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)

• Working with Packages

• Overload package subprograms, use forward declarations

• Create an initialization block in a package body

• Manage persistent package data states for the life of a session and use PL/SQL tables and records in packages

• Using Oracle-Supplied Packages in Application Development

• Describe how the DBMS_OUTPUT package works

• Use UTL_FILE to direct output to operating system files

• Describe the main features of UTL_MAIL

• Using Dynamic SQL

• Describe the execution flow of SQL statements

• Use Native Dynamic SQL (NDS)

• Use the DBMS_SQL package

• 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 Triggers

• Describe different types of triggers and their uses

• Create database triggers

• Manage triggers

• Creating Compound, DDL, and Event Database Triggers

• Create triggers on DDL statements

• Create triggers on system events

Exam Pattern 

• Exam Name: Oracle Database 11g: Program with PL/SQL
• Exam Code: 1Z0-144
• Number of Questions: 63
• Length of Time:  90 minutes
• Exam Fee $245 USD 
• Exam Language: English

What do we offer?

• Full-Length Mock Test with unique questions in each test set

• Practice objective questions with section-wise scores

• An in-depth and exhaustive explanation for every question

• Reliable exam reports evaluating strengths and weaknesses

• Latest Questions with an updated version

• Tips & Tricks to crack the test

• Unlimited access

What are our Practice Exams?

• Practice exams have been designed by professionals and domain experts that simulate real time exam scenario.

• Practice exam questions have been created on the basis of content outlined in the official documentation.

• Each set in the practice exam contains unique questions built with the intent to provide real-time experience to the candidates as well as gain more confidence during exam preparation.

• Practice exams help to self-evaluate against the exam content and work towards building strength to clear the exam.

• You can also create your own practice exam based on your choice and preference 

100% Assured Test Pass Guarantee

We have built the TestPrepTraining Practice exams with 100% Unconditional and assured Test Pass Guarantee! 

If you are not able to clear the exam, you can ask for a 100% refund.