You are previewing OCA: Oracle 10g™ Administration I: Study Guide.
O'Reilly logo
OCA: Oracle 10g™ Administration I: Study Guide

Book Description

Here's the book you need to prepare for the Oracle Database 10g Administration I exam, 1Z0-042. This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the "Best Study Guide" selection in CertCities Readers Choice Awards for two consecutive years, this book provides:

  • Clear and concise information on database administration with Oracle 10g

  • Practical examples and insights drawn from the authors' real-world experiences

  • Leading-edge exam preparation software, including a test engine and electronic flashcards

You'll also find authoritative coverage of key exam topics, including:

  • Installing Oracle Database 10g Software

  • Creating and Controlling Oracle Databases

  • Administering Users

  • Managing Schema Objects and Data

  • Implementing Oracle Security Features

  • Monitoring Performance

  • Performing Database Backup and Recovery

Look to Sybex for the knowledge and skills needed to succeed in today's competitive IT marketplace

Table of Contents

  1. Copyright
  2. To Our Valued Readers:
  3. Software License Agreement: Terms and Conditions
  4. Dedication
  5. Acknowledgments
  6. Introduction
  7. Oracle Database 10g Components and Architecture
    1. The Oracle Product Family
    2. Relational Database Concepts
    3. The Oracle Architecture
    4. Installing Oracle 10g
    5. Summary
    6. Exam Essentials
    7. Review Questions
    8. Answers to Review Questions
  8. Creating and Controlling a Database
    1. The Oracle Enterprise Management Framework
    2. Using the Oracle Database Configuration Assistant
    3. Managing Parameter Initialization Files
    4. Starting Up and Shutting Down an Oracle Database
    5. Summary
    6. Exam Essentials
    7. Review Questions
    8. Answers to Review Questions
  9. Database Storage and Schema Objects
    1. Identifying Segments, Extents, and Data Blocks
    2. Managing Tablespaces
    3. Managing Datafiles
    4. Working with Schema Objects
    5. Summary
    6. Exam Essentials
    7. Review Questions
    8. Answers to Review Questions
  10. Oracle Net Services
    1. Network Design Considerations
    2. Network Configurations
    3. An Overview of Oracle Net Features
    4. Configuring Oracle Net on the Server
    5. Configuring Oracle Net for the Client
    6. Summary
    7. Exam Essentials
    8. Review Questions
    9. Answers to Review Questions
  11. Oracle Shared Server
    1. An Overview of Oracle Shared Server
    2. Oracle Shared Server Infrastructure
    3. Configuring the Oracle Shared Server
    4. Managing Shared Server
    5. Tuning the Shared Server Option
    6. Summary
    7. Exam Essentials
    8. Review Questions
    9. Answers to Review Questions
  12. User Administration and Security
    1. Creating and Managing User Accounts
    2. Granting and Revoking Privileges
    3. Controlling Resource Usage by Users
    4. Applying the Principle of Least Privilege
    5. Managing Default User Accounts
    6. Implementing Standard Password Security Features
    7. Auditing Database Activity
    8. Summary
    9. Exam Essentials
    10. Review Questions
    11. Answers to Review Questions
  13. Managing Data With SQL, PL/SQL, and Utilities
    1. Manipulating Data through SQL
    2. Identifying PL/SQL Objects
    3. Configuring PL/SQL for Better Performance
    4. Creating Directory Objects
    5. Data Pump Overview
    6. Loading Data with SQL*Loader
    7. Summary
    8. Exam Essentials
    9. Review Questions
    10. Answers to Review Questions
  14. Managing Consistency and Concurrency
    1. Leveraging Undo Management
    2. Monitoring Locking and Resolving Lock Conflicts
    3. Summary
    4. Exam Essentials
    5. Review Questions
    6. Answers to Review Questions
  15. Proactive Database Maintenance and Performance Monitoring
    1. Proactive Database Maintenance
    2. Performance Monitoring
    3. Summary
    4. Exam Essentials
    5. Review Questions
    6. Answers to Review Questions
  16. Implementing Database Backups
    1. Understanding and Configuring Recovery Components
    2. Performing Backups
    3. Managing Backups
    4. Summary
    5. Exam Essentials
    6. Review Questions
    7. Answers to Review Questions
  17. Implementing Database Recovery
    1. Understanding Database Failure Types
    2. Performing Recovery Operations
    3. Summary
    4. Exam Essentials
    5. Review Questions
    6. Answers to Review Questions
  18. Glossary
    1. A
    2. B
    3. C
    4. D
    5. E
    6. F
    7. G
    8. H
    9. I
    10. J
    11. L
    12. M
    13. N
    14. O
    15. P
    16. Q
    17. R
    18. S
    19. T
    20. U
    21. V
    22. W