Regular marked price: $49.99Discount Price: $36.84
Cost Savings: $13.15 (26%)Price fluctuation possible.
How soon does it ship: Usually ships in 7 to 11 days
Shipping? Absolutely FREE if you qualify for Super Saver Shipping.
Type of bind: Hardcover
Dewey Decimal Number: 005.7585
EAN num: 9780782140637
ISBN number: 0782140637
Label: Sybex
Manufacturer: Sybex
Quantity: 1
Page Count: 452
Printing Date: April 08, 2002
Publishing house: Sybex
Sale Popularity Level: 287834
Studio: Sybex
Other books you might be interested in perusing:
Editor's Notes and Comments:
Product Description:
-Your key to attaining certification in Oracle's revamped DBA track! -Contains exam essentials, real-world scenario sidebars, scenario-based questions, and fill-in-the-blank questions. -The CD includes flashcards, chapter-by-chapter exams, randomly generated question sets, a bonus exam, and an electronic version of the book.
User popularity level:
Rated by buyers 
-
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 endeavor the Exam without reading this book at least once.
Rated by buyers -
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!
Rated by buyers -
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.
Rated by buyers -
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
Rated by buyers -
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.
Find other books like this one:
