OCP Oracle9i Database: Performance Tuning Exam Guide (Hardcover)

by Charles Pack (Author) "The purpose of this chapter is to describe the basic form and function of this book, to provide you with a brief overview of the..." (more)
Key Phrases: undo tahlespace, configured rollback segments, cursor state information, Explain Plan, Two-Minute Drill, Oracle Expert (more...)

Editorial Reviews

Product Description
Prepare to pass the Oracle9i OCP DBA Performance Tuning exam using this focused, and complete guide. Covering all official exam objectives and containing over 300 practice questions, chapter self-tests, two minute drills, a glossary of key Oracle terms--plus a CD-ROM with a testing engine that simulates the actual exam--this is the best study tool available.

From the Back Cover
Get Certified with Official Exam Prep Material from Oracle Press

Prepare for the Oracle Certified Professional Oracle9i Database: Performance Tuning exam--a required exam for Oracle9i DBA certification--using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what you've learned. Authorized by Oracle Corporation, this book and CD-ROM package is the most comprehensive preparation tool available for the Oracle9i Database: Performance Tuning exam.

• 100% complete coverage of all official exam objectives
• Exercises at the end of all discussions that reinforce your Oracle knowledge right away
• Tips, examples, and reviews in every chapter to help you remember key concepts
• Two-minute drills--quick and concise checklists that summarize each chapter's main points
• Chapter self-tests--exam-based questions complete with in-depth explanations
• More than 300 practice questions--including scenario-based questions

Book and CD-ROM include more than 300 interactive exam-based questions. CD-ROM contains interactive exams that simulate the actual OCP exams and include hotlinked questions, answers, and explanations.

See all Editorial Reviews

Product Details

• Hardcover: 470 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (March 27, 2002)
• Language: English
• ISBN-10: 0072195274
• ISBN-13: 978-0072195279
• Product Dimensions: 9.1 x 7.4 x 1.6 inches
• Shipping Weight: 2.3 pounds (View shipping rates and policies)
• Average Customer Review: 4.6 out of 5 stars See all reviews (10 customer reviews)
• Amazon.com Sales Rank: #56,673 in Books (See Bestsellers in Books)

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

  #22 in	Books > Computers & Internet > Certification Central > Publisher > Osborne-McGraw-Hill
  #31 in	Books > Computers & Internet > Databases > Relational Databases
  #40 in	Books > Computers & Internet > Databases > Oracle

Customer Reviews

Most Helpful Customer Reviews

5 of 5 people found the following review helpful:

4.0 out of 5 stars A good preparation tool, September 16, 2002

By	CREFCOEUR PHILIPPE (Brussels Belgium) - See all my reviews

My purpose was to pass the exam and I have done it using this book but also the Sybex book by J. Johnson.
Both of them are very good books and are complementary.

Pros:
- very well structured and very clear
- the exam-based questions are representative
- the level of detail for package procedures is good

Cons:
- some answers to exam questions I had can't be found in the book
- there are typing mistakes in capital letters commands

My advice:
- have a good understanding of Oracle views. I had between 10 and 15 questions relating to views.
- use both books to be well prepared. This exam is quite difficult.

9 of 11 people found the following review helpful:

5.0 out of 5 stars Best in the series and very well written, May 28, 2002

By	Linda Zarate "IT Ops Consultant" (Azusa, CA United States) - See all my reviews (TOP 500 REVIEWER)

This book is not only an excellent study guide for both the OCP classes and the exam, but a wonderfully written explanation of the complexities of performance and tuning. Of all of the material I've read on this subject [for training and examination purposes], nothing has made more sense or been more enlightening than this book.

All of the key elements of performance tuning are covered, the illustrations are excellent and aid in understanding, and the drills, self tests and practice questions have been a tremendous help.

4 of 4 people found the following review helpful:

4.0 out of 5 stars Good Exam Guide, October 4, 2004

By	TLAW_DBA (Montreal, QC Canada) - See all my reviews

I used this book to study for the Performance Tuning Exam. This book covers all the objectives of the exam in much more organized way. The chapters reflect the contents of the checklist designed by oracle. Study the chapters carefully before taking the practice exams. Concerning the practices exam itself, it has some mistakes. Some of the answers to the questions are wrong but if you understand the material you will notice those mistakes. Or if you want to clear any doubt you can also check the oracle online manual.
On the exam, expect a lot of questions concerning the views, latch contentions, and some initializations parameters.
My suggestion to you is if you want to maximize your chance you can buy the sybex study guide which is also good. Both books are good for the exam except that I found the Oracle press book more organized. I will definitely recommend them if you are planning to take the performance tuning exam.