1Z0-147 : Oracle Program With PL/SQL

Retired. This product is no longer available.

The Oracle PL/SQL Developer Certified Associate certification is an industry recognized credential. The certification is proof of person's competence and proficiency in the PL/SQL programming language and building database-centric Internet applications.
42 42
Oracle Program With PL/SQL

Here's what you will get

The certification is targeted at professionals who are involved in in building database-centric Internet applications for both Oracle9i and Oracle Database 10g. Oracle Forms Developer Certified Professionals gain greater credibility, a higher level of efficiency, and improved job performance as application developers.

Test prep
Pre-assessment Questions
Full Length Tests
Post-Assessment Questions
Exam FAQs
What is the exam registration fee? USD 245
Where do I take the exam? The 1Z0-147 exam is administered by Pearson VUE at testing centers worldwide. Click here to find a testing center near you.
What is the format of the exam? The exam consists of multiple choice questions.
What are the pre-requisites of the exam?

While there are no official prerequisites to take the Oracle PL/SQL Developer Certified Associate Certification, both Oracle and uCertify strongly recommend the following training from Oracle:

  • Oracle Database: Program with PL/SQL
How many questions are asked in the exam? The exam contains 66 questions.
What is the duration of the exam? 90 minutes
What is the passing score? 77%
What is the exam's retake policy?

Retake Policy for Oracle 1Z0-803 exam is:

  • Candidates must wait 14 days before retaking a failed proctored exam. (Registration will be allowed on the 14th day)
  • Candidates may retake an online non-proctored exam at any time.
  • Candidates may not retake a passed exam at any time.
  • Candidates may not retake a beta exam at any time.

Click here for more information.

What is the validity of the certification? The Oracle PL/SQL Developer Certified Associate certification has no expiration. The certification holder is certified for life unless Oracle changes their policy. Click here for more information.
Where can I find more information about this exam? To know more about the 1Z0-147, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?
  • PL/SQL Developer
  • Technical Consultant
  • System Analysts
  • Application Developer

Here's what you will learn

  • Describe a PL/SQL program construct
  • List the components of a PL/SQL block
  • List the benefits of subprograms
  • Describe how a stored procedure/function is invoked
  • Define what a stored procedure is
  • List the development steps for creating a procedure
  • Create a procedure
  • Describe the differences between formal and actual parameters
  • List the types of parameter modes
  • List the methods for calling a procedure with parameters
  • Describe the DEFAULT option for parameters
  • Create a procedure with parameters
  • Invoke a procedure that has parameters
  • Define a subprogram in the declarative section of a procedure
  • Describe how exceptions are propagated
  • Remove a procedure
  • Define what a stored function is
  • Create a function
  • List how a function can be invoked
  • List the advantages of user-defined functions in SQL statements
  • List where user-defined functions can be called from within an SQL statement
  • Describe the restrictions on the calling functions from SQL statements
  • Remove a function
  • Describe the differences between procedures and functions
  • Contrast system privileges with object privileges
  • Grant privileges
  • Contrast invokers rights with definers rights
  • Identify views in the data dictionary to manage stored objects
  • Use the DESCRIBE command to describe packages and list their possible components
  • Identify a package specification and body
  • Create packages: Create related variables, cursors, constants, exceptions, procedures, and functions
  • Designate a package construct as either public or private
  • Invoke a package construct
  • Use a bodiless package
  • Drop Packages
  • Identify the benefits of Packages
  • Write packages that use the overloading feature
  • Use Forward Referencing
  • Describe errors with mutually referential subprograms
  • Initialize variables with a one-time-only procedure
  • Identify persistent states in package variables and cursors
  • Identify restrictions on using packaged functions in SQL statements
  • Invoke packaged functions from SQL
  • Use PL/SQL tables and records in Packages
  • Describe the benefits of Execute Immediate over DBMS_SQL for Native Dynamic SQL
  • Identify the flow of execution
  • Describe the use and application of some Oracle ...pplied packages: DBMS_SQL, DBMS_OUTPUT, UTL_FILE
  • Compare and contrast LONG and large object (LOB) data types
  • Describe LOB datatypes and how they are used
  • Differentiate between internal and external LOBs
  • Identify and Manage Bfiles
  • Migrate from LONG to LOB
  • Use the DBMS_LOB PL/SQL package
  • Create LOB columns and populate them
  • Perform SQL operations on LOBS: Update LOBs with SQL, Select from LOBS, Delete LOBS
  • Describe the use of temporary LOBs
  • Describe the different types of triggers
  • Describe database triggers and their uses
  • List guidelines for designing triggers
  • Create a DML trigger
  • List the DML trigger components
  • Describe the trigger firing sequence options
  • Use conditional predicates in a DML trigger
  • Create a row level trigger
  • Create a statement level trigger
  • Use the OLD and NEW qualifiers in a database trigger
  • Create an INSTEAD OF trigger
  • Describe the difference between stored procedures and triggers
  • Describe the trigger execution model
  • Alter a trigger status
  • Remove a trigger
  • Define what a database trigger is
  • Describe events that cause database triggers to fire
  • Create a trigger for a DDL statement
  • Create a trigger for a system event
  • Describe the functionality of the CALL statement
  • Describe the cause of a mutating table
  • List what triggers can be implemented for
  • List the privileges associated with triggers
  • View trigger information in the dictionary views
  • Track procedural dependencies
  • Describe dependent objects and referenced objects
  • View dependency information in the dictionary views
  • Describe how the UTLDTREE script is used
  • Describe how the IDEPTREE and DEPTREE procedures are used
  • Describe a remote dependency
  • List how remote dependencies are governed
  • Describe when a remote dependency is unsuccessfully recompiled
  • Describe when a remote dependency is successfully recompiled
  • List how to minimize dependency failures
  • DOWNLOADcourse outline
  • INSTRUCTOR ?free evaluation copy
  • Download Course Outline 1Z0-147
  • Request for free evaluation copy for Oracle Program With PL/SQL
  • Customer Testimonials

    I went into the examination room with the confidence that I needed to pass. I?m an Oracle 9i Internet Application Developer after breaking oracle 9i exam 1Z0-147. It helped me to focus on the prime objectives and work on my weak areas. Additional help has been provided through a plenty of helpful r
    Marisol Eastman