did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

9780619159009

Oracle9I Database Administrator: Implementation and Administration (Book with CD-ROM)

by
  • ISBN13:

    9780619159009

  • ISBN10:

    0619159006

  • Edition: 1st
  • Format: Paperback
  • Copyright: 2003-02-17
  • Publisher: Cengage Learning
  • View Upgraded Edition
  • Purchase Benefits
List Price: $159.95

Summary

Oracle9i Database Administrator: Implementation and Andimistration provides thorough instruction in the operations of an Oracle database using Oracle9i, the client/server database and application development utility of choice in industry and in academia. This text covers the day-to-day duties of the database administrator, from initialization parameters and table space storage, to data integrity, constraints, and user profiles. It will also prepare users for the Oracle certification exam, Database Fundamentals I (#1Z0-031), through comprehensive coverage of the exam objectives and exam-like practice questions at the end of each chapter. Extensive end of chapter material such as Review Questions, Hands-On Assignments, and Case Projects give readers the opportunity to further strengthen their understanding of the material.

Table of Contents

Preface xi
Oracle Architecture Overview
1(26)
Introduction to Oracle9i Architecture
2(8)
Key Components of the Oracle9i
2(3)
Running the Database
5(4)
Optional Additions to Oracle9i
9(1)
Introduction to ORACLASS database
10(1)
Overview of Oracle9i Installation Options
11(4)
Comparing Server-Side Installation Options
12(2)
Comparing Client-Side Installation Options
14(1)
Introduction to Oracle Universal Installer
15(3)
Oracle Home
15(3)
Description of OFA (Optimal Flexible Architecture)
18(3)
Directory Structure Standards
18(2)
File Naming Standards
20(1)
Chapter Summary
21(2)
Review Questions
23(1)
Exam Review Questions---Database Fundamentals I (#1Z0-031)
23(2)
Hands-on Assignments
25(1)
Case Project
26(1)
Overview of Database Administrator (DBA) Tools
27(42)
Overview of DBA Tools
28(3)
Configuring Oracle Net to Connect to the Database
31(9)
Overview of Oracle Net Architecture
31(3)
Step-By-Step Configuring of Oracle Net
34(6)
Oracle Memory and Background Processes
40(6)
Connecting to the Database
40(2)
Memory Components and Background Processes
42(4)
Introducing Enterprise Manager
46(16)
Starting and Configuring the Enterprise Manager Console
47(4)
Viewing the Features of Enterprise Manager
51(11)
Chapter Summary
62(2)
Review Questions
64(1)
Exam Review Questions---Database Fundamentals I (#1Z0-031)
65(2)
Hands-on Assignments
67(1)
Case Project
68(1)
Creating an Oracle Instance
69(50)
Steps for Creating a Database
70(1)
Overview of Prerequisites for Creating a Database
71(1)
Configuring Initial Settings
72(11)
DBA Authentication Methods
73(4)
File Management Methods
77(3)
Set the Initialization Parameters
80(3)
Creating a Database
83(25)
Create a New Database Using the Database Configuration Assistant
84(9)
Starting and Stopping the Database with Instance Manager
93(5)
Creating a Database Manually
98(8)
Starting and Stopping a Database Manually
106(2)
Chapter Summary
108(3)
Review Questions
111(1)
Exam Review Questions---Database Fundamentals I (#1Z0-031)
112(2)
Hands-on Assignments
114(2)
Case Project
116(3)
Data Dictionary Views and Control Files
119(30)
Looking at Important Data Dictionary Components
120(3)
Using Data Dictionary Views
123(8)
Useful Dynamic Performance Views
129(2)
Introduction to the Control File
131(11)
Managing and Multiplexing the Control Files
132(4)
Using OMF to Manage Control Files
136(1)
Creating a New Control File
137(3)
Viewing Control File Data
140(2)
Chapter Summary
142(1)
Review Questions
143(1)
Exam Review Questions---Database Fundamentals I (#1Z0-031)
144(2)
Hands-on Assignments
146(2)
Case Project
148(1)
The Redo Log Files and Diagnostic Files
149(36)
Introduction to Online Redo Log Files
150(4)
The Purpose of Redo Log Files
152(1)
The Structure of Redo Log Files
153(1)
Managing Redo Log Files
154(17)
Log Switches and Checkpoints
155(2)
Multiplexing and Other Maintenance
157(10)
Using OMF to Manage Online Redo Log Files
167(2)
Finding Redo Log Information in Dynamic Performance Views
169(2)
Overview of Diagnostic Files
171(4)
Chapter Summary
175(1)
Review Questions
176(1)
Exam Review Questions---Database Fundamentals I (#1Z0-031)
177(3)
Hands-on Assignments
180(3)
Case Project
183(2)
Basic Storage Concepts and Settings
185(46)
Introduction to Storage Structures
186(23)
Logical Structure Versus Physical Structure
187(4)
Tablespaces and Datafiles
191(12)
Segment Types and Their Uses
203(2)
Temporary Tablespace
205(2)
Tablespaces with Nonstandard Data Block Size
207(2)
Configuring and Viewing Storage
209(9)
Changing the Size, Storage Settings, and Status
209(7)
Querying the Data Dictionary for Storage Data
216(2)
Overview of Undo Data
218(5)
Implementing Automatic Undo Management
219(4)
Chapter Summary
223(2)
Review Questions
225(1)
Exam Review Questions---Database Fundamentals I (#1Z0-031)
226(1)
Hands-on Assignments
227(3)
Case Projects
230(1)
Basic Table Management
231(54)
Introduction to Table Structures
232(14)
Setting Block Space Usage
234(5)
Storage Methods
239(3)
Row Structure and the Rowid
242(4)
Creating Tables
246(27)
Columns and Data Types
246(4)
Creating Relational Tables
250(6)
Creating Temporary Tables
256(3)
Creating Varrays and Nested Tables
259(8)
Creating Object Tables
267(1)
Creating Partitioned Tables
268(5)
Chapter Summary
273(2)
Review Questions
275(2)
Exam Review Questions---Database Fundamentals I (#1Z0-031)
277(3)
Hands-on Assignments
280(3)
Case Project
283(2)
Advanced Table Management
285(36)
Advanced Table Structures
286(10)
Tables with LOB Columns
286(1)
LOB Storage
287(4)
Index-Organized Tables
291(5)
Overview of Table Management
296(13)
Analyzing a Table
296(2)
Adjusting Table Storage Structure
298(2)
Reorganizing a Table
300(4)
Making Other Table Changes
304(1)
Dropping, Adding, or Modifying a Column in a Table
305(3)
Truncating and Dropping a Table
308(1)
Querying Table-Related Data Dictionary Views
309(1)
Chapter Summary
310(2)
Review Questions
312(1)
Exam Review Questions---Database Fundamentals I (#1Z0-031)
313(3)
Hands-on Assignments
316(3)
Case Project
319(2)
Index Management
321(36)
Introduction to Indexes
322(23)
Types and Uses of Indexes
324(18)
Data Dictionary Information on Indexes
342(3)
Managing Indexes
345(3)
Monitoring Indexes and Dropping Indexes
345(1)
Reorganizing and Modifying Indexes
346(2)
Chapter Summary
348(1)
Review Questions
349(2)
Exam Review Questions---Database Fundamentals I (#1Z0-031)
351(3)
Hands-on Assignments
354(2)
Case Project
356(1)
Data Integrity Constraints
357(32)
Introduction to Constraints
358(2)
Types of Integrity Constraints
358(2)
How To Create and Maintain Integrity Constraints
360(7)
Creating Constraints Using the CREATE TABLE Command
361(4)
Creating or Changing Constraints Using the ALTER TABLE Command
365(2)
Practical Examples of Working with Constraints
367(13)
Adding or Removing a NOT NULL Constraint
367(2)
Adding and Modifying a PRIMARY KEY Constraint
369(2)
Adding and Modifying a UNIQUE Key Constraint
371(3)
Working with a FOREIGN KEY Constraint
374(4)
Creating and Changing a CHECK Constraint
378(2)
Data Dictionary Information on Constraints
380(1)
Chapter Summary
381(2)
Review Questions
383(1)
Exam Review Questions---Database Fundamentals I (#1Z0-031)
383(3)
Hands-on Assignments
386(2)
Case Project
388(1)
Users and Resource Control
389(40)
Overview of Database Users
390(9)
Creating New Users
390(5)
Modifying User Settings with the ALTER USER Statement
395(3)
Removing Users
398(1)
Introduction to Profiles
399(12)
Creating Profiles
400(2)
Managing Passwords
402(6)
Controlling Resource Usage
408(3)
Dropping a Profile
411(1)
Obtaining Profil Password, and Resource Data
411(7)
Chapter Summary
418(1)
Review Questions
419(2)
Exam Review Questions---Database Fundamentals I (#1Z0-031)
421(4)
Hands-on Assignments
425(2)
Case Project
427(2)
System and Object Privileges
429(34)
Overview of Privileges
430(3)
Identifying System Privileges
430(2)
Using Object Privileges
432(1)
Managing System and Object Privileges
433(12)
Granting and Revoking System Privileges
433(6)
Granting and Revoking Object Privileges
439(6)
Description of Auditing Capabilities
445(8)
Chapter Summary
453(1)
Review Questions
454(2)
Exam Review Questions---Database Fundamentals I (#1Z0-031)
456(2)
Hands-on Assignments
458(3)
Case Project
461(2)
Database Roles
463(30)
Introduction to Roles
464(4)
How to Use Roles
464(1)
Using Predefined Roles
465(3)
Creating and Modifying Roles
468(9)
Creating and Assigning Privileges to a Role
469(1)
Assigning Roles to Users and to Other Roles
469(4)
Limiting Availability and Removing Roles
473(4)
Data Dictionary Information about Roles
477(1)
Roles in the Enterprise Manager Console
477(8)
Chapter Summary
485(1)
Review Questions
486(1)
Exam Review Questions---Database Fundamentals I (#1Z0-031)
487(3)
Hands-on Assignments
490(2)
Case Project
492(1)
Globalization Support in the Database
493(24)
Introduction to Globalization Support
494(2)
Language-dependent Behavior in the Database
494(1)
How Language-dependent Settings Affect Applications
495(1)
Using NLS Parameters and Variables
496(13)
Adjusting Globalization Initialization Parameters
498(11)
Viewing NLS Parameters in Data Dictionary Views
509(1)
Chapter Summary
510(1)
Review Questions
511(1)
Exam Review Questions---Database Fundamentals I (#1Z0-031)
512(3)
Hands-on Assignments
515(1)
Case Project
516(1)
Glossary 517(12)
Index 529

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