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.

---