Title:
OCP Oracle DBA training guide
Personal Author:
Publication Information:
[Indianpolis, Ind.?] : New Riders, c1999
Physical Description:
1 CD-ROM ; 12 cm.
ISBN:
9781562058913
General Note:
Accompanies text of the same title : QA76.3 B354 1999
Title Subject:
Available:*
Library | Item Barcode | Call Number | Material Type | Item Category 1 | Status |
|---|---|---|---|---|---|
Searching... | 30000010310081 | CP 030891 | Computer File Accompanies Open Access Book | Compact Disc Accompanies Open Access Book | Searching... |
On Order
Summary
Summary
This next-generation Training Guide has been developed to help you study and retain the essential knowledge you need to pass the Oracle DBA exams. We know your study time is valuable, and we have made every effort to make the most of it by presenting clear, accurate, and thorough information.
Table of Contents
| Introduction |
| Who Should Read This Book |
| How This Book Helps You |
| Understanding What the OCP Database Administration Track Covers |
| Hardware and Software Needed |
| Tips for the Exam |
| New Riders Publishing |
| I Sql And Pl/Sql |
| 1 Introduction to SQL |
| Introduction |
| Tables and Columns |
| SQL Grammar |
| The INSERT Statement |
| The UPDATE Statement |
| The DELETE Statement |
| Working with Dates |
| The Oracle Optimizer |
| 2 PL/SQL Language Structure |
| Introduction |
| Reserved Words |
| Modular Top-Down Design Syntax |
| Identifiers and Variable Declarations |
| Executable Statements |
| More on Exception Handling |
| SQL Within PL/SQL |
| Conditional Statements |
| Unconditional Statements |
| Iterative Statements |
| Getting Output |
| 3 PL/SQL in Use |
| Introduction |
| Subprograms, Procedures, and Functions |
| Stored Subprograms |
| Packages |
| 4 Security |
| Introduction |
| Users |
| Roles |
| Privileges |
| System Resource Limits |
| Real-World Problems |
| Database Administrator (DBA) Authentication |
| Auditing Database Activity |
| II Oracle Database Administration |
| 5 Oracle Database Architecture |
| Introduction |
| Memory Structures |
| Oracle Background Processes |
| Characteristics of an Oracle Instance |
| Oracle's External Files |
| Transaction Processing |
| Creating a Database |
| Multithreaded Server (MTS) |
| 6 Managing Database Structures |
| Introduction |
| Oracle Structure Fundamentals |
| Managing Database Structures |
| Working with Tablespace Reports |
| Managing Storage Allocation |
| Managing Table and Index Segments |
| Working with Database Indexes |
| Managing Cluster Segments |
| Managing Constraints |
| Managing Rollback Segments |
| 7 Utilities |
| Introduction |
| What You Can Do with SQL*Loader |
| Using Oracle's Export Utility |
| Recovering from a Logical Backup with Oracle's Import Utility |
| III Backup And Recovery |
| 8 Backing Up a Database |
| Introduction |
| Why Back Up a Database? |
| Backing Up to Another Device |
| 9 Database Recovery |
| Introduction |
| Some Common Errors and Failures |
| Explanations of Structures |
| Data Files |
| Control Files |
| Redo Logs |
| Key Recovery Principles |
| Checkpoints |
| Database Recovery Options |
| III Tuning |
| 10 Database Tuning |
| Introduction |
| Optimal Configuration |
| Reducing Contentions |
| Disk (I/O) Contention |
| Database Design |
| Application Performance Design and Database Objects |
| 11 Tuning Memory Structures |
| Introduction |
| Tuning Applications |
| Tuning the Shared Pool |
| Tuning the Buffer Cache |
| Tuning Redo Logs |
| Tuning Rollback Segments |
| Tuning Sorts |
| Monitoring Databases |
| Appendixes |
| Appendix A Glossary |
| Appendix B Overview of the Certification Process |
| Appendix C Study Tips |
| Pretesting Yourself |
| Hints and Tips for Doing Your Best on the Tests |
| Appendix D What's on the CD-ROM |
| Top Score |
| Copyright Information and Disclaimer |
| Appendix E All About Top Score |
| Scoring |
| Index |
