OCP Oracle9i Database: Performance Tuning Exam Guide [Hardcover]

Charles Pack (Author)

Book Description

ISBN-10: 0072195274 | ISBN-13: 978-0072195279 | Publication Date: March 27, 2002 | Edition: 1

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.

Editorial Reviews

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.

About the Author

McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide

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: 8.9 x 7.1 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 Best Sellers Rank: #1,588,352 in Books (See Top 100 in Books)

More About the Author

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

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

This review is from: OCP Oracle9i Database: Performance Tuning Exam Guide (Hardcover)

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

This review is from: OCP Oracle9i Database: Performance Tuning Exam Guide (Hardcover)

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 "OCP Oracle 6i/9i/10g, SCSA Solaris ... (Montreal, QC Canada) - See all my reviews

This review is from: OCP Oracle9i Database: Performance Tuning Exam Guide (Hardcover)

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.