Buy Used
FREE Delivery on orders over £10.
Used: Very Good | Details
Sold by the book house
Condition: Used: Very Good
Comment: This item will be picked, packed and shipped by Amazon and is eligible for free delivery within the UK
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Oracle8i Certified Professional SQL and PL/SQL Exam Guide (Oracle (McGraw-Hill)) Hardcover – Jul 2001

See all formats and editions Hide other formats and editions
Amazon Price New from Used from
"Please retry"
£29.49 £0.01

Product details

  • Hardcover: 512 pages
  • Publisher: Osborne/McGraw-Hill; Har/Cdr edition (July 2001)
  • Language: English
  • ISBN-10: 0072191538
  • ISBN-13: 978-0072191530
  • Product Dimensions: 4.4 x 19 x 23.5 cm
  • Average Customer Review: 3.5 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Bestsellers Rank: 6,023,987 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

Product Description

From the Publisher

More than 300 practice exam questions
Chapters include summaries, highlighting the key points discussed previously
Two-Minute drills at the end of each chapter quiz readers' retention
Glossary of key Oracle terms
All topics are mapped closely to the Oracle exam objectives as included in the official candidate guide for the exam
CD-ROM testing engine simulates the actual exam environment and hyperlinks questions back to electronic chapters and sections of the book

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.

Inside This Book (Learn More)
First Sentence
The first exam in the OCP series covers your understanding of basic areas of database usage and design. Read the first page
Explore More
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

3.5 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See both customer reviews
Share your thoughts with other customers

Most Helpful Customer Reviews

1 of 1 people found the following review helpful By A Customer on 7 Sep 2001
Format: Hardcover
This book goes one step further in its explanation of SQL concepts and techniques.The work done in the Developer exam guide was too shallow for a deep understanding in order to correctly answer the 'trick' questions. most (if not all) of the oracle8i concepts included in the text aren't asked in the exam, but It's good to have an Idea of it anyway. More work has been done on the SQL*PLUS reporting, which is good. The last chapter which has three tests is a plus as it really comes close to the real thing. The downside of the book is the fact that some of the errors in the developer guide have found their way into this book as well as some new ones. also, the multiple column subqueries concept wasn't adequately covered as you might see some questions based on this that weren't covered in the book. If you use this book, as well as using the Oracle CBT, You can be sure to answer at least 43 questions right.
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
1 of 1 people found the following review helpful By on 8 Nov 2001
Format: Hardcover
This book has helped me a great deal in preparing for the exam and it will definitely give you a good shot at passing it. It is however a shame that it contains quite a few errors in the review questions and that a few topics are a bit hazy. The book invites you to carry on studying as the build-up is good and the reading pleasant. The biggest down point I found is that when you send in the mistakes you found in the book by email, there is no response from the author as the preface promises.
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 Helpful Customer Reviews on (beta) 13 reviews
3 of 3 people found the following review helpful
Don't buy this book 9 Dec 2001
By A Customer - Published on
Format: 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
Good review, has errors 26 Sep 2001
By David Reno - Published on
Format: 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,
2 of 2 people found the following review helpful
Fire the editor. 30 April 2002
By M. Whitman - Published on
Format: 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.
Misleading and unresponsive... 21 Aug 2001
By A Customer - Published on
Format: Hardcover
I bought this book thinking that along with the class I was taking from Oracle University, Couchman's guide would take me over the top.
Unfortunately, I was wrong.
As someone who just took the test this book is all about, I can assure you that it is NOT very helpful.
My main problem is that there there are many sections of this book that were not on the test. For example, I spent many hours studying the "bitmap and b-tree indexes". This was a very complex concept to understand. Imagine how frustrated I was when this wasn't covered on the test at all! In addition, Procedures and Functions were in the text but not the subject of any questions of the test.
One might say, "oh, well maybe Couchman included these sections to help illustrate a basic topic." That's not right! We all have only limited time to study for an exam - I want everything in a guide book to be concise! Every page I read in the book should've been what is on the test.
The other major problem I have with this book is that there are many errors! Some solutions are blatant mistakes, and also there are some horrible typos! In the preface, Couchman gives his e-mail address and a website that should help with errata. But guess what?? The website has NOTHING about this particular book, and an e-mail to Couchman went unreplied to (it has been over 2 weeks now).
It is just too bad that my Oracle instructor told me after I took the test that it is best just to focus on the book we received in class from Oracle.
This book did offer some help with some of the topics covered on the test, but overall was not worth the money I paid for it. I hope no one else makes the mistake I made.
Good book... Recommended.... 28 Sep 2001
By Nelson Urbano - Published on
Format: Hardcover Verified Purchase
The book covers most of the material for the OCP SQL & PL/SQL exam. Actually, it covers part of OCP DBA what may be a waste of time if you're not taking the DBA portion of it. The CD brings simulated exams and I found the questions similar to the real exam (the CD itself is worth the money I paid on the book). The book and the CD have 100s of question/answer. The book needs improvements though, the answers to the tests references the subject by the topic, but the topics index make no reference to the page where the subject can be found, what makes hard to find the subject for reviews.
Were these reviews helpful? Let us know