| | |  | Osborne-McGraw-Hill | Home » » » » Oracle Database 10g OCP Certification All-In-One Exam Guide (Oracle Database 10g Handbook) | | | | | | | Product Promotions: | | | | | Description: | | Four for the price of one! "Oracle Database 10g OCP Certification All-in-One Exam Guide" is the only book that offers thorough exam prep and a great on-the-job reference for both the latest OCA and OCP exams. Also includes the Boson's Oracle self-assessment engine to get experience taking the test in the environment it will be given. | | | Product Details: | | | Author:
| Damir Bersinic | | Paperback:
| 926 pages | | Publisher:
| McGraw-Hill Osborne Media | | Publication Date:
| September 12, 2005 | | Language:
| English | | ISBN:
| 0072257903 | | Product Width:
| 206.0 centimeters | | Product Height:
| 244.0 centimeters | | Product Weight:
| 3.55 pounds | | Package Length:
| 9.1 inches | | Package Width:
| 7.4 inches | | Package Height:
| 2.1 inches | | Package Weight:
| 3.5 pounds | | Average Customer Rating:
|  based on 16 reviews |
| | | | Customer Reviews: | |
Average Customer Review:
 ( 16 customer reviews )
Write an online review and share your thoughts with other customers.
Most Helpful Customer Reviews
33 of 33 found the following review helpful:
 best book to pass the oca/ocp 10g examJun 02, 2006
By jensen
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
33 of 35 found the following review helpful:
Good OCP PreparationApr 16, 2006
By Eva Pawlowski
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.
16 of 16 found the following review helpful:
Well written, a good study aidDec 10, 2006
By gregory dwyer
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.
13 of 13 found the following review helpful:
 Decent guide, but don't expect it to do all the work...Jan 22, 2008
By Justin Stanley
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.
4 of 4 found the following review helpful:
good book but look out for errors!Oct 01, 2008
By Fabian Wiktorowski Pb Polsoft
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.
See all 16 customer reviews on Amazon.com
| | |
|
