Customer Reviews

Oracle Database 10g OCP Certification All-In-One Exam Guide (Oracle Database 10g Handbook)

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

 

 

i buy this book together with sybex's book and have passed the oca exam with 87% score (less than what i expected though). i found this book easier to read and understand compared to sybex's book, and the many-but-short chapters works better for me. if you could only choose one book to pass the 1Z0-042 exam then this is definitely the best choice. but don't forget to practise what you read (although the book makes it looks so simple), you'll remember more by trying each exercise in this book.

added 5 feb 2007 :
i have just passed my ocp exam last month, still using this book and the ocp 10g certification kits. the good thing about this book is it resembles the training materials from oracle admin II a lot, because it is published by oracle press. but just as the title says, this is the best book to pass the exam only, you need other references and lots of practices if you really want to master the oracle database technology well. however it is still a good idea to get the oca/ocp first to get you fire up (and increase your value for employers), and then continue to explore the beauties of oracle database in your daily works. as before, if you could only get one book for your ocp exam, then get this book.

p.s. be aware that oracle globalization features (NLS) is now in the OCA exam instead of OCP, so the chapter structure for this book (and also sybex's book) need to be updated

I used this book to (sucessfully) prepare for the OCA exam. It is well structured and important points for the exam are specially highlighted. This makes the content memorable and easy to learn.

The review questions are pretty good. I recommend getting the question set of www.selftestsoftware.com, too. They are not exactly like in the exam (like TestKing) but representative.

I used this book and the SYBEX OCA preparation (OCA: Oracle 10g Administration I Study Guide (1Z0-042) by Chip Dawes) and found this one clearly superior.

Still, it is not perfect: There was some exam-relevant details missing, e.g. for data pump. So check with the selftest questions and get the missing information from the Oracle manuals on the net.

I bought this book in addition to the Sybex guide. At this time I have taken only the first exam, and was happy with the instruction I received from this book. I passed the test on the first try despite my somewhat rusty Oracle skills.

This book is extremely well organized and readable. The chapters are short enough to fully digest at one sitting. The information is complete, though I would say that it may not quite be as "test-specific" as the Sybex book is. However, unlike the Sybex book, there are great chapter summaries here which are useful when going back over things in preparation for the test.

My suggestion, if you can afford it, would be to buy both books and forego any other study aids or classes you might be considering. There is some overlap, but each book does touch on some things that the other one misses and some topics are covered more in depth by either book.

I would rate this one slightly superior, mainly due to its readability and lack of errors and typos.

I recently took the Oracle 10g Administration Workshop class and purchased this book in preparation for the OCA exam. While the book itself did a great job of covering some of the basic, under-the-hood topics you need to know (not just for the test, but to be a decent DBA), it fell short in a few areas.

1. The screen shots and examples in the book aren't consistent with the latest versions of Oracle Enterprise Manager/Database Control. The version I downloaded and installed for Windows just a few weeks ago was occasionally different than the images I saw in the examples. Sometimes, the differences were minor (just a slight variation on the name of a link, for instance), but other times they were a little more severe (columns that don't appear in the version I downloaded, or functionality that seems to have been moved).

2. The last chapter in Part 1 of the book covers a topic that's an objective for the OCP test, not the OCA one (at least according to the Oracle site as of this morning). Not a big deal and it's good info to know, but if you're studying specifically for the exam you might not want to spend time on info that isn't directly relevant.

3. I could live with 1 and 2 above, but this is by far the worst part... The companion CD includes practice tests for the OCA and OCP exams, one of the main reasons I bought this book. Before I cracked open the book, I took the test labeled "OCA" to get a sort of baseline read on my current preparedness. Having taken the instructor-lead course Oracle recommends for preparation, I thought I should do reasonably well.

I scored a 23%. To make matters worse, the questions themselves were baffling, at times covering subjects I hadn't even heard of. I was completely disheartened. Did I sleep through my $3000 class, or was I just that dumb (please don't answer that)?

A couple of days later, I figured it out: the software was bunk. The tests were mislabeled (that is, the one labeled "OCA" was actually the practice test for the more advanced "OCP" certification exam and vice versa).

