You are previewing Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031).
O'Reilly logo
Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031)

Book Description

Whether you're studying for the Oracle 9i Fundamentals I exam or just need to take the New Features update exam, Oracle 9i Funamentals I Exam Cram 2 can help you get certified. This efficient guide follows the exam objectives clearly and concisely. New Features materials are also included in the book, as well as a full-customizable practice test engine on CD. Oracle 9i Fundamentals I Exam Cram 2 is your smartest way to get certified.

Table of Contents

  1. Copyright
  2. Oracle 9i Cram Sheet
  3. A Note from Series Editor Ed Tittel
  4. About the Author
  5. About the Technical Editors
  6. Acknowledgements
  7. We Want to Hear from You!
  8. Introduction
  9. Self-Assessment
  10. Oracle Architecture Components
    1. Database Versus Instance
    2. Datafiles
    3. Memory Structures
    4. Shared SQL Area
    5. Program Global Areas (PGA) Overview
    6. Process Architecture
    7. Background Processes
    8. Connecting to an Instance
    9. Exam Prep Questions
    10. Need to Know More?
  11. Getting Started with the Oracle Server
    1. Administrative Tools
    2. Oracle Universal Installer (OUI)
    3. Oracle Database Configuration Assistant (DBCA)
    4. Optimal Flexible Architecture (OFA)
    5. Password File Authentication
    6. DBA Tools
    7. Exam Prep Questions
  12. Creating a Database
    1. Prerequisites for Database Creation
    2. Planning Database File Locations
    3. Creating the Database
    4. Oracle Database Configuration Assistant
    5. Create a Database Manually
    6. What to Do If Database Creation Fails
    7. Exam Prep Questions
    8. Need to Know More?
  13. Managing an Instance
    1. Initialization Parameter Files
    2. Oracle Managed File (OMF) System
    3. Database Startup
    4. Working with the STARTUP Command
    5. Shutting Down the Database
    6. Managing the Instance by Monitoring the Diagnostic Files
    7. Exam Prep Questions
    8. Need to Know More?
  14. Data Dictionary Content and Usage
    1. Oracle's Data Dictionary
    2. How the Data Dictionary Is Used
    3. Accessing Data Dictionary and Dynamic Performance Views
    4. Creating the Data Dictionary
    5. Common Views and Their Uses
    6. Exam Prep Questions
    7. Need to Know More?
  15. Storage Structure and Relationships
    1. Segments
    2. Extents
    3. Database Data Blocks
    4. Block Utilization Parameter
    5. Storage Structure Information in the Data Dictionary
    6. Exam Prep Questions
    7. Need to Know More?
  16. Globalization Support
    1. Globalization Support
    2. Character Sets and Encoding Schemes
    3. Database Character Set
    4. National Character Set
    5. Language-Dependent Behavior Specification
    6. Setting Environment Variables
    7. Linguistic Sorting
    8. Language-Dependent Application Behavior
    9. Globalization Support Information in the Data Dictionary
    10. Globalization Support Utilities
    11. Exam Prep Questions
  17. Maintaining Control Files
    1. What Are Control Files?
    2. Multiplexing Control Files
    3. The CREATE CONTROLFILE Command
    4. Dropping Control Files
    5. Backing Up the Control File
    6. Obtaining Control File Information
    7. Control File-Related Parameters
    8. Managing the Control File with OMF
    9. Exam Prep Questions
  18. Maintaining Redo Log Files
    1. Purpose of Online Redo Log Files
    2. Structure of Online Redo Log Files
    3. Control Log Switches and Checkpoints
    4. Multiplexing and Maintaining Online Redo Log Files
    5. Using OEM to Maintain Redo Log Groups and Members
    6. Managing Redo Log Files with OMF
    7. Data Dictionary Redo Information
    8. Archived Redo Log Files
    9. Exam Prep Questions
  19. Managing Tablespaces and Data Files
    1. Logical Structure of the Database
    2. Types of Tablespaces
    3. Creating Tablespaces
    4. Dropping Tablespaces
    5. Space Management in Tablespaces
    6. Changing the Size of the Tablespace
    7. Manipulating Tablespaces and Data Files with OEM
    8. Implementing Oracle Managed Files (OMF)
    9. Data Dictionary Tablespace and Data File Information
    10. Exam Prep Questions
    11. Need to Know More?
  20. Managing Undo Data
    1. Logical Structure of Undo Segments in the Database
    2. Purpose of Undo Data
    3. Types of Undo Data
    4. Implementing Automatic Undo Management
    5. Data Dictionary Information on Undo
    6. Exam Prep Questions
  21. Managing Tables
    1. Methods of Storing Data
    2. Oracle Data Types
    3. Structure of a Row
    4. Creating Regular and Temporary Tables
    5. External Tables
    6. Managing Storage Structures
    7. Regular Table Operations
    8. Column Operations
    9. Data Dictionary Information on Tables
    10. Exam Prep Questions
  22. Managing Indexes
    1. Different Types of Indexes and Their Uses
    2. Creating Indexes
    3. Changing Storage Parameters for Indexes
    4. Reorganizing Indexes
    5. Index Information in the Data Dictionary
    6. Exam Prep Questions
  23. Maintaining Data Integrity
    1. Defining Data Integrity
    2. Implementing Data Integrity Constraints
    3. Maintaining Integrity Constraints
    4. Constraint Information in the Data Dictionary
    5. Exam Prep Questions
  24. Managing Users
    1. Creating New Users
    2. Altering Users
    3. Dropping Users
    4. User Information in the Data Dictionary
    5. Exam Prep Questions
  25. Managing Password Security and Resources
    1. Manage Passwords Using Profiles
    2. Administering Profiles
    3. Controlling Resources Using Profiles
    4. Managing Resource Plans and Consumer Groups
    5. Data Dictionary Information About Profiles, Password Management, and Resources
    6. Exam Prep Questions
  26. Managing Privileges
    1. System Privileges
    2. Object Privileges
    3. Auditing Capabilities
    4. Data Dictionary Information
    5. Exam Prep Questions
  27. Managing Roles
    1. Creating and Modifying Roles
    2. Granting Roles
    3. Controlling Availability of Roles
    4. Removing Roles
    5. Using Predefined Roles
    6. Role Creation Guidelines
    7. Role Information in the Data Dictionary
    8. Exam Prep Questions
  28. Practice Exam 1
  29. Exam 1 Answers
  30. Practice Exam 2
  31. Exam 2 Answers
  32. CD Contents and Installation Instructions
    1. Multiple Test Modes
    2. Question Types
    3. Random Questions and Order of Answers
    4. Detailed Explanations of Correct and Incorrect Answers
    5. Attention to Exam Objectives
    6. Installing the CD
    7. Technical Support
  33. Glossary
  34. Need to Know More?
    1. Chapter 1: Oracle Architectural Components
    2. Chapter 2: Getting Started with the Oracle Server
    3. Chapter 3: Creating a Database
    4. Chapter 4: Managing an Instance
    5. Chapter 5: Data Dictionary Content and Usage
    6. Chapter 6: Storage Structure and Relationships
    7. Chapter 7: Globalization Support
    8. Chapter 8: Maintaining Control Files
    9. Chapter 9: Maintaining Redo Log Files
    10. Chapter 10: Managing Tablespaces and Data Files
    11. Chapter 11: Managing Undo Data
    12. Chapter 12: Managing Tables
    13. Chapter 13: Managing Indexes
    14. Chapter 14: Maintaining Data Integrity
    15. Chapter 15: Managing Users
    16. Chapter 16: Managing Password Security and Resources
    17. Chapter 17: Managing Privileges
    18. Chapter 18: Managing Roles
  35. Index