Oracle's 1Z0-147

Program with PL/SQL

• 100% Exam Coverage • Interactive E-Book • Pre-Assessment Test • 346 Practice Questions with Full Explanations • 119 Interactive Quizzes • Chapter by Chapter Study Guide & Notes • Articles, How Tos, Tips, Flash Cards • Test History and Performance Review and Powerful Analytics • Study Planner • Continuously Updated

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. uCertify’s guaranteed certification prep for 1Z0-147 is comprehensive and helps you not only earn your certification in the shortest time possible, but to also gain the knowledge required on the job. Here’s what to expect from your uCertify prepkit:

Oracle 1Z0-147 test prep and exam questions 100% test pass guarantee

100% Test Pass Guarantee.

You will pass your exam in the first attempt or we will refund your money in full. Read More...
 Buy Now Try it Online
Or Download

The 1Z0-147 is an optional part of Oracle's PL/SQL Developer Certified Associate certification.Candidates must go through a few steps before earning this certification.

The 1Z0-147 exam also provides credit towards the Oracle Advanced PL/SQL Developer Certified Professional certification.

The 1Z0-147 is targeted at professionals who are involved in database-centric Internet applicationsfor 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 from this certification.

Skills Measured

  • PL/SQL fundamentals
  • Creation of functions, Procedures, Packages, and triggers
  • Interaction with the Oracle Database Server
  • Declaration of Variables
  • Management of Dependencies
  • ExceptionHandling

Related Certifications

1Z0-147 Course Duration

This is a self-paced, independent study program, so there are no minimum or maximum restrictions placed by uCertify. The amount of time you will take depends on your existing knowledge of the area and related experience, as well as your availability. We recommend at least 2 weeks if you have a reasonable knowledge of PL/SQL Programming language and related work experience.

Related Exams

1Z0-147 Course/Exam Objectives

  • Chapter 1: Overview of PL/SQL Programs
    • 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
  • Chapter 2: Creating Procedures
    • 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
  • Chapter 3: Creating Functions
    • 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
  • Chapter 4: Managing Subprograms
    • Contrast system privileges with object privileges
    • Grant privileges
    • Contrast invokers rights with definers rights
    • Identify views in the data dictionary to manage stored objects
  • Chapter 5: Creating Packages
    • 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
  • Chapter 6: More Package Concepts
    • 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
  • Chapter 7: Oracle Supplied Packages
    • Describe the benefits of Execute Immediate over DBMS_SQL for Native Dynamic SQL
    • Identify the flow of execution
    • Use EXECUTE IMMEDIATE
    • Describe the use and application of some Oracle ...pplied packages: DBMS_SQL, DBMS_OUTPUT, UTL_FILE
  • Chapter 8: Manipulating Large Objects
    • 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
  • Chapter 9: Creating Database Triggers
    • 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
  • Chapter 10: More Trigger Concepts
    • 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
  • Chapter 11: Managing Dependencies
    • 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

Career Prospects

An Oracle's PL/SQL Developer Certified Associate has several career opportunities open up to them, including:

  • PL/SQL Developer
  • Database Developer
  • Forms developer
  • Portal Developer
  • Technical Consultant
  • System Analysts
  • Application Developer

1Z0-147 Exam FAQ's

What certificate do I earn on passing the vendor certificationS?
If you pass Oracle's 1Z0-147 exam you will get credit towards the following certificationS:
What is the exam registration fee?
195
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.
How many questions are asked on the exam?
The exam contains 66 questions.
What is the duration of the exam?
90 minutes
What is the exam's retake policy?

In the event that you fail your first attempt at passing the 1Z0-147 exam, Oracle's retake policy is:

  • You must wait 14 days before retaking a failed exam.
  • Passed exams and Beta exams cannot be re-taken.
  • Candidates may retake an online non-proctored 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 on this exam?
You can find more information about the 1Z0-147 here: http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=41&p_org_id=1001&lang=US&p_exam_id=1Z0_147
1Z0-147 Course Includes Free Buy
Chapters 1 11
Practice Tests 1 3
Total Questions (inc. quizzes) 30 346
Interactive Quizzes 15 119
Articles, How Tos.., Tips No Yes
Study Notes Sample 137
Customers who are interested in 1Z0-147 are also interested in

Overall Customer Rating!

 
 

4.6 out of 5 Pass Ratio: 97.23%.
9 out of 10 customers who purchased this course would recommend the product to their friends.

Our Customers are talking!


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