Ocp: Oracle8I Dba SQL and Pl/SQL Study Guide : Exam 1Z0-001

Dawes, Chip; Thomas, Biju; Biju Thomas

ISBN 10: 0782126820 / ISBN 13: 9780782126822

Published by Sybex Inc, 2000

About this Item

In shrink wrap. Looks like an interesting title! Seller Inventory # Q-0782126820

Bibliographic Details

Title: Ocp: Oracle8I Dba SQL and Pl/SQL Study Guide...

Publisher: Sybex Inc

Publication Date: 2000

Binding: Hardcover

Condition: New

About this title

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.

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