Furthermore, many of the questions themselves have typos. I found a few, for instance, that don't actually state the question, going right from the background info to the possible answers. You'd get a "question" that looked like this:

Jill has four bananas. Mike has three apples.

A) Monkey.
B) Six.
C) Spaghetti.
D) None of the above.

Or, in at least one case, a question that told you what the actual answer was before giving you the choices:

What's 4+2?

B is the correct answer. 4+2 equals 6.

A) 3
B) 6
C) 18
D) Pi

One last beef with the included practice tests... After completing the test, you're given the option of reading a review of the questions you missed. Great feature that all practice test software should give you. While reviewing your misses, though, there's an utterly useless "References" portion that always just refers you back to the text. Doesn't tell you which page to look at for more info, or even which chapter. Just ever-so-helpfully tells you that there's more info on that question SOMEWHERE in the book. Thanks for nothing.


Clearly, more of my problems were with the companion CD than with the book itself. If I reviewed only the text on its own merits, I'd probably give it 4 stars instead of just three. Likewise, the CD would only get 2 on its own.

Again, though, it's imperative that you don't rely solely on this text for the exam (or for learning the software itself, for that matter). Download it and install it, get familiar with EM as it is now. Look on the Oracle site to find out whether or not the exam topics have changed. And, if you can afford it (or sweet talk your employer into it), take an instructor-lead class. It's a requirement for the OCP cert, anyway.

Oh, and in case you wanted to know... I took the test yesterday and did, indeed, pass.

i've found book quite interesting and what the most important "thinking-oriented" and helpfull to PASS the OCP exam.
but i found a lot of errors in text, some that are just obsolete informations like env variable EMHOSTNAME, which may be fine in 10.1 but in 10.2 you have to use ORACLE_HOSTNAME instead,
some others are typographic errors like calling column resource_manager_group but it should be resource_consumer_group (p855), forgetting to list BYDAY in interval specifiers (p866).
But the other things are really unpleasent surprises:
"maximum number is limited by the JOB_QUEUE_PROCESSES instance parameter; this defaults to 0, but if that value is used, the Scheduler will not function" -- not true -- see art. no 413399.1 and own practice as well.
q7 in questions about scheduler: B)freq=hourly;interval=1/2 -- i got error ORA-27465: invalid value freq=hourly;interval=1/2 for attribute REPEAT_INTERVAL which was expected -- according to documentation so this is not proper anwser.
on page 574 "Image copies can be made of datafiles, the controlfile, and archive logs. Image copies cannot be made of the spfile"
-- but during copy of controlfile we have:

RMAN> backup as copy current controlfile;

Starting backup at 06-SEP-08
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=153 devtype=DISK
channel ORA_DISK_1: starting datafile copy
copying current control file
output filename=/u01/oracle/flash_recovery_area/ORCL/controlfile/o1_mf_TAG20080906T201002_4d5kvv6v_.ctl tag=TAG20080906T201002 recid=5 stamp=664747803
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 06-SEP-08

Starting Control File and SPFILE Autobackup at 06-SEP-08
piece handle=/u01/oracle/backup/cfc-1177494707-20080906-00 comment=NONE
Finished Control File and SPFILE Autobackup at 06-SEP-08

so it seems to be not true too.

And the information which was the most surprising to me:
tip on page 796 "The views V$ASM_DISK and V$ASM_DISKGROUP are only
populated in an ASM instance. They are always empty in an RDBMS instance".
but oracle doc says: "In a database instance, V$ASM_DISKGROUP displays one row for every Automatic Storage Management disk group mounted by the local Automatic Storage Management instance".
And talking about ASM one more important thing: there is no information about templates and aliases in ASM file names which one could get on exam test!
that's not the complete list of errors i'm afraid.
and it's worth to notice that from december '08 the contents of the book won't be enough to get OCA/OCP:
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=231.
regards.

