OCP Developer PL/SQL Program Units Exam Guide (Paperback)

by Steve O'Hearn (Author) "To understand Procedural Language/Structured Query Language (PL/SQL) program units, you must first understand the basic language syntax of PL/SQL..." (more)
Key Phrases: packaged constructs, cur cruises, timestamp mode, Procedure Builder, Object Navigator, Oracle Form (more...)

Editorial Reviews

Product Description
Prepare for the Oracle Certified Professional Developer PL/SQL Program Units exam using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries. The CD-ROM contains hundreds of practice exam questions in an adaptive format.

From the Back Cover
Get Certified with Official Exam Prep Material from Oracle Press

Prepare for the Oracle Certified Professional Developer PL/SQL Program Units exam--a required exam for Oracle Internet Application Developer certification--using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what you've learned. From the exclusive publisher of Oracle Press Books, this package is the most comprehensive preparation tool available for the OCP Developer PL/SQL Program Units exam.

• 100% complete coverage of all official exam objectives
• Exercises at the end of all discussions that reinforce your Oracle knowledge right away
• Tips, examples, and reviews in every chapter to help you remember key concepts
• Two-minute drills--quick and concise checklists that summarize each chapter's main points
• Chapter self-tests--exam-based questions complete with in-depth explanations
• More than 300 practice questions--including scenario-based questions

Required Exam for OCP Internet Application Developer Certification

Book and CD-ROM include more than 300 interactive exam-based questions. CD-ROM contains interactive exams that simulate the actual OCP exams and include hotlinked questions, answers, and explanations.

See all Editorial Reviews

Product Details

• Paperback: 499 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (April 23, 2002)
• Language: English
• ISBN-10: 0072193360
• ISBN-13: 978-0072193367
• Product Dimensions: 9 x 7.3 x 1.5 inches
• Shipping Weight: 2.4 pounds (View shipping rates and policies)
• Average Customer Review: 4.3 out of 5 stars See all reviews (21 customer reviews)
• Amazon.com Sales Rank: #262,913 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #69 in	Books > Computers & Internet > Certification Central > Publisher > Osborne-McGraw-Hill
  #78 in	Books > Computers & Internet > Databases > Relational Databases

Customer Reviews

Most Helpful Customer Reviews

32 of 32 people found the following review helpful:

5.0 out of 5 stars Good reference for the IZ0-147 exam, October 4, 2003

By	Robert Hendren (Hermitage, TN USA) - See all my reviews (REAL NAME)

I used this book as one of my study guides for the new IZ0-147 "Oracle 9i: Program with PL/SQL" exam which I recently passed. This is an excellent book that covers many of the concepts found in the IZ0-147 exam.

It, of course, does not cover everything needed for the IZ0-147 exam. Some things to look up elsewhere include LOBs, side effects (sql stmts calling functions are covered well in the book), and the 'call' command used in a trigger.

21 of 21 people found the following review helpful:

5.0 out of 5 stars Great preparation for the 1Z0-101 OCP exam, May 7, 2002

By	Gregor Theis (Meerbusch Deutschland) - See all my reviews (REAL NAME)

For me this book worked for the OCP exam (53/57 questions correct in 32 minutes). With this book it took me 1 week to prepare for this exam (weekday evenings and most of the weekend).

If you want to do the PL/SQL program units exam this book is definitely the book to go for. I did not find any errors in this book. In the test questions from ORACLE I found no questions that was not explained in the book in a very understandable form.

Beeing a not native speaker I can not really comment on the style of writing but I found it very readable.

This book mentions one very import thing about the exam: read the questions first and than read the source code. I found that sometimes you actually do not need the (lengthy) source code in order to answer the questions.

9 of 9 people found the following review helpful:

5.0 out of 5 stars Very helpful, December 4, 2002

By	Srini (Woodbridge, VA USA) - See all my reviews

I used this to pass the PL/SQL OCP. These books are not for learning SQL and PL/SQL, these books are to prepare for the exams. But this PL/SQL book has chapters that teach PL/SQL very well, and a lot of material to cover the language if you have not worked with it before. I like the sample questions at the end of every section and chapter, they helped me a lot. The longer practice exams in the back are very very good, and I found them to be a lot like the questions on the exam. I had trouble with the CD, but the book was very good. I recommend it to anyone taking the exam. Since this book is from Oracle, I think it is best choice for taking the Oracle exams.