OCA Oracle Database 11g: Administration I Exam Guide (Exam 1Z0-052) (Paperback)

by John Watson (Author)
Key Phrases: oracle home, managing schema objects, database instance, Oracle Net, Enterprise Manager, Self Test (more...)

Editorial Reviews

Product Description

A Fully Integrated Study System for OCA Exam 1Z0-052

Prepare for the Oracle Certified Associate Oracle Database 11g Administration I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-052, including:

• Database architecture
• Creating an Oracle Database
• Managing the Oracle instance
• Configuring and managing the Oracle network
• Managing database storage structures
• Administering user security
• Managing schema objects, data and concurrency, and undo data
• Implementing Oracle Database security
• Database maintenance and performance management
• Backup and recovery
• Moving data
• Intelligent infrastructure enhancements

On the CD-ROM:

• One full practice exam that simulates the actual OCA exam
• Detailed answers and explanations
• Score report performance assessment tool
• Complete electronic book
• Bonus exam available free with online registration

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.

Product Details

• Paperback: 733 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (May 23, 2008)
• Language: English
• ISBN-10: 0071591028
• ISBN-13: 978-0071591027
• Product Dimensions: 9 x 7.4 x 1.7 inches
• Shipping Weight: 2.8 pounds (View shipping rates and policies)
• Average Customer Review: 4.3 out of 5 stars See all reviews (3 customer reviews)
• Amazon.com Sales Rank: #31,454 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #6 in	Books > Computers & Internet > Certification Central > Oracle
  #11 in	Books > Computers & Internet > Certification Central > Publisher > Osborne-McGraw-Hill
  #16 in	Books > Computers & Internet > Databases > Oracle

Customer Reviews

Most Helpful Customer Reviews

12 of 13 people found the following review helpful:

3.0 out of 5 stars decent - has some inaccuracies, June 24, 2008

By	Matthew B. Jacobson "mb_jacobson" (Seattle) - See all my reviews (REAL NAME)

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.

Edit 9/10/2008 - Now that I'm further into the book I'm going to have to say; don't get this book - it's too inaccurate. Here's another example - one of their sample exam questions asks for modifiers that can be applied to a b-tree index and not a bitmap index. One of the WRONG answers was "descending". To quote: "Descending, function-based, and compound indexes can be either b*tree or bitmap.

It seemed really odd to me that you could make a bitmap index descending. So I looked it up the CREATE INDEX statement on oracle docs 11g:

ASC | DESC
(...)
Restriction on Ascending and Descending Indexes You cannot specify either of these clauses for a domain index. You cannot specify DESC for a reverse index. ****Oracle Database ignores DESC if index is bitmapped**** or if the (...)

5.0 out of 5 stars Very helpful book, June 3, 2009

By	Dmitri A. Levin (Warrington, PA USA) - See all my reviews (REAL NAME)

This book is a must for 1Z0-052 test. I have Oracle's video course on CD ($750). It is not even close to the quality of that book. John Watson did a great job!

1 of 4 people found the following review helpful:

5.0 out of 5 stars Excellent resource , November 3, 2008

By	Richard Sparno - See all my reviews (REAL NAME)

The goal of this book is not to completely prepare you to pass the certification exam in it's entirety without other resources. It would be absurd to think this. The goal is to coach you through preparation for the exam. The book does an excellent job in explaining most of the subject matter in an easy to read format. Although it does make a few typo errors here and there, it should not take away from the value of the book. I could not have passed the test without this book unless of course I shelled out $3000 to take the prep course directly from Oracle.
I would recommend buying this book, purchasing sample test questions from Self Test Software, installing a copy of Oracle 11g on your personal computer and referencing the Oracle 11g Administration manual from time to time in order to pass the certification exam.