Customer Reviews

OCP Developer PL/SQL Program Units Exam Guide

5 star:		(12)
4 star:		(7)
3 star:		(2)
2 star:		(2)
1 star:		(0)

 

 

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.

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.

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.

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.

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.

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.!!!!!!!

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

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.

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!

I read this book through and then using the CD, took the adaptive exams 4 times. I then re-reviewed the items I was weak in. I took all 3 practice exams and got 5 or 6 wrong on each. I studied the topics I consistently missed on each exam again. I took the test and got 56/57. This book really helps with the theory behind all the topics - once you understand the theory, you can pass the test.