Don't kid yourself. The 1Z0-031 is not an easy test, but reading this book helped me pass the test. If you are new to the profession, like me, then this book alone will not be enough.



I read this book once, understood MOST of what I read and then tried the test and failed. I then took an Oracle DBA class at a Community College and read two other books titled "Oracle 8i DBA Bible" and "Oracle 9i DBA Handbook". I also read Biju Thomas' book one more time, fully understood it and then I was able to pass the test.



I highly recommend this book. I feel that if you can read and understand 99-100% of what Biju Thomas writes in "OCA/OCP: Oracle 9i DBA Fundamentals I" then you can pass the Oracle Exam. I also would not attempt the Exam without reading this book at least once.

Don't kid yourself. The 1Z0-031 is not an easy test, but reading this book helped me pass the test. If you are new to the profession, like me, then this book alone will not be enough.

I read this book once, understood MOST of what I read and then tried the test and failed. I then took an Oracle DBA class at a Community College and read two other books titled "Oracle 8i DBA Bible" and "Oracle 9i DBA Handbook". I also read Biju Thomas' book one more time, fully understood it and then I was able to pass the test.

I highly recommend this book. I feel that if you can read and understand 99-100% of what Biju Thomas writes in "OCA/OCP: Oracle 9i DBA Fundamentals I" then you can pass the Oracle Exam. I also would not attempt the Exam without reading this book at least once.

Don't kid yourself. The 1Z0-031 is not an easy test, but reading this book helped me pass the test. If you are new to the profession, like me, then this book alone will not be enough.

I read this book once, understood MOST of what I read and then tried the test and failed. I then took an Oracle DBA class at a Community College and read two other books titled "Oracle 8i DBA Bible" and "Oracle 9i DBA Handbook". I also read Biju Thomas' book one more time, fully understood it and then I was able to pass the test.

I highly recommend this book. I feel that if you can read and understand 99-100% of what Biju Thomas writes in "OCA/OCP: Oracle 9i DBA Fundamentals I" then you can pass the Oracle Exam. I also would not attempt the Exam without reading this book at least once.

My objective in going to the exam was to learn the basics of database and passing the exam was secondary ( i have a fairly well settled job where certification does not matter much).Anyway, No review on certification books is complete without giving a background of your experiences on the subject :

MY DBA EXPERIENCE :
My experiences on Oracle DBA fundamentals is practically and theoretically zero. I have already passed the Introduction to Oracle9i SQL exam which is a pre-requisite to get certified. You can be a master in SQL skills and still be a novice in DBA Fundamentals. Frankly I DID NOT know the following :

1. Physical structure of database is composed of controlfiles, datafiles and log files
2. Never knew that most developers and DBA's spend the time on logical structures which are tables, tablespace etc and do not physically exist in the database
3. Had never heard of V$views
4. I was aware of tables, tablespaces ,DDL commands etc
5. I am an application developer and bulk of my interaction with oracle was select statements,update statements etc
6. Was aware of different types of indexes and that is an important topic in both SQL fundamentals exam and DBA fundamentals exam

If you can answer to all of the above criteria's with a confident 'yes', you are most likely a DBA already and just want to get urself a pay raise by getting certified..Yes, this book will help to breeze thro ( i read about someone who got the exam passed by studying the book for 40 hours).For newbies like me, it is not that easy..in fact it is doubly difficult over intro to sql exams because, i lacked the practical experience ( try inactivaing a tablespace from your company database).

STUDY EFFORT : This book goes through every topic in detail,but sorely misses the visual explanation that would have made some topics easy ( example ...shutting down an instance and startup). This is the reason why i am not giving 5 stars to the book. Neverthless every topic was well described. some of the topics are little elaborate eating into our valuable study time. I studied the book totally 4 times , since after every reading ,tried doing the question paper and slowly removed the errors in understanding.It took a whopping 6 months for me ( and my friend) to learn as you earn.With little more effort, probably i could have got certified in 4 months

I used the book tests and Best of all, my friend who also passed the exams sent me a question paper ( that be purchased in ebay) based on Jason Couchman's book Took that exam( about 150 questions)..and everytime went back to the book reading the chapters and sections where i got it wrong . As a matter of fact, the question paper from jason was very very closely aligned with the questions i got in the exam.

