|
1Z0-007 Introduction
to Oracle 9i: SQL Introduction
*Writing Basic SQL SELECT
Statements * Restricting and Sorting Data
*Single-Row Functions * Displaying Data from
Multiple Tables * Aggregating Data using Group
Functions * Sub-queries * Producing Readable
Output with iSQL Plus * Manipulating Data *
Creating and Managing Tables * Including Constraints
* Creating Views * Creating Other Database
Objects * Controlling User Access
1Z0-031 Oracle 9i
Administration Fundamentals – I
* Oracle Architectural
Components * Getting Started with the Oracle Server
* Managing an Oracle Instance * Creating a
Database * Data Dictionary Content and Usage *
Maintaining the Control File * Maintaining the
Redo Log Files * Managing Tablespaces and Data
Files * Storage Structure and Relationships *
Managing Undo Data * Managing Tables * Managing
Indexes * Maintaining Data Integrity *
Managing Password Security and Resources * Managing
Users * Managing Privileges * Managing Roles *
Using Globalization Support
1Z0-032 Oracle 9i
Administration Fundamentals – II
* Networking Overview *
Basic Oracle Net Architecture * Basic Net
Server-Side Configuration * Basic Oracle Net
Services Client-Side Configuration * Usage and
Configuration of the Oracle Shared Server *
Backup and Recovery Overview
* Instance and Media Recovery Structures *
Configuring the Database Archiving Mode * Oracle
Recovery Manager Overview and Configuration *
User-Managed Backups * RMAN
Backups * User-Managed Complete Recovery * RMAN
Complete Recovery * User-Managed Incomplete Recovery
* RMAN Incomplete Recovery
* RMAN Maintenance * Recovery Catalog Creation and
Maintenance * Transporting Data between
Databases * Loading Data into a Database
1Z0-033 9i Performance
Tuning
* Overview of Oracle9i
Performance Tuning * Diagnostic and Tuning Tools *
Sizing the Shared Pool * Sizing the Buffer Cache *
Sizing other System Global Area (SGA) Structures *
Database Configuration and I/O Issues * Optimize
Sort Operations * Diagnosing Contention for
Latches * Tuning Rollback (or UNDO) Segments
* Monitoring and Detecting Lock Contention * Tuning
Oracle Shared Server
* Application Tuning * Using Oracle Blocks
Efficiently * SQL Statement Tuning
* Tuning the Operating System and using Resource |