www.usacyberworld.com
www.usacyberworld.com

Home| Income Tax| Web Design| PC Repair & Upgrade| Networking| Home Tutoring| Contact Us
Search:  usacyberworld.com
powered by FreeFind

COMPUTER TRAINING
Microsoft Office 2000/XP
CompTIA
Graphics & Web Design
E-Commerce
Tax & Accounting
Windows 2000/XP/MCSE
Cisco
Oracle DBA
Computer Programming


Looking for work? Visit HotJobs.com

Find Free Money For College!

Free Shipping


















































Oracle9i DBA Fundamentals I

Exam # 1Z0-031: Oracle9i DBA Fundamentals I

Oracle9i: DBA Fundamentals I (Exam #1Z0-031) is a core requirement for both the Oracle 9i OCA (Oracle Certified Associate) and OCP (Oracle Certified Professional) certifications. It is designed for intermediate to advanced level database personnel. In addition, we cover the following topics:

Chapter 1: Oracle9i Server Architecture
  • What is an Oracle Server?
  • Server Architectural Overview
  • Operating System Environment
  • Important Subdirectories in ORACLE_HOME
  • Oracle Product Subdirectories
  • Oracle Instance Components
  • Blocks, Extents, and Segments
  • Different Types of Segments
  • Different Versions of Oracle
  • Oracle9i Release 1- The eBusiness Database
  • Oracle9i - The Object Relational OLAP
  • Chapter 2: Database
  • Oracle Products and Architectures
  • Optimal Flexible Architecture
  • DBA Management Pack
  • Chapter 3: Oracle Memory Structures and Processes
  • Server Processes and the Buffer Cache
  • DBWR and the Buffer Cache
  • MTTR and Checkpoint Intervals
  • Determining When Checkpoints Occur
  • Minimal I/O Recovery
  • Defining the Database Buffer Pools
  • Chapter 4: Server Processes and Executing SQL
  • Program Global Areas
  • Dedicated Server Architecture
  • The Shared Server Architecture
  • Deprecated Parameters
  • Execution Plan Phase
  • Processing DML Statements
  • Rule-based and Cost-based Optimizers
  • Tuning Parallel Query
  • Parallel DML Restrictions
  • Chapter 5: Oracle Server
  • Database Utilities
  • The Server Manager Tool
  • Set and Show Commands
  • Oracle Universal Installer
  • Important Parameters for Database Creation
  • Starting an Oracle Server
  • The STARTUP command
  • SHUTDOWN Command Options
  • Alert and Trace Files
  • Working with Data Dictionary Views
  • Which Parameters are Dynamic versus Static
  • Chapter 6: Creating an Oracle Instance and Database
  • Steps for Creating a Database
  • Setup for Unix / Setup for NT
  • Removing Oracle Servers and Software
  • Optimal Flexible Architecture
  • OFA Directory Layouts
  • OFA Database Layouts
  • File Naming Conventions
  • The CREATE DATABASE Command
  • Troubleshooting Database Creation
  • Chapter 7: Managing Tablespaces and Data Files
  • CREATE TABLESPACE Command
  • Dictionary-Managed Space
  • Locally-Managed Tablespaces
  • Read-only Tablespaces
  • Viewing Active Transactions
  • Coalescing Dictionary-Managed Tablespaces
  • Using the ALTER TABLESPACE command
  • Adding More Space to a Database
  • DROP TABLESPACE Command
  • Converting Dictionary and Local Tablespaces
  • Chapter 8: Managing Tables
  • Creating Table Syntax
  • Create the SALE_TAB Table
  • Different Types of Tables
  • Storage Clause Options and Parameters
  • Removing Data From Tables
  • Modifying Column Definitions
  • Defining Columns to be Unused
  • Dropping Columns
  • Redefining a Table
  • Data Dictionary Views for Tables
  • Chapter 9: Managing Constraints
  • Different Types of Constraints
  • Column Constraints
  • Table Constraints
  • Viewing Constraint Information
  • Additional Constraint Features
  • Explicit Index Definition
  • USING INDEX Syntax
  • Dropping or Disabling Constraints and Indexes
  • Caching Primary Key Values
  • Chapter 10: Administration of Control Files
  • Working with Control Files
  • The CREATE CONTROLFILE Command
  • Writing to Redo Log Files
  • Log Sequence Numbers
  • Instance Recovery
  • Controlling DBWR Activity
  • Adding and Clearing Online Redo Log Files
  • Setting up Archiving
  • Managing Archive Destinations
  • Changing the ArchiveLog Mode
  • Data Dictionary Views for Redo Log Files
  • Chapter 11: Managing Users and Profiles
  • CREATE USER Command
  • Assigning Quotas to Users
  • Protecting the System Tablespace
  • Creating Profiles
  • Database Resource Limits
  • Security Guidelines
  • Chapter 12: Security Administration
  • Privileges and the User Group PUBLIC
  • Revoking System Privileges and Roles
  • Object Privileges
  • Database Authentication
  • Predefined Roles
  • Setting up a Role
  • Guidelines and Standards for Roles
  • Chapter 13: Oracle Utilities and Managing Data
  • Oracle Utilities
  • Rebuilding a Database
  • New 9i Features in Oracle Utilities
  • Exporting Statistics
  • Importing Statistics
  • New Parameters for Export and Import
  • Tablespace Level Exports
  • Direct-Load Inserts
  • SQL*Loader
  • Conventional versus Direct Path Loads
  • SQL*Loader Parameters
  • The Control File
  • Would you like to learn Oracle9i DBA Fundamentals I? We provide home tutoring service.

    Please contact us for any additional information.


    SPONSORED LINKS

    click to save 50%

    GoToMyPC Free Trial + $10 Off


    Real Networks

    Click here for great eBay values!




    PDA Superstore !!






















    FAQs| Link to Us| Privacy Statement| Legal Disclaimer| Advertise with Us
    © 2005 USACyberWorld.com. All Rights Reserved.