Test Prep AP SAT GMAT MCAT Learn more Discover Test Prep Central
OCP Developer PL/SQL Program Units Exam Guide (Oracle Press) and over one million other books are available for Amazon Kindle. Learn more
Buy Used
$3.74
+ $3.99 shipping
Used: Good | Details
Sold by worldofbooksusa
Condition: Used: Good
Comment: The book has been read but remains in clean condition. All pages are intact and the cover is intact. Some minor wear to the spine.
Access codes and supplements are not guaranteed with used items.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

OCP Developer PL/SQL Program Units Exam Guide Paperback – April 23, 2002

ISBN-13: 078-3254037953 ISBN-10: 0072193360 Edition: 1st

Used
Price: $3.74
10 New from $51.61 19 Used from $3.74
Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$51.61 $3.74
Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Hero Quick Promo
Save up to 90% on Textbooks
Rent textbooks, buy textbooks, or get up to 80% back when you sell us your books. Shop Now

Editorial Reviews

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.

About the Author

McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide
NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Series: Oracle Press
  • Paperback: 499 pages
  • Publisher: McGraw-Hill Osborne Media; 1 edition (April 23, 2002)
  • Language: English
  • ISBN-10: 0072193360
  • ISBN-13: 978-0072193367
  • Product Dimensions: 7.4 x 1.4 x 9.1 inches
  • Shipping Weight: 2.4 pounds
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (25 customer reviews)
  • Amazon Best Sellers Rank: #838,653 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

If you want to do the PL/SQL program units exam this book is definitely the book to go for.
Gregor Theis
Amazing...great..those are the words for this book which i recently used for 1z0-147 exam which i passed with score 63/66.
K. shah
The questions at the end of each chapter and the exams at the end of the book are very very good.
hohowang

Most Helpful Customer Reviews

37 of 37 people found the following review helpful By Robert Hendren on October 4, 2003
Format: Paperback
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
23 of 23 people found the following review helpful By Gregor Theis on May 7, 2002
Format: Paperback
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
12 of 12 people found the following review helpful By Srini on December 4, 2002
Format: Paperback
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
8 of 8 people found the following review helpful By TLAW_DBA on February 20, 2005
Format: Paperback Verified Purchase
I used this book to prepare for pl/sql exam and scored 49/57. It is a good study guide. I have not had difficulty going through the book since I was exposed to the pl/sql language when I was studying for the exam (1z0-001, Introduction to oracle 8i sql and pl/sql). This was a huge benefit for me and I only spent about three weeks reading the book. I will say that this exam (1z0-101) is built on the first one (1z0-001). I am not sure if it is also built on the exam (1z0-007). You will need to know the basics of pl/sql to fully understand this book.

The author did a pretty job breaking down all the information you need for the exam. There was no questions on Chapter 8 and Chapter 9 was barely touched with one question on debugging.

I will advice you to read carefully the book and make sure you master the concept before you go take the exam. If you do it the exam comes easy for you. You will be shown a lot of codes during the exam. My strategy was this: in order to avoid wasting time reading the entire code, I read the question first. That allows to me spot quickly the objective and see quickly what is being asked without reading the long code. Stuff you need to be carefull of:
-Parameter declaration in Function and Procedure header
-Function without a Return
-Public and Private Constructs behavior
-Triggers behavior
-Function and Procedure call
This strategy allowed to complete my exam in less than one hour. Good Luck.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
8 of 8 people found the following review helpful By CREFCOEUR PHILIPPE on July 11, 2002
Format: Paperback
I studied in this book and passed the PL/SQL exam.
Nearly everything you need to know is in this book. For only two questions out of 57 the answer was not in the book but for one of them the answer could be guessed.
There is a chapter about Procedure Builder which is not in the test content checklist and I had no question about it.
The practice questions are very good but there is a bug in the Quizzer found on the CD-ROM. Some questions are evaluated False, but the explanation says otherwise. When in doubt check the paper version which is always accurate.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
5 of 5 people found the following review helpful By K. shah on November 20, 2006
Format: Paperback
Amazing...great..those are the words for this book which i recently used for 1z0-147 exam which i passed with score 63/66.

After lot of research i used this book for 1z0-147 and i happily confirm that i made great choice.

Most of the topics required for exam are covered except LargeObjects(LOB).

Thanks a lot Steve for wonderful job.!!!!!!!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
4 of 4 people found the following review helpful By xxxx on January 17, 2004
Format: Paperback
I have bought the book "Oracle - OCP Developer PL/SQL Program Units Exam Guide (Exam 1ZO-101). It's a great book! ... Only one defect: using the CD of BeachFromQuizzer I account for an
error : in all the subcategories except for 01 Overview of PL/SQL and 3 Practise Test the button EXPLAIN is not enable
In phase of Study session this button is useful and important.
Sometimes the cd shows wrong answer too.
That's all!
Giulia
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 3 people found the following review helpful By A Woman on September 28, 2007
Format: Paperback
Although this book is a guide for the 1Z0-101 exam, I got it to prepare myself for the 1Z0-147 exam, which I just passed. It covered everything but LOBs and the use of CALL for triggers (topics not supposed to be in the 1Z0-101). So, it is a great book: easy format, very realistic practice exams. The only reason I give it 4 starts instead of 5 is because the CD that cames with it is horrible. The software has a lot of bugs, so it's a waste of time using it. To give you an example, some questions that are intended to have multiple answers, just don't let you chose more than one. Ridiculous!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews