Industrial Certification in Oracle

Oracle9i Database Administrator Certified Associate (OCA)

  • Exam Code: 1Z0-007
  • Exam Name: Introduction to Oracle9i -SQL
  • Exam Duration:120 Minutes
  • of Questions:57 approx
  • Minimum Score:70%
  • Pre-Requisites: None

Syllabus

  • Introduction
  • Writing a Basic SQL Select Statement
  • Restricting and Sorting Data
  • Displaying Data from Multiple Tables
  • Aggregating Data by Using Group Functions
  • Writing Subqueries
  • Producing Readable Output with iSQL*Plus
  • Manipulating Data
  • Creating and Managing Tables
  • Including Constraints
  • Creating Views
  • Other Database Objects

  • Exam Code:1Z0-031
  • Exam Name: Oracle 9i: Database Fundamental I
  • Exam Duration:120 Minutes
  • of Questions:60 approx
  • Minimum Score:73%
  • Pre-Requisites:IZO-007

Syllabus

  • Oracle Architectural Components
  • Getting Started with the Oracle Server
  • Maintaining the Control File
  • Managing Table spaces and Data Files
  • Managing Tables
  • Managing an Oracle Instance
  • Creating a Database
  • Maintaining Redo Log Files
  • Storage Structure and Relationships
  • Managing Undo Data
  • Managing Indexes
  • Data Dictionary Content and Usage
  • Managing Password Security and Resources
  • Managing Users
  • Managing Privileges
  • Managing Roles
  • Maintaining Data Integrity
  • Using Globalization Support

Oracle9i Database Administrator Certified Professional (OCP)

  • Exam Code:1Z0-032
  • Exam Name: Oracle 9i : Database Fundamental II
  • Exam Duration:120 Minutes
  • of Questions:63 approx
  • Minimum Score:73%
  • Pre-Requisites:1Z0-007 & 1Z0-031

Syllabus

  • Networking Overview
  • Basic Oracle Net Architecture
  • Basic Oracle Net Services 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
  • Configuration of the Database Archiving Mode
  • Oracle Recovery Manager (RMAN) Overview and Configuration
  • User-Managed Backups
  • RMAN Backups
  • User-Managed Complete Recovery
  • RMAN Complete Recovery
  • User-Managed Incomplete Recovery
  • RMAN Incomplete Recovery
  • RMAN Repository Maintenance
  • RMAN Catalog Creation and Usage
  • Transporting Data Between Databases
  • Loading Data into a Database

  • Exam Code:1Z0-033
  • Exam Name: Oracle 9i Database Performance Tuning
  • Exam Duration:120 Minutes
  • of Questions:65 approx
  • Minimum Score:72
  • Pre-Requisites:1Z0-007, 1Z0-031 & 1Z0-032

Syllabus

  • Overview of Oracle 9i Database Performance Tuning/li>
  • Sizing the Buffer Cache
  • Sizing other SGA Structures
  • Monitoring and Detecting Lock Contention
  • Using Oracle Blocks Efficiently
  • Diagnostic and Tuning Tools
  • Optimize Sort Operations
  • Tuning Oracle Shared Server
  • Application Tuning
  • SQL Statement Tuning
  • Sizing the Shared Pool
  • Diagnosing Contention For Latches
  • Tuning the Operating System and Using Resource Manager

Oracle Database 10gAdministrator Certified Associate

  • Exam Code:1Z0-042
  • Exam Name: Oracle Database 10g: Administration I
  • Exam Duration:120 Minutes
  • of Questions:84 approx
  • Minimum Score:68%
  • Pre-Requisites:1Z0-007

Syllabus

  • Architecture
  • Installing the Oracle Database Software
  • Creating an Oracle Database
  • Managing the Oracle Instance
  • Managing Database Storage Structures
  • Administering User Security
  • Managing Schema Objects
  • Managing Data and Concurrency
  • Managing Undo Data
  • Implementing Oracle Database Security
  • Configuring the Oracle Network Environment
  • Performance Management
  • Performing Database Backup
  • Performing Database Recovery
  • Performing Flashback
  • Moving Data

Oracle Database 10gAdministrator Certified Professional

  • Exam Code:1Z0-043
  • Exam Name: Oracle Database 10g: Administration II
  • Exam Duration:90 Minute
  • of Questions:92 approx
  • Minimum Score:70%
  • Pre-Requisites:IZO-007 & 1Z0-042

Syllabus

  • Using Globalization Support Objectives
  • Configuring Recovery Manager
  • Recovering from User Errors
  • Dealing with Database Corruption
  • Automatic Database Management
  • Using Recovery Manager
  • Recovering from Non-Critical Losses
  • Monitoring and Managing Storage
  • Automatic Storage Management
  • Monitoring and Managing Memory
  • Database Recovery
  • Flashback Database
  • Managing Resources
  • Automating Tasks with the Scheduler