ORACLE CERTIFIED DBA EXAM QUESTION AND ANSWER BOOK
Ouvrage 9780130142719 : 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!
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!
Sima Yazdani (Javanbakht) is Senior IT Engineer
at San Jose,
CA-based Cisco Systems, which has one of the most
advanced data
warehouses in the industry. Her responsibilities
include analysis and
architecture of data warehouse, metadata, and
Internet applications.
She has worked with Oracle database technologies
as a developer,
DBA, and application architect since 1985. Sima
also contributes to the
Database Systems and Concepts certificate program
at the University
of California at Santa Cruz, developing the
academic curriculum and
teaching Oracle technology-related courses.
Shirley Wong is Senior IT Project Manager at
Cisco Systems, with
responsibilities that include the managing and
rollout of Cisco's
enterprise-wide Data Warehouse decision support
applications.
Previously, Shirley was Vice President and
Director at the Bank of
America's Systems Engineering Division, where she
oversaw the
bank's statewide retail automation systems. She
and Sima are
co-authors of a DBA handbook on data warehousing.
Tao-Sang Tong worked for the Oracle Corporation
for over five years.
At Oracle, he held several engineering positions
on porting Oracle
Server and Oracle Applications to different
operating systems. He
holds a BS degree in Computer Engineering from
the University of
Michigan, Ann Arbor and an MS degree in
Electrical Engineering from
Stanford University.
Table of Contents
Preface.
About the Authors.
I. Introduction.
1. Introduction to Oracle Database.
Relational Database Management System. Oracle
Database. Data Access with Oracle Server.
Distributed Processing with Oracle Server.
Answers to the Questions in Part One.
II. UNDERSTANDING ORACLE8 ARCHITECTURE AND
INSTANCE.
2. Architectural Components.
Connecting to Oracle8. Oracle8 Server. Oracle8
Instance. Oracle8 Database. Processing SQL
Commands.
3. User Administration Tools.
Server Manager. SQL* Plus. SQL* Loader.
Export/Import Utility. Password File Utility.
4. Managing an Oracle8 Instance.
Setting Up Authentication. Initialization of
Parameter File. Starting a Database. Shutting Down a
Database. Managing Sessions. Alert and Trace
Files.
5. Creating a Database.
Logical Considerations. Preparing Operating
System Elements. Preparing the Parameter File.
Preparing the Password File. Creating the
Database.
6. Data Dictionary Views.
Constructing Data Dictionary Views. Using Data
Dictionary Views. Administrative Scripts.
Oracle8 Supplied Packages.
Answers to the Questions in Part Two.
III. UNDERSTANDING ORACLE8 DATABASE FILES.
7. Managing Control Files.
Uses of the Control File. Multiplexing the
Control File. Obtaining the Control File Information.
8. Redo Log Files.
Uses of the Redo Log File. Archiving the Log
Files. Redo Buffer, Log Switches, Checkpoints, and
SCN. Obtaining the Redo and Archive Log
Information. Multiplexing the Log Files.
9. Tablespaces.
Types of Tablespaces. Creating Tablespaces.
Managing Tablespace Allocation. Altering
Tablespace Availability. Dropping Tablespaces.
Obtaining Tablespace Information.
10. Managing Datafiles.
Creating Datafiles. Altering Datafile
Availability. Renaming and Relocating Datafiles. Obtaining
and Verifying the Datafile Information.
11. Storage Structure.
Database Storage Hierarchy. Types of Segments.
Understanding the Database Block. Oracle
Data Types. Block Space Utilization Parameters.
Deallocating Space. Obtaining the Storage
Structure Information.
Answers to the Questions in Part Three.
IV. UNDERSTANDING DATABASE OBJECTS AND THEIR
INTEGRITY CONSTRAINTS.
12. Managing Rollback Segments.
Transactions and Rollback Segments. Types of
Rollback Segments. Creating Rollback
Segments. Altering the Rollback Segments'
Availability. Dropping Rollback Segments. Obtaining
the Rollback Segment Information.
13. Managing Temporary Segments.
When and How Temporary Segments Are Allocated.
Types of Temporary Segments. Guidelines
for Temporary Segments. Obtaining Temporary
Segment Information.
14. Managing Tables.
Distinguishing Different Structures of Storing
Data. Creating Tables. Guidelines for Storage
Settings. Controlling the Space Used by Tables.
Validating Table Structure. Partitioned Tables.
Obtaining Information About Tables.
15. Managing Indexes.
Different Types of Indexes and Their Uses.
Comparing B*Tree and Bitmap Indexes. Creating
Indexes. Reorganizing Indexes. Dropping Indexes.
16. Managing Views, Sequences, and Synonyms.
Creating, Altering, and Dropping Views.
Creating, Altering, and Dropping Sequences. Creating
and Dropping Synonyms.
17. Managing Triggers and Integrity Constraints.
Types of Triggers and Integrity Constraints.
Creating Triggers and Integrity Constraints. Managing
Triggers and Integrity Constraints. Obtaining
Constraint and Trigger Information.
Answers to the Questions in Part Four.
V. MANAGING DATABASE RESOURCES.
18. Managing Clusters and Index-Organized Tables.
Creating and Maintaining Clusters. Creating and
Maintaining Index-Organized Tables (IOTs).
Obtaining Information About Clusters and IOTs.
19. Managing Users.
Session and User Licensing. Create Users. Alter
and Drop Existing Users. Obtaining Information
About Existing Users.
20. Managing Profiles.
Creating User Profiles. Controlling the Use of
Resources with Profiles. Altering and Dropping
Profiles. Obtaining Information About Profiles.
21. Managing Privileges.
Identifying System and Object Privileges.
Granting and Revoking Privileges. Obtaining Information
About Privileges.
22. Managing Roles.
Creating and Modifying Roles. Altering the
Availability of Roles. Using Predefined Roles.
Obtaining Information About Roles.
Answers to the Questions in Part Five.
VI. ORACLE8 ADVANCED TOPICS AND ORACLE8I NEW
FEATURES.
23. Auditing.
Guidelines for Auditing. Managing Auditing.
Database and Value-Based Auditing. Obtaining
Information About Auditing.
24. Using National Language Support.
NLS Features. Types of Encoding Schemes. Using
Different Types of NLS Parameters.
Specifying Language-Dependent Behavior.
Obtaining Information About NLS Usage.
25. Oracle8i Features.
Java in the Database. Memory Management.
Indexes. Index-Organized Tables. New
Object-Relational Features. LOB Enhancements.
Composite Partitioning. Tablespace
Enhancements. Constraint Enhancements. Database
Security. PKI-Based User Authentication.
Answers to the Questions in Part Six.
Index.
Auteur : YAZDANI
Editeur : PRENTICE HALL
Nombre de pages : 448
Date de publication : 08 2002
Toute la sélection
Toutes les sélections
Toute la sélection
Site réalisé en partenariat avec Courbis
(Courbis - alternate link), acteur de l'Internet depuis 1988...
Le Monde En Tique