Table of Contents

•	Table of Contents
•	Index
•	Examples

Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031)
By April Wells
Publisher	: Que
Pub Date	: December 03, 2004
ISBN	: 0-7897-3265-3
Pages	: 544

		Copyright
		Oracle 9i Cram Sheet
			THE ITERATIVE SYSTEM DEVELOPMENT CYCLE
			BASIC TERMINOLOGY
			THE SELECT STATEMENT
			JOINING TABLES
			SPECIALIZED QUERIES
			OPERATORS
			CONDITIONS
			PSEUDOCOLUMNS
			EXPRESSIONS
			FUNCTIONS
			CHANGING DATA (DML)
		A Note from Series Editor Ed Tittel
		About the Author
		About the Technical Editors
		Acknowledgements
		We Want to Hear from You!
		Introduction
			How to Prepare for an Exam
			Exam Format
			Testing Situation
			Using the Book
		Self-Assessment
			In the Real World
			The Ideal Candidate
			Put Yourself to the Test
			Assessing Your Readiness for the Exam
			Onward Through the Fog
		Chapter 1.  Oracle Architecture Components
			Database Versus Instance
			Datafiles
			Memory Structures
			Shared SQL Area
			Program Global Areas (PGA) Overview
			Process Architecture
			Background Processes
			Connecting to an Instance
			Exam Prep Questions
			Need to Know More?
		Chapter 2.  Getting Started with the Oracle Server
			Administrative Tools
			Oracle Universal Installer (OUI)
			Oracle Database Configuration Assistant (DBCA)
			Optimal Flexible Architecture (OFA)
			Password File Authentication
			DBA Tools
			Exam Prep Questions
		Chapter 3.  Creating a Database
			Prerequisites for Database Creation
			Planning Database File Locations
			Creating the Database
			Oracle Database Configuration Assistant
			Create a Database Manually
			What to Do If Database Creation Fails
			Exam Prep Questions
			Need to Know More?
		Chapter 4.  Managing an Instance
			Initialization Parameter Files
			Oracle Managed File (OMF) System
			Database Startup
			Working with the STARTUP Command
			Shutting Down the Database
			Managing the Instance by Monitoring the Diagnostic Files
			Exam Prep Questions
			Need to Know More?
		Chapter 5.  Data Dictionary Content and Usage
			Oracle's Data Dictionary
			How the Data Dictionary Is Used
			Accessing Data Dictionary and Dynamic Performance Views
			Creating the Data Dictionary
			Common Views and Their Uses
			Exam Prep Questions
			Need to Know More?
		Chapter 6.  Storage Structure and Relationships
			Segments
			Extents
			Database Data Blocks
			Block Utilization Parameter
			Storage Structure Information in the Data Dictionary
			Exam Prep Questions
			Need to Know More?
		Chapter 7.  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
		Chapter 8.  Maintaining Control Files
			What Are Control Files?
			Multiplexing Control Files
			The CREATE CONTROLFILE Command
			Dropping Control Files
			Backing Up the Control File
			Obtaining Control File Information
			Control File-Related Parameters
			Managing the Control File with OMF
			Exam Prep Questions
		Chapter 9.  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
		Chapter 10.  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?
		Chapter 11.  Managing Undo Data
			Logical Structure of Undo Segments in the Database
			Purpose of Undo Data
			Types of Undo Data
			Implementing Automatic Undo Management
			Data Dictionary Information on Undo
			Exam Prep Questions
		Chapter 12.  Managing Tables
			Methods of Storing Data
			Oracle Data Types
			Structure of a Row
			Creating Regular and Temporary Tables
			External Tables
			Managing Storage Structures
			Regular Table Operations
			Column Operations
			Data Dictionary Information on Tables
			Exam Prep Questions
		Chapter 13.  Managing Indexes
			Different Types of Indexes and Their Uses
			Creating Indexes
			Changing Storage Parameters for Indexes
			Reorganizing Indexes
			Index Information in the Data Dictionary
			Exam Prep Questions
		Chapter 14.  Maintaining Data Integrity
			Defining Data Integrity
			Implementing Data Integrity Constraints
			Maintaining Integrity Constraints
			Constraint Information in the Data Dictionary
			Exam Prep Questions
		Chapter 15.  Managing Users
			Creating New Users
			Altering Users
			Dropping Users
			User Information in the Data Dictionary
			Exam Prep Questions
		Chapter 16.  Managing Password Security and Resources
			Manage Passwords Using Profiles
			Administering Profiles
			Controlling Resources Using Profiles
			Managing Resource Plans and Consumer Groups
			Data Dictionary Information About Profiles, Password Management, and Resources
			Exam Prep Questions
		Chapter 17.  Managing Privileges
			System Privileges
			Object Privileges
			Auditing Capabilities
			Data Dictionary Information
			Exam Prep Questions
		Chapter 18.  Managing Roles
			Creating and Modifying Roles
			Granting Roles
			Controlling Availability of Roles
			Removing Roles
			Using Predefined Roles
			Role Creation Guidelines
			Role Information in the Data Dictionary
			Exam Prep Questions
		Chapter 19.  Practice Exam 1
		Chapter 20.  Exam 1 Answers
		Chapter 21.  Practice Exam 2
		Chapter 22.  Exam 2 Answers
		Appendix A.  CD Contents and Installation Instructions
			Multiple Test Modes
			Question Types
			Random Questions and Order of Answers
			Detailed Explanations of Correct and Incorrect Answers
			Attention to Exam Objectives
			Installing the CD
			Technical Support
		Glossary
		Appendix C.  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