Java Dot Net Software Testing Oracle Networking

Oracle9i Database Administrator Certified Associate (OCA)

Exam Code : 1Z0-007 Enquire Now
Exam Name : Introduction to Oracle9i -SQL
Exam Duration : 120 Minute
No. 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 Enquire Now
Exam Name Oracle 9i: Database Fundamental I
Exam Duration 120 Minute
No. 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 Tablespaces 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 Enquire Now
Exam Name Oracle 9i : Database Fundamental II
Exam Duration 120 Minute
No. 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 Enquire Now
Exam Name Oracle 9i Database Performance Tuning
Exam Duration 120 Minute
No. of Questions 65 approx
Minimum Score 72
Pre-Requisites 1Z0-007, 1Z0-031 & 1Z0-032

Syllabus
  • Overview of Oracle 9i Database Performance Tuning
  • Sizing the Buffer Cache
  • Sizing other SGA Structures
  • Monitoring and Detecting Lock Contention
  • Using Oracle Blocks Efficiently
  • Diagnostic and Tuning Tools
  • Database Configuration and I/O Issues
  • 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 Enquire Now
Exam Name Oracle Database 10g: Administration I
Exam Duration 120 Minute
No. 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 Enquire Now
Exam Name Oracle Database 10g: Administration II
Exam Duration 90 Minute
No. 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



Course Enquiry Corporate Enquiry Institutional Enquiry Batch Schedule