×

Uh-oh, it looks like your Internet Explorer is out of date.

For a better shopping experience, please upgrade now.

OCP Introduction to Oracle9i: SQL Exam Guide / Edition 1
     

OCP Introduction to Oracle9i: SQL Exam Guide / Edition 1

by Jason Couchman
 

See All Formats & Editions

ISBN-10: 0072195371

ISBN-13: 9780072195378

Pub. Date: 10/29/2001

Publisher: McGraw-Hill Professional Publishing

Prepare to pass the OCP Introduction to Oracle9i SQL exam--a required exam for OCA/OCP DBA certification--using this Oracle Press study guide. You'll get complete coverage of all exam topics followed by practice questions and chapter summaries. The CD-ROM contains hundreds of practice exam questions in an adaptive format.

Overview

Prepare to pass the OCP Introduction to Oracle9i SQL exam--a required exam for OCA/OCP DBA certification--using this Oracle Press study guide. You'll get complete coverage of all exam topics followed by practice questions and chapter summaries. The CD-ROM contains hundreds of practice exam questions in an adaptive format.

Product Details

ISBN-13:
9780072195378
Publisher:
McGraw-Hill Professional Publishing
Publication date:
10/29/2001
Series:
Oracle Press Series
Pages:
512
Product dimensions:
7.30(w) x 9.30(h) x 1.47(d)

Table of Contents

Prefacexi
Introductionxiii
Part IPreparing for OCP DBA Exam I: Introduction to SQL
1Overview of Oracle Databases5
Overview of Oracle7
Theoretical and Physical Aspects of Relational Databases7
Oracle's RDBMS and ORDBMS Implementations11
Usage and Benefits of PL/SQL17
Writing Basic SQL Statements20
Capabilities of SQL select Statements20
Executing select Statements25
Differentiating Between SQL and SQL *Plus Commands38
Chapter Summary48
Two-Minute Drill48
Fill-in-the-Blank Questions50
Chapter Questions50
Fill-in-the-Blank Answers53
Answers to Chapter Questions53
2Limiting, Sorting, and Manipulating Return Data55
Restricting and Sorting Row Data56
Sorting Return Data with the order by Clause56
Limiting Return Data with the where Clause61
Using Single-Row Functions67
Various Single-Row Functions Explained67
Using Functions in select Statements73
Date Functions81
Conversion Functions86
Chapter Summary90
Two-Minute Drill90
Fill-in-the-Blank Questions91
Chapter Questions91
Fill-in-the-Blank Answers94
Answers to Chapter Questions94
3Advanced Data Selection in Oracle97
Displaying Data from Multiple Tables98
The Keys to Table Joins99
Select Statements That Join Data from More Than One Table99
Creating Outer Joins109
Joining a Table to Itself118
Group Functions and Their Uses122
Identifying and Using Group Functions122
Using the group by Clause126
Excluding group Data with having133
Chapter Summary135
Two-Minute Drill135
Fill-in-the-Blank Questions138
Chapter Questions138
Fill-in-the-Blank Answers140
Answers to Chapter Questions140
4Subqueries143
Using Subqueries144
Understanding and Defining Subqueries145
Listing and Writing Different Types of Subqueries150
Writing Multiple-Column Subqueries156
NULL Values and Subqueries158
Subqueries in a from Clause161
Producing Readable Output with SQL *Plus165
Entering Variables165
Customizing SQL *Plus Environments173
Producing Readable Output181
Creating and Executing Scripts187
Saving Customizations188
Chapter Summary190
Two-Minute Drill191
Fill-in-the-Blank Questions193
Chapter Questions193
Fill-in-the-Blank Answers197
Answers to Chapter Questions197
5Creating Oracle Database Objects201
Creating the Tables of an Oracle Database202
Describing Tables203
Creating Tables205
Datatypes and Column Definitions211
Altering Table Definitions219
Dropping, Renaming, and Truncating Tables224
Including Constraints227
Describing Constraints228
Creating and Maintaining Constraints232
Chapter Summary248
Two-Minute Drill248
Fill-in-the-Blank Questions251
Chapter Questions251
Fill-in-the-Blank Answers255
Answers to Chapter Questions255
6Manipulating Oracle Data259
Adding New Rows to a Table260
Making Changes to Existing Row Data267
Deleting Data from the Oracle Database270
Merging Data in Oracle Tables273
The Importance of Transaction Control279
Chapter Summary285
Two-Minute Drill286
Fill-in-the-Blank Questions287
Chapter Questions287
Fill-in-the-Blank Answers289
Answers to Chapter Questions289
7Creating Other Database Objects in Oracle291
Creating Views292
Creating Simple Views293
Creating Views That Enforce Constraints301
Creating Complex Views305
Modifying and Removing Views310
Other Database Objects313
Overview of Other Database Objects314
Using Sequences315
Using Indexes322
Using Public and Private Synonyms331
Chapter Summary335
Two-Minute Drill336
Fill-in-the-Blank Questions339
Chapter Questions339
Fill-in-the-Blank Answers343
Answers to Chapter Questions343
8User Access Control in Oracle347
Creating Users348
Granting and Revoking Object Privileges356
Using Roles to Manage Database Access365
Chapter Summary372
Two-Minute Drill372
Fill-in-the-Blank Questions374
Chapter Questions374
Fill-in-the-Blank Answers376
Answers to Chapter Questions376
Part IIOCP Oracle9i DBA Practice Exams
9OCP Exam I: Introduction to SQL381
Practice Exam 1382
Practice Exam 2401
Practice Exam 3417
Answers to Practice Exam 1439
Answers to Practice Exam 2452
Answers to Practice Exam 3464
Index465

Customer Reviews

Average Review:

Post to your social network

     

Most Helpful Customer Reviews

See all customer reviews