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

by Dawes, Chip; Thomas, Biju

• ISBN13: 9780782126822
• ISBN10: 0782126820
• Format: Hardcover
• Copyright: 2000-09-01
• Publisher: John Wiley & Sons Inc

Summary

Here2s 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	xvii
Assessment Test	xxvii
Relational Technology and Simple SQL SELECT Statements	1	(64)
Single-Row and Group Functions	65	(62)
Joins and Subqueries	127	(38)
Modifying Data and Security	165	(48)
Creating and Managing Tables and Views	213	(34)
Other Database Objects and the Data Dictionary	247	(52)
PL/SQL Basics	299	(42)
Interacting with the Database	341	(40)
Working with Composite Datatypes and Collections	381	(34)
Exception Handling	415	(30)
Appendix A Practice Exam	445	(30)
Glossary	475	(6)
Index	481