Oracle Certified DBA Exam: Question and Answer Book

Oracle Certified DBA Exam: Question and Answer Book

ISBN-10:
0130142719
ISBN-13:
9780130142719
Pub. Date:
12/29/2000
Publisher:
Pearson Education

Paperback

Current price is , Original price is $39.99. You
Select a Purchase Option
  • purchase options

Overview

Oracle Certified DBA Exam: Question and Answer Book

  • Covers all required DBA tests
  • Includes Oracle8 and 8i upgrades
  • Contains practice tests, detailed answers, explanations, and references

Q&A-based preparation for your Oracle DBA certification: fast, concise, and effective!

You want to acquire Oracle DBA Certification, and you don't have a minute to waste! That's why you need the Oracle Certified DBA Exam: Question and Answer Book—built around four real practice exams covering every concept and technique Oracle expects you to master.

Take the tests—then review comprehensive answers, explanations, and references supplied by three of the world's leading Oracle database professionals. It's the fastest, most effective way to assess your skills, address your weaknesses, and get your credentials!

Coverage includes:

  • Oracle database system concepts and options, including Oracle architecture, instances, data dictionaries, database files, and security
  • Database backup, recovery, startup, and shutdown
  • SQL and PL/SQL, including data administration, modeling, physical database design, stored procedures, triggers, snapshots, and flow control
  • Database administration principles and practices: software installation, resource management, and performance tuning
  • Oracle8 and 8i upgrades and enhancements: object-relational features, data warehousing, Internet computing, and more

Practical and concise, there's no better resource for Oracle professionals who want to achieve—or upgrade—their DBA certification!

Product Details

ISBN-13: 9780130142719
Publisher: Pearson Education
Publication date: 12/29/2000
Series: Prentice Hall Ptr Oracle Series
Pages: 464
Product dimensions: 6.99(w) x 9.29(h) x 1.28(d)

Table of Contents

