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
- Copyright
- Oracle 9i Cram Sheet
- A Note from Series Editor Ed Tittel
- About the Author
- About the Technical Editors
- Acknowledgements
- We Want to Hear from You!
- Introduction
- Self-Assessment
- Oracle Architecture Components
- Getting Started with the Oracle Server
- Creating a Database
- Managing an Instance
- Data Dictionary Content and Usage
- Storage Structure and Relationships
-
Globalization Support
- Globalization Support
- Character Sets and Encoding Schemes
- Database Character Set
- National Character Set
- Language-Dependent Behavior Specification
- Setting Environment Variables
- Linguistic Sorting
- Language-Dependent Application Behavior
- Globalization Support Information in the Data Dictionary
- Globalization Support Utilities
- Exam Prep Questions
- Maintaining Control Files
-
Maintaining Redo Log Files
- Purpose of Online Redo Log Files
- Structure of Online Redo Log Files
- Control Log Switches and Checkpoints
- Multiplexing and Maintaining Online Redo Log Files
- Using OEM to Maintain Redo Log Groups and Members
- Managing Redo Log Files with OMF
- Data Dictionary Redo Information
- Archived Redo Log Files
- Exam Prep Questions
-
Managing Tablespaces and Data Files
- Logical Structure of the Database
- Types of Tablespaces
- Creating Tablespaces
- Dropping Tablespaces
- Space Management in Tablespaces
- Changing the Size of the Tablespace
- Manipulating Tablespaces and Data Files with OEM
- Implementing Oracle Managed Files (OMF)
- Data Dictionary Tablespace and Data File Information
- Exam Prep Questions
- Need to Know More?
- Managing Undo Data
- Managing Tables
- Managing Indexes
- Maintaining Data Integrity
- Managing Users
- Managing Password Security and Resources
- Managing Privileges
- Managing Roles
- Practice Exam 1
- Exam 1 Answers
- Practice Exam 2
- Exam 2 Answers
- CD Contents and Installation Instructions
- Glossary
-
Need to Know More?
- Chapter 1: Oracle Architectural Components
- Chapter 2: Getting Started with the Oracle Server
- Chapter 3: Creating a Database
- Chapter 4: Managing an Instance
- Chapter 5: Data Dictionary Content and Usage
- Chapter 6: Storage Structure and Relationships
- Chapter 7: Globalization Support
- Chapter 8: Maintaining Control Files
- Chapter 9: Maintaining Redo Log Files
- Chapter 10: Managing Tablespaces and Data Files
- Chapter 11: Managing Undo Data
- Chapter 12: Managing Tables
- Chapter 13: Managing Indexes
- Chapter 14: Maintaining Data Integrity
- Chapter 15: Managing Users
- Chapter 16: Managing Password Security and Resources
- Chapter 17: Managing Privileges
- Chapter 18: Managing Roles
- Index
Product information
- Title: Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031)
- Author(s):
- Release date: December 2004
- Publisher(s): Pearson IT Certification
- ISBN: 9780789732651
You might also like
book
OCP Oracle Database 11g New Features for Administrators Exam Guide (Exam 1Z0-050)
A Fully Integrated Study System for OCP Exam 1Z0-050 Prepare for the Oracle Certified Professional Oracle …
book
OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043
Here's the book you need to prepare for the Oracle Database 10g Administration II exam, 1Z0-043. …
book
OCA/OCP Oracle Database 11g All-in-One Exam Guide
A Fully Integrated Study System for OCA Exams 1Z0-051 and 1Z0-052, and OCP Exam 1Z0-053 Prepare …
book
Hands-On Oracle Database 10g Express Edition for Windows
The fastest way to get up and running on Oracle Database XE Take full advantage of …