Oracle8i Certified Professional SQL & PL/SQL Exam Guide [Hardcover]

Jason S. Couchman (Author)

Book Description

Publication Date: June 21, 2001 | ISBN-10: 0072191538 | ISBN-13: 978-0072191530

Prepare to pass the OCP SQL & PL/SQL exam. Officially authorized by Oracle Corporation, this book/CD-ROM package offers comprehensive coverage of all material on this exam. Chapter self-tests complete with in-depth explanations are included. The CD-ROM contains more than 250 practice questions that link further information on the subject in the electronic version of the book.

Editorial Reviews

From the Back Cover

Get Certified with Official Exam Prep Material from Oracle Press

Prepare to pass the OCP SQL & PL/SQL exam--a required exam for both OCP DBA and Application Developer certifications--using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details of all the material covered on this challenging exam followed by practice questions and chapter summaries to highlight what you've learned. Written for novices and experts alike, this book and CD-ROM package is the most comprehensive exam preparation tool available for this Oracle8i Certified Professional exam.

Featuring a logical methodology designed to reinforce learning, this exam guide offers:
*100% complete coverage of all official exam objectives
*More than 500 practice questions--including scenario-based and short-answer question formats
*Demos you can follow along with--based on standard Oracle demonstration tables contained in every database software release
*Exercises at the end of all chapter discussions so you can apply your Oracle knowledge right away
*Tips, examples, and reviews in every topic discussion to help you remember the key concepts for OCP
*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

Book and CD-ROM include more than 500 interactive exam-based questions. CD-ROM contains interactive exam feature that simulates the actual OCP exams through hotlinked questions, answers, and explanations.

About the Author

Jason Couchman (New York, NY) is an OCP-certified Oracle DBA and author of Oracle Certified Professional DBA Certification Exam Guide, Oracle Certified Professional Application Developer Exam Guide, Oracle Certified Professional DBO Certification Exam Guide, and Oracle8 Certified Professional DBA Practice Exams. He has led Oracle database projects with Fortune 500 corporations and presented topics at the North Carolina Oracle User Group. His articles on Internet and Intranet development have been published internationally.

Product Details

• Hardcover: 570 pages
• Publisher: McGraw-Hill Companies (June 21, 2001)
• Language: English
• ISBN-10: 0072191538
• ISBN-13: 978-0072191530
• Product Dimensions: 9.4 x 7.6 x 1.7 inches
• Shipping Weight: 3.2 pounds
• Average Customer Review: 2.7 out of 5 stars  See all reviews (13 customer reviews)
• Amazon Best Sellers Rank: #1,449,328 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

3 of 3 people found the following review helpful:

2.0 out of 5 stars Don't buy this book, December 9, 2001

By A Customer

This review is from: Oracle8i Certified Professional SQL & PL/SQL Exam Guide (Hardcover)

Book reviews should help people who have not purchased a book to make a buying decision. If you like frustration, like researching information in books and checking it for accuracy as if you were the author, go ahead, buy the book. But if you want a book that prepares you to take the OCP exams, buy something else.

2 of 2 people found the following review helpful:

2.0 out of 5 stars Fire the editor., April 30, 2002

By 

M. Whitman "michaelw" (Wilmington, DE USA) - See all my reviews
(REAL NAME)   

This review is from: Oracle8i Certified Professional SQL & PL/SQL Exam Guide (Hardcover)

This book is comprehensive and easy to understand, but contains many errors and contradictions. The Excercise questions are often vague or outright wrong. Furthermore the answer is just what letter is write with no explanation.

My advice go elsewhere. I hear SYBEX is good.

2 of 2 people found the following review helpful:

3.0 out of 5 stars Good review, has errors, September 26, 2001

By 

David Reno (San Jose, CA) - See all my reviews
(REAL NAME)   

This review is from: Oracle8i Certified Professional SQL & PL/SQL Exam Guide (Hardcover)

I was a DBA two years ago. I had about 3 years experience using Oracle. I found this book to be a good review, though I found myself finding various errors. Some errors were typo's, some were just my own disagreement with the author. I also felt like the author didn't have much experience as an Oracle DBA--this may be unjustified, but it was my feeling based on reading his examples and comments. Nonetheless, the sections of the book match up with the overview of knowledge required by the OCP test 1Z0-001 very well, and by design. I just read through the book and took one of the sample tests. Taking the real test, I scored 55/57 (39 is passing), so I think the book significantly helped me prepare.

Another problem with this book is that it is not followed up by others in this series. Now I am ready for the next test, but guess what, no book! That's right, I have the option of buying the book with all five tests, but not one book per test, like this one. I think I'm switching to the "Exam Cram" series due to that (even though I hate the title!)

I hope this helps,
Regards,
David