OCP Oracle 9i Database : New Features for Administrators Exam Guide (Exam 1Z0-030)

Introduction to Oracle 9i - SQL Exam Guide (EXAM 1ZO-007)

Part1

Chapter1 Overview of Oracle Database
Chapter2 Limiting, Sorting, and Manipulating Return Data
Chapter 3 Advanced Data Selection in Oracle
Chapter4 Subqueries
Chapter5 Creating Oracle Database Objects
Chapter6 Manipulating Oracle Data
Chapter7 Creating Other Database Objects in Oracle
Chapter8 User Access Control in Oracle

Part2

Practice Exam


New Features for Administrators Exam Guide (Exam 1Z0-030)

Part1

Chapter1 Security Enhancements
Chapter2 Availability Enhancements
Chapter 3 Manageability Enhancements
Chapter4 Performance and Scalability Enhancements
Chapter5 Language Enhancements

Part2

Practice Exam


Fundamentals 1 Exam Guide (Exam 1Z0-031)

Part1

Chapter1 Basic of the Oracle Database Architecture
Chapter2 Managing the Physical Database Structure
Chapter 3 Managing Tablespaces and Datafiles
Chapter4 Storage Structures and Undo Data
Chapter5 Managing Database Objects
Chapter6 Managing Database Users

Part2

Practice Exam


Fundamentals 2 Exam Guide (Exam 1Z0-032)

Part 1

Chapter1 Networking Overview
Chapter2 Basic Oracle Net Architecture
Chapter3 Basic Net Server-Side Configuration
Chapter4 Basic Oracle Net Services Client-Side Configuration
Chapter5 Usage and Configuration of the Oracle Shared Server

Part 2

Chapter6 Backup and Recovery Overview
Chapter7 Instance and Media Recovery Structures
Chapter8 Configuring the Database Archive Mode
Chapter9 Oracle Recovery Manager Overview and Configuration
Chapter10 User-Managed Backups
Chapter11 RMAN Backups
Chapter12 User-Managed Complete Recovery
Chapter13 RMAN Complete Recovery
Chapter14 User-Managed Incomplete Recovery
Chapter15 RMAN Incomplete Recovery
Chapter16 RMAN Maintenance
Chapter17 Recovery Catalog Creation and Maintenance
Chapter18 Transporting Data Between Database
Chapter19 Loading Data into a Database

Part 3

Practice Exam


Perfomance Tuning Exam Guide (Exam 1Z0-033)

Part 1

Chapter1 Database Tuning Overview
Chapter2 Oracle Performance Tuning Methodology
Chapter 3 Diagnostic and Tuning Tools
Chapter4 Sizing the Shared Pool
Chapter5 Sizing the Buffer Cache
Chapter6 Sizing Other SGA Structures
Chapter7 Database Configuration and I/O Issues
Chapter8 Optimize Sort Operations
Chapter9 Diagnosing Contention for Latches
Chapter10 Tuning Rollback or Undo Segments
Chapter11 Monitoring and Detecting Lock Contention
Chapter12 Tuning Oracle Shared Server
Chapter13 Application Tuning
Chapter14 Using Oracle Blocks Efficiently
Chapter15 SQL Statement Tuning
Chapter16 OS Considerations and Oracle Resource Manager

Part2

Practice Exam