OCP: Oracle8i^TM DBA SQL and PL/SQL Study Guide: Exam 1Z0-001

by Chip Dawes; Biju Thomas

• ISBN13: 9780782153293
• ISBN10: 0782153291
• Format: eBook
• Copyright: 2006-02-01
• Publisher: Sybex

Summary

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.

Table of Contents

Introduction

Assessment Test

Relational Technology and Simple SQL SELECT Statements

Single-Row and Group Functions

Joins and Subqueries

Modifying Data and Security

Modifying Data and Security

Other Database Objects and the Data Dictionary

PL/SQL Basics

Interacting with the Database

Working with Composite Datatypes and Collections

Exception Handling

Practice Exam

Glossary

Index

Table of Contents provided by Publisher. All Rights Reserved.