• Describe the general partioning rules

Implementing Partitioned Indexes

• Describe the different types of partitioned indexes

Supporting Commands and Guidelines for Partitioned Tables and Indexes

• Describe restrictions that apply to certain operations

Parallelizing INSERT, UPDATE, and DELETE Operations

• Enable parallel DML for a session

Identifying New ROWID Structure

• Describe the new ROWID format

Managing Large Objects

• Differentiate between internal and external LOBs

Implementing Oracle Advanced Queuing

• Define the advanced queuing concepts

Using Additional New Features

• Implement reverse key indexes
• Create and use index-organized tables

Introduction to Recovery Manager

• Discuss the benefits of using Recovery Manager
• Identify the types of backups

Enhancements to Networking

• Describe the concept of multiplexing
• Describe the concept of connection pooling

Implementing Password Management

• Implement password aging and expiry

Optimizer and Query Improvements

• Describe the features of optimizer plan stability
• Explain Top-N SQL queries
• Explain automatic parallel execution

Summary Management

• Build and Manage Materialized views for Oracle Summaries
• Build and Manage Dimensions

Indexes and Index-Organized Tables

• Describe a function-based index

Partitioning Improvements

• Implement range, hash, and composite partitioning
• Describe partition-wise join

LOBs

• Define LOBs from a DBA perspective