OCP Developer PL/SQL Program Units Exam Guide

Rating:
Summary: Very helpful
Review: 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.

Rating:
Summary: Very helpful
Review: 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.

Rating:
Summary: Mediocre
Review: My objective was to pass the 1Z0-101 test so that is my viewpoint. Having gotten thought the 8i DBA cert I have a process that works for me. The book turned out to be better than any of Jason Couchman's stuff for readability but today I found out it lacked considerably in the Interdependency area and missed out on other areas by not using some examples that better related to actual test questions. In some cases, such as calling remote server procedures it was just plain wrong. Yeah, there are typos too.
Whatever you do don't trust the BeachFront Quizzes, I found 47 wrong answers in the sample tests without working hard at it. Some of the same questions appear in the book samples too. These are not just typos but real errors in context and concepts. I suppose that I may have passed with just the book and practice but I did purchase another sample testing program that made the difference in confidence.
I'd like to see more info on Interdependencies and creating procedures. Better or clearer descriptions of parameters and parameter passing would be a big help. An example is :old and :new are only used in the body of a trigger not in the header. That little bit seems not to be prevelent in the text. More info on invoking Procedures and Functions from SQL*Plus would help with a few key concepts. OTN helped out a few times but concepts could be better articulated. Things like what Procedures become Invalid because of dependencies when a table is changed is not well done either.
I will say that 56 out of 57 is overkill but it felt good.

Rating:
Summary: Great Exam Preparation Book
Review: The questions at the end of each chapter and the exams at the end of the book are very very good. This is my first Oracle exam, and I am really surprised to see how similiar these questions are. The CD practices sometimes show wrong answers, but check them out on the book instead.

Rating:
Summary: Great Exam Preparation Book
Review: The questions at the end of each chapter and the exams at the end of the book are very very good. This is my first Oracle exam, and I am really surprised to see how similiar these questions are. The CD practices sometimes show wrong answers, but check them out on the book instead.

Rating:
Summary: Great prepartion tool!
Review: This book covered everything on the exam and provided plentiful practice test questions. You don't need Self-Test Software when you have this book. I scored 52 out of 57 and I don't even work with Oracle. The one glaring problem with this book is numerous errors in the practice test, but they are easy to identify.

Rating:
Summary: Excellent and To the point
Review: This book was my main study guide to pass the pl/sql exam with a 95% score while learning a good deal about the subject. The concepts are accessibly explained to an adequate depth level and the language is very friendly.

Rating:
Summary: Fantastic and really exam oriented!
Review: This is a great book if you want to pass your pl/sql 101 exam.
Simple explanation but also nicely explained answers ,especially the trick ones!

This one is a winner.

Cheers!!!

Tarry