Test Prep AP SAT GMAT MCAT Learn more Discover Test Prep Central
OCA Oracle Database 11g Administration I Exam Guide and over one million other books are available for Amazon Kindle. Learn more
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images
Have one to sell? Sell on Amazon

OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052) Paperback – May 23, 2008

ISBN-13: 978-0071591027 ISBN-10: 9780071591027 Edition: 1st
Buy used
$12.29
Buy new
$40.08
Used & new from other sellers Delivery options vary per offer
64 used & new from $2.00
Amazon Price New from Used from
Kindle
"Please retry"
Paperback, May 23, 2008
"Please retry"
$40.08
$11.08 $2.00

Hero Quick Promo
Save up to 90% on Textbooks
Rent textbooks, buy textbooks, or get up to 80% back when you sell us your books. Shop Now
$40.08 FREE Shipping. Only 15 left in stock (more on the way). Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052) + OCA Oracle Database 11g SQL Fundamentals I Exam Guide: Exam 1Z0-051 (Oracle Press) + OCP Oracle Database 11g Administration II Exam Guide: Exam 1Z0-053 (Oracle Press)
Price for all three: $113.14

Buy the selected items together

Editorial Reviews

About the Author

John Watson, OCP, is a senior consultant with BLP Management Consultants, and taught for Oracle University in South Africa for four years. He is the coauthor of the bestseller, Oracle Database 10g OCP Certification All-In-One Exam Guide.

NO_CONTENT_IN_FEATURE


Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Paperback: 733 pages
  • Publisher: McGraw-Hill Education; 1 edition (May 23, 2008)
  • Language: English
  • ISBN-10: 9780071591027
  • ISBN-13: 978-0071591027
  • ASIN: 0071591028
  • Product Dimensions: 7.3 x 1.5 x 9.2 inches
  • Shipping Weight: 2.8 pounds (View shipping rates and policies)
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (19 customer reviews)
  • Amazon Best Sellers Rank: #589,025 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

4.5 out of 5 stars
Share your thoughts with other customers

Most Helpful Customer Reviews

41 of 43 people found the following review helpful By Matthew B. Jacobson on June 24, 2008
Format: Paperback
This book has a fairly decent walk through of the exam. The 'substance' is there but the proofreading is not. Many times this can be inferred - for example; on page 175 - it tells you to set the 'processes' parameter in the 'static' parameter file by using the 'scope=spfile' option.

alter system set processes=200 scope=spfile;

Okay - so far so good. Next page - we set the optimizer mode to the outdated 'rule' value. However - we want the change to work for the current session only - so we use the 'scope=spfile' value. (HUH??)

alter system set optimizer_mode=rule scope=spfile;

This is straight out of the book. It was obviously a mistake because they said the same value for scope did two different things. I looked it up the 'alter system' command on the net and found the correct scope value to affect only the current session is 'memory' - so it should actually have been:

alter system set optimizer_mode=rule scope=memory;

Makes much more sense now. The thing that kinda scares me is how many more of these little mistakes are there that are not as obvious? So I try to read this book as a 'rough in' but take it all with a grain of salt.

I don't know how many good books there are out there yet for the 11g exam - this one is OKAY. I bought this one impulsively at B&N without prior research... maybe you can find a better one.

One more thing - if you are not yet familiar with the fundamentals of a relational database (normalization, foreign keys, join types, etc.) - do NOT go off of the explanation in the beginning 'primer' chapter of this book - it is horrible and I was only able to piece it together using my prior knowledge of the same. Once it gets into the actual DBA work the writing improves.
Read more ›
5 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
9 of 9 people found the following review helpful By Matthew Morris on July 30, 2012
Format: Paperback
This is an extremely comprehensive book -- both from the standpoint of the 1Z0-052 certification test and in terms of the fundamental knowledge that an Oracle DBA needs to have. It does not simply lay out information about the exam topics in isolation but provides background and details that pull everything into context. It's the context that an Oracle DBA needs to have in order to be able to make use of the information in a work environment. Passing the test is obviously a primary aim of anyone reading this book. However, for those just starting out in Oracle, the foremost goal of the certification process should be learning how to become a DBA. This book has the information that will help you to do both.

The proofreading issues mentioned by the other reviewers exist. However, they constitute a tiny fraction of the book, and few of the errors impact exam questions. Despite this, be sure to read the errata available on the McGraw Hill web site. To put the errors in perspective -- assume that you use this book to study for the test (without ever checking the errata). If you get every question right where the book provides the correct information, and get every question wrong where there is an error, you would likely miss two or three questions and 'only' pass with 95-97%. Reading the book doesn't guarantee that you'll pass the test. You may fail to understand the information or fail to retain it. However, the answers to the questions you will be asked on the exam are in this book.

A couple of the other reviewers mention using other sources in addition to this book and I fully agree. I never use a single source for any certification test if I can help it. The Oracle documentation is well written and free to download.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
8 of 8 people found the following review helpful By Amazon Customer on February 5, 2010
Format: Paperback
After reading a few Oracle cert books I really, really, liked the way this book was organized. Structurally, it's written well, with cohesion, conciseness, and terms that don't seem like and endless decoupled liturgy of things to memorize.

However, the proof reading and syntax issues in this book blows. It's got way too many errata issues that I'm finding as I read. And this isn't good for a book that supposed to help you pass a test and for a book that's listed at 59.95.

And it's not terribly easy to find the already existing errata that's been published on McGraw Hill's web site(s) of which there are many.

Things I've found already (excluding the already published errata are)

Chapter 5 in the book indicates that BACKGROUND_DUMP_DEST parameter used to point to trace locations. However, this parameter is now deprecated.

Page 278 Chapter 7 Self Test Answers number 9. Indicates that D and E are the correct answers outing C "because there is no relevant information in V$DATABASE. However, on page 275 D in the question is V$DATABASE. D is one of the "correct" answers on page 278, yet V$DATABASE, as indicated, is incorrect. The problem is that there's a mismatch of the test question answers with the actual answers. According to the original question, the answer should be E for V$DATAFILE and for V$TABLESPACE. The answer needs to be rewritten, or the question does.

Page 278 Chapter 7 Self Test Answers number 10. Discusses the DBA_TABLESPACE view. There is no such view; however, DBA_TABLESPACES exists.

Also, I'm getting the feeling that the test questions were aggregated separately from its content. Which is OK, I rather like the challenge--seems more like a test.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052)
This item: OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052)
Price: $40.08
Ships from and sold by Amazon.com