EXAM : Passed the exam .scored 49 correct ( required 44). there was not one question on syntaxes . i assume the oracle examiners have decided it is too easy to find syntaxes on the internet and were focusing on understanding of the subject ( ex : steps taken to multiplex a control file)
If passing the exam is primary for u..don't miss the simulation exams of Jason Couchman ( of course u need to study )..but if u want to learn every aspect of DBA Fundamentals, use this book. On the job, this book is a great resource ( according to a junior DBA in our team). Well written book!

To pass those Oracle Exams is hard for a newbie anyways because the hand on experience is missing. I am one of these candidates but I have to say that this book is very helpful to get ready for the test. 95% of the topics needed for the exam are completely in this book and explained in a good understandable way. For the other 5% I have used the original Oracle training documents. After you have passed the exam this book is an awesome reference because topics are divided in a very usefully way and all topics have examples of the SQL commands and dictionary views.

I used this book and ILT Oracle's manual for my preparation.
Most of the objectives are covered in the book, I like the way in which information is being presented, the only problem I found is some chapters miss important information such as names of dictionary views, which are clever to exam.

NLS is barely covered and not all views are shown.
The tables chapter enforced too much about types of segments, I spent too much time looking into creating partioned tables which is not part of exam objectives.

The Undo chapter misses information on how to check for PENDING DELETE rollback segments.

Follow Exam Objectives when using this book, so you won't waste time memorizing stuff you don't need.
Good Luck

I purchased this book and downloaded Oracle 9i from the Oracle web site. I spent less than 40 hours reading the book, doing the practice questions and playing around with Oracle and I passed the exam with a 47/60. It's not the greatest of passing margins but considering I haven't had any prior experience or training with Oracle (I have had one year of experience with MS SQL Server 2000) and it took less than 40 hours of my time to prepare for it, I would say the book did its job well.

It is a good book to use as preparation tool for Oracle 9i Fundamentals I. I like the style of the book. It is well-organized. With this book it took me a month and half to get prepared for the exam. And I passed my exam 1z0-031 on my first attempt. I will definitely recommend this book to other OCP candidates.
For my exam I also used the Oracle Press book Exam Guide as supplement. The oracle press book exam guide has many practice exam questions that I used.

DeKalb, IL US

I found this book very helpful for my OCA exams. I passed my first 2 exams for Oracle DBA with 98% and 86% refering to this book (along with some other reference materials). The exercises and the tests in this book gave a very good picture of the real exam and were very similar to it. But I wouldn't advise on relying completely on this book.Some other reference is necessary.

I have passed the Oracle 9i fundamentals I 50/60. This book is
really good with explanations. I will highly recommend it for
dba test. Use self test software simulator questions also

I spent about one month almost every night preparing for the exam by only reading this book. Unfortunatly I failed the exam. There are a lot of topics just not explained clearly by the book, although the subjects are all covered. And if you want to pass the exam with a safe margin, you need to understand completely all the topics. With just this book, it can be difficult. I havn't read other exam prep books. But I think having a second book might be necessary. But overall, this book is probably better than others, and can be used as a base.

This book is crammed with good information for updating your skills from Oracle 8 to 9. But it lacks instructional depth for any newbie trying to learn oracle for the first time. It contains page after page of command line instructions with very little explanation of how all this information ties into understanding the database environment. It quickly begins to read like unix man pages and sql sample scripts. It's good information to commit to memory for a test, but look for other sources to learn oracle in more depth. If you're already experienced with Oracle 8, then this may be what your looking for. It just doesn't clearly cover the "fundamentals" for new comers to oracle in my opion.

This book is well written, there are a few errors here and there but the main points are brought about well. I scored a 57/60 on the test with mostly just using this book, and some oracle online documentation to get a little more information on some of the views, so on. Make sure you know redolog files and how they work, seemed like I had a few questions on the test about those. I didnt really use the flash card software with the book, but I did go over the tests at the ends of the chapter a couple times.

I passed the test with 51 right out of 60. This book definitely helped clear up some concepts I had been hazy on in the past, like the relationships between segments and extents. I might even keep it around as a reference just because it's got enough condensed info on a wide range of topics that it might prove useful at some point when I need to create a profile or a partitioned index.

