Now I understand Oracle quite thoroughly.
Target is May 27 take OCA test.
Tuesday, March 24, 2009
OCA Study progress
After reading selftestsoftware first 5 chapters, Sybex OCA book first 3 chapters: Architecture, DBCA, DB management reading is a breeze, within one week. Then scan through again backup and recovery very quickly, performance monitoring quickly. Locking one day finish detail read. Security and PL/SQL slow down a little bit but quick scan. All in all done all this in about a week.
Saturday, March 14, 2009
Bubul new books recommendation
1. Study Oracle 10g Database Administration Concepts & Implementation Made Simple (Paperback)by Asim Abbasi (Author)
Give you a intutive understanding of oracle.
2. Study OCA: Oracle 10g Administration I Study Guide (1Z0-042) by Chip Dawes (Author), Bob Bryla (Author), Joseph C. Johnson (Author), Matthew Weishan (Author)
This is the most complete guide to OCA exam.
3. Selftestsoftware: IS THE MOST IMPORTANT one to study and IS A MUST for OCA. Without selftestsoftware you dont have a framework to filter Oracle large amount of material.
4. Study Expert Oracle Database Architecture - 9i and 10g Programming Techniques and Solutions (Paperback)
by Thomas Kyte (Author
This is the book to understand oracle. Because no understanding is very difficult to pass OCA. THough at expert level but the writing is lucid and simple. Best Oracle book i have read.
THe rest of the books mentioned below are not so good, either not enough info or too complicated for OCA.
Oracle press OCP study guide: Too long winded. Not enough info, doest even describe extent management. Essential oracle: doesnt even discuss extent management. The tuning books too complicated for beginners.
Give you a intutive understanding of oracle.
2. Study OCA: Oracle 10g Administration I Study Guide (1Z0-042) by Chip Dawes (Author), Bob Bryla (Author), Joseph C. Johnson (Author), Matthew Weishan (Author)
This is the most complete guide to OCA exam.
3. Selftestsoftware: IS THE MOST IMPORTANT one to study and IS A MUST for OCA. Without selftestsoftware you dont have a framework to filter Oracle large amount of material.
4. Study Expert Oracle Database Architecture - 9i and 10g Programming Techniques and Solutions (Paperback)
by Thomas Kyte (Author
This is the book to understand oracle. Because no understanding is very difficult to pass OCA. THough at expert level but the writing is lucid and simple. Best Oracle book i have read.
THe rest of the books mentioned below are not so good, either not enough info or too complicated for OCA.
Oracle press OCP study guide: Too long winded. Not enough info, doest even describe extent management. Essential oracle: doesnt even discuss extent management. The tuning books too complicated for beginners.
How hard is Oracle OCA exam see below
How was my CMDBA exam last Jan 29?
Share
Saturday, February 28, 2009 at 9:05am Edit Note Delete
I missed 4% to pass. And it was the hardest exam i have ever taken in my life. My face was flushed during the exam. How was the CMDBA exam?Well it is just like what these people who took OCA/P in amazon said:http://www.amazon.com/OCP-Oracle-Administration-Study-1Z0-043/review/product/0782143687/ref=cm_cr_dp_synop?ie=UTF8&showViewpoints=0&sortBy=bySubmissionDateDescending#RLMQDUCJT4S1By Forensic Team "AngelMar.com" (California) - See all my reviewsI studied this book from cover to cover with my eyes close (3 months 2-3 hours a day). I just failed the exam and I scored 60% out of 70% passing. Although the book covers all the materials you have to know, it does not cover in detail on each section to pass. The test questions are totally unrelated to the practice exam of this book. Almost all the questions are scenario questions. I suggest that you need additional references beside this book. Furthermore, this book is hard to understand. I have re-read so many times. The wording is poor. There are about 20% mistakes on the practice exam questions of this book. The reason I did not add additional references is that if you study the book from cover to cover, there is no doubt you passthe exam---I WAS WRONG. WARNING: The OCP exam had 2-4 long sentences each question with a multiple choice from A-F (2-3 answers). That's how it makes it hard. You have to think very very very deep and NOT ENOUGH TIME. 1 of 2 people found the following review helpful:Not enough to pass the test, December 5, 2006By Blaine T. Jones "seismo" (Dahlonega, GA USA) - See all my reviewsThis book is jam-packed with info that the Oracle 10g DBA will need to know...unfortunately, its not enough to pass the exam. The book isn't necessarily at fault - the exam is full of so many trick questions and obscure references that cooincidentally are all spelled out in Oracle's training material (which you'll need to shell out three thousand dollars to attend the class and get the books). In order to get OCP certified, you have to attend an Oracle class anyway, so skip this book and get the training from the source.http://www.amazon.com/OCA-Oracle-Administration-Study-1Z0-042/review/product/0782143679/ref=cm_cr_dp_all_recent?ie=UTF8&coliid=&showViewpoints=1&colid=&sortBy=bySubmissionDateDescendingBy Aebares2006 (Boston, MA) - See all my reviewsI used this book to study for the OCA test for a month and thought I would pass with my SQL & limited Oracle experience. I did not pass the test because the test has changed to Senario Driven with Multiple Choice & Multiple answers. You would receive a long paragraph about a user's needs. You would need to select two answers out of five; 1 would be easy to pick, 2 would seem wrong and 2 would seem almost identical and right. That is where the test has gotten harder. Where this book gives you the foundation of all the "What's" involved, the test needs the "Whys". I recommend SELFTEST software Oracle pushes on thier site. I find the questions and style are very similar to what I had experienced. I still recommend this book if would like to understand the concepts and have an oracle DB at your disposal If you then need or want the cert buy the selftest software because I'm positive half of my questions came from that product. By spending your money on both of those products you will still make out very well because the Live course for this subject is around $2,500. My experience with Oracle has been from the Healthcare IT environment where the database is already set up and just needs tuneing and Reports. If you are an Oracle Finanicials person you may only need the SelfTest software to practice from.y S. vandanam "OCP" (Houston,TX) - See all my reviewsI cleared my OCA exam with help of sybex and selftest software..could get 73/75 . I would recommend to go for selftest(65% of questions came from selftest in the actual exam) along with sybex..just reading sybex might not be of much help.By Dave Price "Avid Reader" (Franklin, WI United States) - See all my reviewsThis book does not cover topics well enough to pass the exam. It might be useful as an addition to other materials or as a review for experienced DBAs, but it does NOT have the information you need to pass by itself. After failing the OCA exam (after acing the books' 2 exams, thanks guys!) I smashed this book against a brick wall until it was nothing but torn pages fluttering in the breeze. The binding held up well through the first several smashings, and stomping the separated pieces produced an enjoyable tearing sound.
Share
Saturday, February 28, 2009 at 9:05am Edit Note Delete
I missed 4% to pass. And it was the hardest exam i have ever taken in my life. My face was flushed during the exam. How was the CMDBA exam?Well it is just like what these people who took OCA/P in amazon said:http://www.amazon.com/OCP-Oracle-Administration-Study-1Z0-043/review/product/0782143687/ref=cm_cr_dp_synop?ie=UTF8&showViewpoints=0&sortBy=bySubmissionDateDescending#RLMQDUCJT4S1By Forensic Team "AngelMar.com" (California) - See all my reviewsI studied this book from cover to cover with my eyes close (3 months 2-3 hours a day). I just failed the exam and I scored 60% out of 70% passing. Although the book covers all the materials you have to know, it does not cover in detail on each section to pass. The test questions are totally unrelated to the practice exam of this book. Almost all the questions are scenario questions. I suggest that you need additional references beside this book. Furthermore, this book is hard to understand. I have re-read so many times. The wording is poor. There are about 20% mistakes on the practice exam questions of this book. The reason I did not add additional references is that if you study the book from cover to cover, there is no doubt you passthe exam---I WAS WRONG. WARNING: The OCP exam had 2-4 long sentences each question with a multiple choice from A-F (2-3 answers). That's how it makes it hard. You have to think very very very deep and NOT ENOUGH TIME. 1 of 2 people found the following review helpful:Not enough to pass the test, December 5, 2006By Blaine T. Jones "seismo" (Dahlonega, GA USA) - See all my reviewsThis book is jam-packed with info that the Oracle 10g DBA will need to know...unfortunately, its not enough to pass the exam. The book isn't necessarily at fault - the exam is full of so many trick questions and obscure references that cooincidentally are all spelled out in Oracle's training material (which you'll need to shell out three thousand dollars to attend the class and get the books). In order to get OCP certified, you have to attend an Oracle class anyway, so skip this book and get the training from the source.http://www.amazon.com/OCA-Oracle-Administration-Study-1Z0-042/review/product/0782143679/ref=cm_cr_dp_all_recent?ie=UTF8&coliid=&showViewpoints=1&colid=&sortBy=bySubmissionDateDescendingBy Aebares2006 (Boston, MA) - See all my reviewsI used this book to study for the OCA test for a month and thought I would pass with my SQL & limited Oracle experience. I did not pass the test because the test has changed to Senario Driven with Multiple Choice & Multiple answers. You would receive a long paragraph about a user's needs. You would need to select two answers out of five; 1 would be easy to pick, 2 would seem wrong and 2 would seem almost identical and right. That is where the test has gotten harder. Where this book gives you the foundation of all the "What's" involved, the test needs the "Whys". I recommend SELFTEST software Oracle pushes on thier site. I find the questions and style are very similar to what I had experienced. I still recommend this book if would like to understand the concepts and have an oracle DB at your disposal If you then need or want the cert buy the selftest software because I'm positive half of my questions came from that product. By spending your money on both of those products you will still make out very well because the Live course for this subject is around $2,500. My experience with Oracle has been from the Healthcare IT environment where the database is already set up and just needs tuneing and Reports. If you are an Oracle Finanicials person you may only need the SelfTest software to practice from.y S. vandanam "OCP" (Houston,TX) - See all my reviewsI cleared my OCA exam with help of sybex and selftest software..could get 73/75 . I would recommend to go for selftest(65% of questions came from selftest in the actual exam) along with sybex..just reading sybex might not be of much help.By Dave Price "Avid Reader" (Franklin, WI United States) - See all my reviewsThis book does not cover topics well enough to pass the exam. It might be useful as an addition to other materials or as a review for experienced DBAs, but it does NOT have the information you need to pass by itself. After failing the OCA exam (after acing the books' 2 exams, thanks guys!) I smashed this book against a brick wall until it was nothing but torn pages fluttering in the breeze. The binding held up well through the first several smashings, and stomping the separated pieces produced an enjoyable tearing sound.
SelfTestSoftware is absolutely must for passing OCA
Spend US$109 to buy the software. But it is a absolutely much more important than any oracle books to pass OCA. It gives you direction to study out of the high volume of Oracle information.
Subscribe to:
Comments (Atom)
