Oca Oracle9i Associate DBA Certification Exam Guide [With CDROM]

I used this book for my OCA preparation and passed with 85%. If you read the practice exams given in the book alone you could easily get 80% :)

I found this book to be very useful for OCA exams. One more advantage of this book is it comes with CD for simulated test, which help lot for exam preparation

1. For #1Z0-007 exam:a. I've taken Oracle class, so I didn't go through this book before I took #1Z0-007 exam, I found out that the format of this part is not nice for review, because the syntex of SQL statement is not demostrated in the way it should be, you have to read every words to get soom point (probably good for study from groud up?)b. Three practice Exams on CD-ROM are identical to those in print at end of book, but nowhere says that. So, if you want to evaluate youself before you go to the test center, don't do any exam in the book, but CD-ROM. c. Questions of exam in the book or CD-ROM is not similar to questions in the real Test for 1Z0-007. Too simple! And the exam on CD-ROM may mislead you. For example, there are some "B-tree and Bitmap indexes", "high water mark" questions in the book/cd-rom, but not in the real test at all!I passed the #1Z0-007 by reading Oracle University Text Book and doing practice from other resource.The index of the book is helpful when you want to look at some terms.2. The second part of this book is written by another author. I read the first chapter and feel good as a beginner of DBA stuff. That's why I rate this book 4 stars! I hope it will help me pass the 1Z0-131 exam. Wish me good luck! :)

I've just passed the 1Z0-007 (50/57) "which is way harder than 1Z0-001". The book is a good source to prepare for the exam, well organized and easy to read. Chapters 3 & 4 (queries and subqueries) are not extensive enough to let u pass the exam. Most of the exam (around 30%) is about subqueries. U need to know how to analyze and debug them to pass 1z0-007 and understand the new 9! SQL features. The worst thing about this book is the exams included. They (DO NOT) match the real test. U r going to have multiple choices (answers) for the same question.Sometimes up to 4/6.The exams in the book still use the old format (on answer). Some of the questions in the exams are repeated. All over this book is fine except chapters 3 & 4 (queries section). U need to get an extra practice source.I'll write another review when I take the 1Z0-031... Wish me luck... :)