Get the latest IT certification news by email when you subscribe to GoCertify
Certification Update


GoCertify: The complete computer certification resource center.

GoExam: Certification practice tests with free demos to download.

CertificationBooks: Find the certification book you're looking for.




Home > Training > Oracle Corporation

Oracle OCP 9i: Program with PL/SQL Practice Test

Covers objectives for Oracle Certified Professional (OCP) PL/SQL exam 1Z0-147. 150 questions.

Available Training Formats:

online subscription
     training demo link
(current price & free demo via our partner's website)

Product Details:

Test Engine Features:
  • Questions are similar to exam questions so you test your knowledge of exam objectives
  • Detailed answer explanations reinforce the material
  • Study mode covers all objectives ensuring topics are covered
  • Certification mode prepares students for exam taking conditions
Core Test Information:

This test contains 150 questions and covers the following objectives:

  • Overview of PL/SQL Programs - 5 questions
  • Creating Procedures - 19 questions
  • Creating Functions - 13 questions
  • Managing Subprograms - 7 questions
  • Create Packages - 11 questions
  • More Package Concepts - 12 questions
  • Oracle Supplied Packages - 11 questions
  • Manipulating Large Objects - 20 questions
  • Creating Database Triggers - 25 questions
  • More Trigger Concepts - 11 questions
  • Managing Dependencies - 16 questions
This test includes references to the following media:
  • Oracle 9i PL/SQL: A Developers Guide
  • Oracle PL/SQL Programming
  • Expert Oracle 9i Database Administration
  • Oracle9i Application Developer Guide - Fundamentals
  • PL/SQL Users Guide and Reference
  • Oracle 9i DBA 101
  • Advanced Oracle PL/SQL Programming with Packages
  • Oracle9i Supplied PL/SQL Packages and Types Reference
  • Oracle9i Database Concepts

training demo link
(current price & free demo via our partner's website)