Preface xiii
Acknowledgments xiv
About the Authors xvi
Part One Introduction 1(58)
Introduction to Oracle Database
3(56)
Relational Database Management System
4(7)
Database Management System Requirements
4(3)
Database Applications and Tools
7(2)
Relational Data Model
9(1)
Database Administration (DBA) Responsibilities
10(1)
Oracle Database
11(5)
Database vs. Instance
11(1)
User Schema and Data Dictionary
12(2)
Applications, Logical, and Physical Views of a Database
14(2)
Data Access with Oracle Server
16(8)
Database Access Tools
16(1)
Structured Query Language (SQL)
17(2)
PL/SQL
19(1)
Transactions
20(2)
Read Consistency
22(1)
Locking Mechanism
23(1)
Distributed Processing with Oracle Server
24(35)
Client/Server Architecture
24(1)
Net8
25(1)
Multitier Architecture: Application Servers
26(1)
Oracle Distributed Databases
27(2)
Oracle Parallel Server (OPS)
29(2)
Answers to the Questions in Part One
31(28)
Part Two Understanding Oracle8 Architecture and Instance 59(100)
Architectural Components
61(16)
Connecting to Oracle8
62(1)
Oracle8 Server
63(1)
Oracle8 Instance
64(8)
Memory Structures
64(2)
SGA Resources
66(1)
CPU Resources
67(2)
Background Processes
69(3)
Oracle8 Database
72(2)
Processing SQL Commands
74(3)
Stages in Processing a Query, DML, Commit/Rollback
74(3)
User Administration Tools
77(6)
Server Manager
78(1)
SQL* Plus
78(1)
SQL* Loader
79(2)
Data Transportation and SQL*Loader
79(2)
Export/Import Utility
81(1)
Password File Utility
81(2)
Managing an Oracle8 Instance
83(10)
Setting Up Authentication
84(1)
Initialization of Parameter File
84(1)
Starting a Database
85(2)
Shutting Down a Database
87(1)
Managing Sessions
88(2)
Alert and Trace Files
90(3)
Creating a Database
93(6)
Logical Considerations
94(1)
Preparing Operating System Elements
94(1)
Preparing the Parameter File
95(1)
Preparing the Password File
96(1)
Creating the Database
96(3)
Data Dictionary Views
99(60)
Constructing Data Dictionary Views
101(2)
Using Data Dictionary Views
103(2)
Administrative Scripts
105(1)
Oracle8 Supplied Packages
106(53)
Answers to the Questions in Part Two
109(50)
Part Three Understanding Oracle8 Database Files 159(82)
Managing Control Files
161(6)
Uses of the Control File
162(1)
Multiplexing the Control File
163(1)
Obtaining the Control File Information
164(3)
Redo Log Files
167(14)
Uses of the Redo Log File
168(2)
Archiving the Log Files
170(3)
Redo Buffer, Log Switches, Checkpoints, and SCN
173(3)
Obtaining the Redo and Archive Log Information
176(2)
Multiplexing the Log Files
178(3)
Tablespaces
181(10)
Types of Tablespaces
182(3)
Creating Tablespaces
185(1)
Managing Tablespace Allocation
186(1)
Altering Tablespace Availability
187(1)
Dropping Tablespaces
188(1)
Obtaining Tablespace Information
189(2)
Managing Datafiles
191(6)
Creating Datafiles
192(1)
Altering Datafile Availability
193(1)
Renaming and Relocating Datafiles
194(1)
Obtaining and Verifying the Datafile Information
195(2)
Storage Structure
197(44)
Database Storage Hierarchy
198(1)
Types of Segments
199(1)
Understanding the Database Block
200(1)
Oracle Data Types
201(2)
Block Space Utilization Parameters
203(1)
Deallocating Space
203(1)
Obtaining the Storage Structure Information
204(37)
Answers to the Questions in Part Three
205(36)
Part Four Understanding Database Objects and Their Integrity Constraints 241(98)
Managing Rollback Segments
243(6)
Transactions and Rollback Segments
244(1)
Types of Rollback Segments
245(1)
Creating Rollback Segments
246(1)
Altering the Rollback Segments' Availability
247(1)
Dropping Rollback Segments
247(1)
Obtaining the Rollback Segment Information
247(2)
Managing Temporary Segments
249(8)
When and How Temporary Segments Are Allocated
250(2)
Types of Temporary Segments
252(1)
Guidelines for Temporary Segments
253(2)
Obtaining Temporary Segment Information
255(2)
Managing Tables
257(18)
Distinguishing Different Structures of Storing Data
258(3)
ROWID
258(1)
Collection Data Types
259(2)
Creating Tables
261(3)
Guidelines for Storage Settings
264(2)
Controlling the Space Used by Tables
266(2)
Validating Table Structure
268(1)
Partitioned Tables
269(3)
Obtaining Information About Tables
272(3)
Managing Indexes
275(6)
Different Types of Indexes and Their Uses
276(1)
Comparing B*Tree and Bitmap Indexes
277(1)
Creating Indexes
277(1)
Reorganizing Indexes
278(1)
Dropping Indexes
279(2)
Managing Views, Sequences, and Synonyms
281(8)
Creating, Altering, and Dropping Views
282(2)
Creating, Altering, and Dropping Sequences
284(3)
Creating and Dropping Synonyms
287(2)
Managing Triggers and Integrity Constraints
289(50)
Types of Triggers and Integrity Constraints
290(1)
Creating Triggers and Integrity Constraints
291(2)
Managing Triggers and Integrity Constraints
293(1)
Obtaining Constraint and Trigger Information
293(46)
Answers to the Questions in Part Four
295(44)
Part Five Managing Database Resources 339(50)
Managing Clusters and Index-Organized Tables
341(8)
Creating and Maintaining Clusters
342(2)
Creating and Maintaining Index-Organized Tables (IOTs)
344(2)
Obtaining Information About Clusters and IOTs
346(3)
Managing Users
349(6)
Session and User Licensing
350(1)
Create Users
351(1)
Alter and Drop Existing Users
351(1)
Obtaining Information About Existing Users
352(3)
Managing Profiles
355(4)
Creating User Profiles
356(1)
Controlling the Use of Resources with Profiles
357(1)
Altering and Dropping Profiles
357(1)
Obtaining Information About Profiles
358(1)
Managing Privileges
359(4)
Identifying System and Object Privileges
360(1)
Granting and Revoking Privileges
360(1)
Obtaining Information About Privileges
361(2)
Managing Roles
363(26)
Creating and Modifying Roles
364(1)
Altering the Availability of Roles
365(1)
Using Predefined Roles
365(1)
Obtaining Information About Roles
366(23)
Answers to the Questions in Part Five
367(22)
Part Six Oracle8 Advanced Topics and Oracle8i New Features 389(57)
Auditing
391(6)
Guidelines for Auditing
392(1)
Managing Auditing
393(1)
Database and Value-Based Auditing
394(1)
Obtaining Information About Auditing
394(3)
Using National Language Support
397(6)
NLS Features
398(1)
Types of Encoding Schemes
398(1)
Using Different Types of NLS Parameters
399(1)
Specifying Language-Dependent Behavior
400(1)
Obtaining Information About NLS Usage
401(2)
Oracle8i Features
403(43)
Java in the Database
404(1)
Memory Management
405(1)
Indexes
406(2)
Index-Organized Tables
408(1)
New Object-Relational Features
409(1)
LOB Enhancements
410(2)
Composite Partitioning
412(1)
Tablespace Enhancements
413(2)
Constraint Enhancements
415(1)
Database Security
416(1)
PKI--Based User Authentication
417(29)
Answers to the Questions in Part Six
419(27)
Index 446

Preface

Preface

Oracle DBA certification is within your reach. The Oracle Certified DBA Exam: Question and Answer Book can help! The book was built around real practice exams covering every concept and technique that Oracle expects you to master. The bookÕs organization closely follows the syllabus of the OCP exam. Practical and concise, there is no better resource for Oracle professionals who wish to achieve or upgrade their DBA certification.

The subject matter has been organized into 25 chapters within six major parts. Part One offers the reader an introduction to the Oracle database, thoroughly covering such topics as the relational database management system, the Oracle database, as well as data access and distributed processing with the Oracle server. Part Two presents the reader with an understanding of Oracle8 architecture and instance including such topics as Oracle8 architectural components, user administration tools, managing Oracle8 instance, creating a database, and data dictionary views. Part Three explores the various Oracle8 database files such as control files, redo log files, tablespaces, datafiles, and storage structure. Part Four presents the reader with an understanding of database objects and their integrity constraints including ways of managing rollback segments, temporary segments, tables, indexes, views, sequences, synonyms, triggers, and integrity constraints. Part Five discusses managing database resources including managing clusters and index-organized tables, users, profiles, privileges, and roles. Part Six covers Oracle8Õs more advanced topics such as auditing and National Language Support (LS) as well as someof Oracle8Õs new features.

We suggest taking the practice tests and then reviewing the comprehensive answers, explanations, and references. Review the chapters where you are weakest and then retake the test. This is the fastest, most effective way to access your skills, address your weaknesses, and get your credentials!

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews