Oracle 8i DBA : Architecture and Administration Certification Bible

by Bersinic, Damir; Ross, Todd; Sabinin, Yury

• ISBN13: 9780764548178
• ISBN10: 0764548174
• Edition: 1st
• Format: Paperback
• Copyright: 2001-12-29
• Publisher: Wiley

Summary

This book delivers comprehensive coverage of exam objectives, presented according to Oracle's certification guide. Because Oracle's exam scoring provides section scores according to exact objectives, this organization of the book allows you to refocus. Each exam objective is covered in a chapter complete with self-assessment opportunities. Four appendices include a listing and description of Oracle's initialization parameters and other elements to be tested on the exam. These appendices provide information useful post-exam in real-work implementation of Oracle Systems.

Author Biography

<b>Damir Bersinic</b>, MCDBA Oracle DBA, Oracle Trainer, MCSE+I, MCT, has worked with Oracle databases since 1989 and has taught Oracle Official Curriculum courses for the last four years. He is the founder and president of Bradley Systems, Inc., a firm specializing in database, Internet, and system integration consulting and training. <p> <b>Todd Ross</b> is a Senior Oracle and UNIX instructor, as well as the Corporate Oracle Stream Leader, for TMI-Learnix Ltd. <p> gt;Yury Sabinin</b> is an Oracle Certified Professional (DBA) who is currently a full-time trainer with TMI-Learnix Ltd., and a consultant.

Table of Contents

Preface.

Acknowledgments.

Part I: Overview of Oracle Architecture and Administration.

Chapter 1 : Oracle8i Architecture.

Chapter 2 : Getting Started with Oracle8i Server.

Part II: Creating and Administering an Oracle Instance and Database.

Chapter 3 : Managing an Oracle Instance.

Chapter 4 : Creating a Database.

Chapter 5 : Creating Data Dictionary Views and Standard Packages.

Chapter 6 : Maintaining the Control File.

Chapter 7 : Maintaining Redo Log Files.

Chapter 8 : Managing Tablespaces and Datafiles.

Part III: Administering Storage for Oracle Objects.

Chapter 9: Storage Structure and Relationships.

Chapter 10 : Managing Rollback Segments.

Chapter 11: Managing Tables.

Chapter 12 : Managing Indexes.

Chapter 13 : Maintaining Data Integrity.

Part IV: Managing Oracle Data.

Chapter 14 : Loading Data.

Chapter 15 : Reorganizing Data.

Part V: Managing Oracle Security.

Chapter 16 : Managing Password Security and Resources.

Chapter 17 : Managing Users.

Chapter 18 : Managing Privileges.

Chapter 19 : Managing Roles.

Part VI: National Language Support.

Chapter 20 : Using National Language Support.

Appendix A: What's on the CD-ROM.

Appendix B: Practice Exam.

Appendix C: Objective Mapping.

Appendix D: Exam Tips.

Appendix E: Database Schema for Labs.

Appendix F: Suggested Readings, Web Sites, and Other Resources.

Index.

End-User License Agreement.