rent-now

Rent More, Save More! Use code: ECRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

9781576105771

Oracle8 Dba: SQL and Pl/SQL : Exam Cram

by
  • ISBN13:

    9781576105771

  • ISBN10:

    1576105776

  • Format: Paperback
  • Copyright: 2000-02-01
  • Publisher: Coriolis Group
  • Purchase Benefits
  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
  • Write a Review Icon Write a Review
List Price: $29.99

Summary

Outlines Oracle8 version 8.0.5.2, and PL/SQL in a condensed format featuring practice questions and a tear-out cram sheet, valuable information on test strategies, study tips, shortcuts, and detailed material covering exam content.

Table of Contents

Introductionp. xv
Self-Assessmentp. xxv
Oracle OCP Certification Examsp. 1
Assessing Exam-Readinessp. 2
The Testing Situationp. 3
Test Layout And Designp. 4
Using Oracle's Test Software Effectivelyp. 6
Taking Testing Seriouslyp. 7
Question-Handling Strategiesp. 7
Mastering The Inner Gamep. 8
Additional Resourcesp. 9
DML: Using The INSERT, UPDATE, And DELETE Commandsp. 13
DML Elementsp. 14
DML Commandsp. 36
Practice Questionsp. 50
Need To Know More?p. 56
DML: Using The SELECT Commandp. 57
The SELECT Commandp. 58
Examples Using The SELECT Commandp. 65
Practice Questionsp. 86
Need To Know More?p. 93
DDL: Using the CREATE Command For All Objectsp. 95
The CREATE Commandp. 96
Oracle8 Object Tablesp. 116
Practice Questionsp. 123
Need To Know More?p. 130
DDL: Object Manipulation Commandsp. 131
Nontable CREATE Commandsp. 132
Additional Data Structure CREATE And DDL Commandsp. 149
Practice Questionsp. 159
Need To Know More?p. 164
DDL: Using The ALTER, COMMENT, And DROP Commandsp. 165
The ALTER Commandp. 166
The COMMENT Commandp. 190
The DROP Commandp. 191
Practice Questionsp. 193
Need To Know More?p. 200
DCL Commandsp. 201
Usersp. 202
Grantsp. 207
Rolesp. 222
Special Rolesp. 227
Profilesp. 230
Practice Questionsp. 240
Need To Know More?p. 246
The Oracle Data Dictionaryp. 247
Overview Of The Oracle Data Dictionaryp. 248
Oracle C Structs And V$ Viewsp. 248
Practice Questionsp. 269
Need To Know More?p. 274
Database Design And Modelingp. 275
The Five-Step System Development Cyclep. 276
Database Designp. 278
Oracle And The Object Paradigmp. 282
Practice Questionsp. 296
Need To Know More?p. 302
PL/SQLp. 305
The PL/SQL Enginep. 306
PL/SQL Basicsp. 306
DML And PL/SQLp. 320
Changes For Oracle8p. 324
Practice Questionsp. 326
Need To Know More?p. 335
Sample Testp. 337
Questions, Questions, Questionsp. 338
Picking Correct Answersp. 338
Decoding Ambiguityp. 339
Working Within The Frameworkp. 340
Preparing For The Testp. 341
Taking The Testp. 341
Sample Testp. 343
Answer Keyp. 371
Glossaryp. 385
Indexp. 397
Table of Contents provided by Syndetics. All Rights Reserved.

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program