Having passed the OCA, I can say that this book has excellent coverage of the OCA exam (and presumably the OCP too). I wouldn't bother buying any other study material for reading. The book is very comprehensive, and the topics are broken down into small digestible chapters. If you're wondering what book you should buy to read, buy THIS ONE.

My only complaints are that the question cd is not particularly helpful. The questions on it aren't particularly close to the actual exam. I would very much recommend that you buy a question set from a provider on the internet such as Ucertify (just be careful which provider you buy from, as some of them provide the *exact* test questions, which will invalidate your results. Ucertify is ok.)

Also be careful: The last chapter in section 1 (the section on languages and such) is in the OCP exam, not the OCA.

PRO's:
- Detailed guide covering material on OCA and OCP exams
- OCA is Part 1, OCP is Part 2 of book

CON's:
- Author is VERY long-winded.
- Not enough use of diagrams
- Not updated for Oracle 10g Release 2 (current exam topic)

If you like long, boring discussions on a topic so much that by the end of the section you forgot what the main point was, then this book is for you! However, if you like short and straight to the point, you won't get that here.

The author tends to ramble on forever on each topic. It makes reading not only boring, but confusing. Use of a few simple diagrams like those found in the Sybex books would have gone a long way. It would have clarified the point without lenghty paragraphs. I found that the author tends to repeat himself often, too.

The main problem with this style of writing is that you will miss cruicial details because they're burried deep in a sea of text. Also, you CANNOT quickly skim through the book for a brief refresher.

I would have rather seen the book written such that the main points were stated first, followed by supporting detail and a diagram or two. So, you would be able to quickly skim through the first sentence of each paragraph or so to get the gist without deep reading.

It's painful to read through this book!

Giving it 3 stars because as painful as it is to read through, I am learning from it and it will help me pass the exam. But it could have been MUCH better.

It is an excellent opportunity to get ready for the exam. Even if you are not familiar with the RDBMS concepts, this book will help you to get ready for your OCP. A lot of examples and exercises in a book easy to read is complemented with a set of self-test exams in the CD ROM making this the complete tool to get your OCP.

Well,well, I just came back from the testing center. Fortunately, I passed, but the score is very tentative.
I am not a DBA. I have very little experience in administrating oracle database. The only purpose I learned OCA exam is because I think this is the best way to obtain the key skills.

During the past 3 months, I am sure I totally digested this book. But finally I found this book is far from enough to pass the test. I ordered the "self test" and found I can only pass 50% in the mock tests. Does the "self test" over kill?
After taking the real exam, I found the difficulty of the real test is between the self tests and the book. If you only read this book and you do not have so much practical experience, I am sure you can not pass. I have the feeling, the knowledge in the book is too out-of-date. However, I really had not any better books to read for the test.

Good luck guys.

This book will prepare you for the OCA/OCP exams, however, be aware before you start, the self-test software has the exams mismatched. The OCA exam is actually titled "OCP" and vice-versa, so if you cover the 1st half of the book, you'll need to take the "OCP" test on the software, the one with 75 questions.

1) Read each chapter
2) Take every quiz at the end of chapter
3) Score yourself and review each wrong answer

By the time you are done and are ready for the practice test, you will be prepared.

I do feel that there are a few too many errors, as other reviewers pointed out, but most of these will only hurt people who are just trying to "cram." For experienced DBAs, the errors will usually be obvious, and can be verified by doing the exercises. That said, errors are errors and should not be there if the book had been properly edited and reviewed.

The self-test software gets 2 stars. It feels like it was tossed together in 20 minutes from an import of a tab delimited list of questions and answers. The references for each question in the view section just refer you to the book, as a whole, no chapter number! Ridiculous. Scrolling the test review does not work, neither does the print function!

If I were the author of certification guides I would guarantee with the utmost certainty that the book was accurate and helpful, by having several non-certified DBAs as _well_ as OCP DBAs review and take the chapter tests.

Besides all that, I still give it 4 stars it is well presented, and if this book does not prepare you, then you are probably not doing the self-tests and exercises, and are looking for a cheat-sheet cliff-note format, and I don't want to hire any DBA that needs to be spoon fed to pass a certification.