If you have the extra dough, spring for the practice tests at selftestsoftware.com. Some of those questions showed up almost word for word on the exam.

I have 2 years of experience as a SQL, PL/SQL developer and I used this book along with STS tests and got 90%(54/60) on 1Z0-031 exam. Make sure you go on www.sybex.com website and get the ERRATA for this book before reading it because there are a few printing mistakes. The good thing is that there are only printing mistakes and not "Oracle concept" mistakes. So you can be assured that the Authors have a solid command over the content of this book. I guess the printing mistakes are beyond the Author's reach. They themselves are OCPs. So you can trust them.

You need to practice more questions than the ones that comes with this book (simpler than actual exam). Don't feel so confident if you getting good results after doing its questions. To be fair, there were questions exactely like in the book but expect more multiple choice in the real exam.

This book contains few mistakes and few questions that are not covered in its content.

It worked pretty well for me: I passed the exam with a score of 91.7%, using only this book. It is perfect to prepare for the exam; you just have to learn every single byte of information.

I've found the exercises very similar to those the real exam poses.

Thanks Sybex SO much!

Mark

the book itself is not that bad: it gave me an idea how oracle works, but the practise tests were miles behind the actual test questions. Keep this in mind if you're going to buy this book. (I got 70/73... !...)
Alex

Don't waste your money on this book. Unless your looking for something to burn in your fireplace, and if you do burn it don't get down wind because you'll never get the stench out. I will certianly remember the names Biju Thomas & Bob Bryla next time I'm looking for a good study guide. This book is at the best incomplete. Too many simple questions that lead you to believe the exam will be similar. The more complex oracle study list topics are not explained at all.

I did all the tests over and over and it helped.
The explainations are good, and the summaries as well.

Probably not as good as Kaplan self test for practice tests.

But after reading the text I had a good understanding.

Compared to the excellent coverage of OCA exam objectives by Sybex's Study Guide for 1Z0-007, this titles does not deliver at all. I used this guide to prepare for the exam along with the Oracle Press title and found that the latter covers the exam material in much more detail. Even the level of practice questions in the Sybex study guide are nowhere even near the level of difficulty the real exam poses. These questions should be revised keeping in view the test format (Basic/Mastery Sections). Even the coverage of materials is superficial and not enough to give the candidate the confidence to take the exam. My suggestion would be to use another book along with this study guide (I strongly recommend the Oracle Press title - the CD has some excellent questions).

SCRIPT REFERENCE ERROR....
On page 148, the reference to an auto control file creation has the wrong script. "DB_CREATE_ONLINE_LOG_DEST_n" is a reference to LOG FILES, not CONTROL files.
The answers to review questions on page 179 of the same book confirm my observations.
I'm going through the book because I need to teach the contents to adult ed students. Script mistakes are unsat when it comes to computers. Computers don't allow mistakes, and I don't allow authors to make mistakes when referencing scripts or code.
On the positive side, this book is miles ahead of Oracle Press simply because the layout is put together better and it flows. That's my assessment.
If you want to gloat over praises of the book...etc. read someone else's review. When I get around to writing my own book, it will be better; until then, choose this book when you want to learn basic file creation, moving, configuration...etc. on Oracle 9i.
Take care....

The figures and quizzes are definitely the best part of this book. It's very well written and easy to follow, however, just as with any certification, I suggest supplimenting it with a training course, or real world experience. I'm currently enrolled in an Oracle9i DBA cert course, and I'm planning on taking this test by the end of May (2002)...at that time I'll be better equipped to write a more applicable review. For now, i give it 4/5 stars, missing the 5th star because it's not the kind of text that will guarantee you an 'A' on the test...but that's probably for the best...Oracle does it right, making sure their certifications are not easily obtained by those w/o real world experience.

EDIT: took the test, got an 80% on the basic section and an 80% on the mastery section, so all in all, i must say, this book did a great job preparing me. i borrowed the equivalent from oracle press, and was dissatisifed.

I read the book and passed the test on my first attempt. I did not find any errors like those found in the Oracle Press 9i exam prep books. All the topics were covered. The CD-ROM exams and flash cards were a big help. Overall, excellent test preparation.