Oracle 9i Fundamentals I Exam Cram 2 (Exam 1Z0-031)

   
book cover
  
• 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
   


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.


   
book cover
  
• 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