OCP: Oracle8i DBA SQL and PL/SQL Study Guide (OCP study guide) - Hardcover

Dawes, Chip; Thomas, Biju

Hardcover

ISBN 10: 0782126820 ISBN 13: 9780782126822

Publisher: John Wiley & Sons, 2000

Synopsis

Here′s the book you need to prepare for Exam 1Z0–001, Introduction to Oracle: SQL and PL/SQL. Written by Oracle8i experts, this affordable and comprehensive Study Guide provides:

• Full coverage of every exam objective–all the information you need
• Practical information on using SQL and PL/SQL in a real–world Oracle8i environment
• Hundreds of challenging review questions, in the book and on the CD
• Leading–edge exam preparation software, including a testing engine and electronic flashcards

This title is billed as the only study guide on the market targeting the PL/SQL exam, required for both the DBA and the Application Developer tracks. The book provides a self–assessment test, key term definitions, review questions, a practice exam, plus an enhanced CD with testing software.

Note: CD–ROM/DVD and other supplementary materials are not included as part of eBook file.

About this title

Review

One of a series of Oracle Certified Professional study guides this one, as the name rather heavily suggests, covers the ground you need to know in order to pass the Introduction to Oracle: SQL and PL/SQL examination. The exam forms part of the certification required to become an Oracle8i Certified Database Administrator or Application Developer.

OCP: Oracle8i DBA SQL and PL/SQL Study Guide focuses first on the SQL querying language and then on Oracle's own implementation, PL/SQL, bringing in SQL*Plus, an Oracle tool for interaction with a database. Each chapter starts with a list of objectives and ends with a brief summary, a list of the terms that should have been absorbed followed by 20 multiple choice questions and answers. There is also a practice exam at the end of the book. The CD-ROM contains a bank of questions that includes those from the book and a further series of questions on electronic flashcards that run on a PC or a Palm device. The text of the book is also present in Adobe Acrobat format.

An instance early in the book of a reference to the wrong figure doesn't build confidence and later on a table is split between two pages so that you have to flick back and forth to make sense of it; but in the main the layout is reasonable.

The questions and sample exam paper are useful for getting the feel of what you will face in your attempt to reach the 72 per cent pass mark. Unfortunately there is nothing inspirational about this study guide, just of a lot of hard slog--but whoever said that passing exams was easy? --Mark Whitehorn

About the Author

Chip Dawns, OCP, has worked with Oracle databases since 1990. He is a consultant with D&D Technologies and often is a presenter at Oracle User Group conferences.

Bijou Thomas has more than six years of Oracle database management and application development experience. He has written articles for both Oracle Magazine and Oracle Internals.

Edition details

• Publisher: John Wiley & Sons
• Publication date: 2000
• ISBN 10: 0782126820
• ISBN 13: 9780782126822
• Binding: Hardcover
• Language: English
• Number of pages: 536