Prepare for the Oracle Certified Professional Developer PL/SQL Program Units exam 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. The CD-ROM contains hundreds of practice exam questions in an adaptive format.
OCP Developer PL/SQL Program Units Exam Guide
and over one million other books are available for Amazon Kindle.
Learn more
FREE Two-Day Shipping for Students. Learn more |
| ||||||||||||||||||
 Sell Back Your Copy for $1.86
Whether you buy it used on Amazon for $11.29 or somewhere else, you can sell it back through our Book Trade-In Program at the current price of $1.86.
Used Price$11.29
Trade-in Price$1.86
Price after
Trade-in$9.43 |
Book Description
Special Offers and Product Promotions
- Buy $50 in qualifying physical textbooks, get $5 in Amazon MP3 Credit. Here's how (restrictions apply)
Frequently Bought Together
Editorial Reviews
From the Back Cover
Get Certified with Official Exam Prep Material from Oracle Press
Prepare for the Oracle Certified Professional Developer PL/SQL Program Units exam--a required exam for Oracle Internet Application Developer 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. From the exclusive publisher of Oracle Press Books, this package is the most comprehensive preparation tool available for the OCP Developer PL/SQL Program Units 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
Required Exam for OCP Internet Application Developer Certification
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
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, read author blogs, and more.
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
35 of 35 people found the following review helpful:
5.0 out of 5 stars
Good reference for the IZ0-147 exam,
By
This review is from: OCP Developer PL/SQL Program Units Exam Guide (Paperback)
I used this book as one of my study guides for the new IZ0-147 "Oracle 9i: Program with PL/SQL" exam which I recently passed. This is an excellent book that covers many of the concepts found in the IZ0-147 exam. It, of course, does not cover everything needed for the IZ0-147 exam. Some things to look up elsewhere include LOBs, side effects (sql stmts calling functions are covered well in the book), and the 'call' command used in a trigger.
23 of 23 people found the following review helpful:
5.0 out of 5 stars
Great preparation for the 1Z0-101 OCP exam,
By
This review is from: OCP Developer PL/SQL Program Units Exam Guide (Paperback)
For me this book worked for the OCP exam (53/57 questions correct in 32 minutes). With this book it took me 1 week to prepare for this exam (weekday evenings and most of the weekend).If you want to do the PL/SQL program units exam this book is definitely the book to go for. I did not find any errors in this book. In the test questions from ORACLE I found no questions that was not explained in the book in a very understandable form. Beeing a not native speaker I can not really comment on the style of writing but I found it very readable. This book mentions one very import thing about the exam: read the questions first and than read the source code. I found that sometimes you actually do not need the (lengthy) source code in order to answer the questions.
12 of 12 people found the following review helpful:
5.0 out of 5 stars
Very helpful,
By Srini (Woodbridge, VA USA) - See all my reviews
This review is from: OCP Developer PL/SQL Program Units Exam Guide (Paperback)
I used this to pass the PL/SQL OCP. These books are not for learning SQL and PL/SQL, these books are to prepare for the exams. But this PL/SQL book has chapters that teach PL/SQL very well, and a lot of material to cover the language if you have not worked with it before. I like the sample questions at the end of every section and chapter, they helped me a lot. The longer practice exams in the back are very very good, and I found them to be a lot like the questions on the exam. I had trouble with the CD, but the book was very good. I recommend it to anyone taking the exam. Since this book is from Oracle, I think it is best choice for taking the Oracle exams.
Share your thoughts with other customers: Create your own review
|
|
Inside This Book
(learn more)
First Sentence:
To understand Procedural Language/Structured Query Language (PL/SQL) program units, you must first understand the basic language syntax of PL/SQL. Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
packaged constructs, cur cruises, timestamp mode, automatic datatype conversion, consider the following code sample, following package specification, local text editor, program unit call, buffer editor, trigger header, called program unit, database object privileges, cur employees, datatype family, overloaded modules, local program unit, constraining tables, rec employees, mutating table, other program units, declared constructs, following data dictionary views, public cursors, stored database procedure, calling block Key Phrases - Capitalized Phrases (CAPs): (learn more)
Procedure Builder, Object Navigator, Oracle Form, Answer Key, Oracle Corporation, Two-Minute Drill, Explanation Any, Procedural Language, Explanation All, File Edit Search Options Help, Step Out, Structured Query Language, Microsoft Windows, Oracle Report, Practice Exam, Source Pane, Navigator Pane, Oracle Press, Using Oracle, Data Manipulation Language, Explanation Even, Writes No Database State, Explanation Only, Explanation There, Festival Application New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
To understand Procedural Language/Structured Query Language (PL/SQL) program units, you must first understand the basic language syntax of PL/SQL. Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
packaged constructs, cur cruises, timestamp mode, automatic datatype conversion, consider the following code sample, following package specification, local text editor, program unit call, buffer editor, trigger header, called program unit, database object privileges, cur employees, datatype family, overloaded modules, local program unit, constraining tables, rec employees, mutating table, other program units, declared constructs, following data dictionary views, public cursors, stored database procedure, calling block Key Phrases - Capitalized Phrases (CAPs): (learn more)
Procedure Builder, Object Navigator, Oracle Form, Answer Key, Oracle Corporation, Two-Minute Drill, Explanation Any, Procedural Language, Explanation All, File Edit Search Options Help, Step Out, Structured Query Language, Microsoft Windows, Oracle Report, Practice Exam, Source Pane, Navigator Pane, Oracle Press, Using Oracle, Data Manipulation Language, Explanation Even, Writes No Database State, Explanation Only, Explanation There, Festival Application New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
Citations (learn more)
Books on Related Topics
(learn more)
|
What Other Items Do Customers Buy After Viewing This Item?
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
Customer Discussions
|
This product's forum
Active discussions in related forums
Search Customer Discussions
|
Related forums
|
Listmania!
|
|
So You'd Like to...
Look for Similar Items by Category
- Books > Computers & Technology > Certification
- Books > Computers & Technology > Databases > Database Management Systems
- Books > Computers & Technology > Databases > Relational Databases
- Books > Computers & Technology > Databases > SQL
- Books > Computers & Technology > Programming > Languages & Tools
- Books > Computers & Technology > Software
- Books > Education & Reference > Education > Test Guides - Graduate & Professional > Professional
- Books > New & Used Textbooks > Computer Science > Database Storage & Design
- Books > New & Used Textbooks > Computer Science > Programming Languages
- Books > New & Used Textbooks > Test Prep & Study Guides
