DURATION: 3MONTHS FEES Per Course:Rs.10,000/-
The ORACLE or Oak Ridge Automatic Computer and Logical Engine, an early computer built by Oak Ridge National Laboratory, was based on the IAS architecture developed by John von Neumann. As with all computers of its era, it was a one of a kind machine that could not exchange programs with other computers (even other IAS machines). It used vacuum tubes, transistors, and diodes. It used a Williams tube for 2048 words of memory. Its addition time was 70 microseconds, the multiplication time was 370-590 microseconds, and the division time was 590 microseconds. These times include the storage access time, which was about 62 microseconds.
Requirements for Certification
To become an Oracle Certified Database Administrator for the Oracle9i track, you must pass
four tests. These exams cover knowledge of the essential aspects of the SQL language,
Oracle administration, backup and recovery and performance tuning of systems. The
certification process requires that you pass the following four exams:
Exam 1: Introduction to Oracle9i: SQL (1Z0-007)
Exam 2: Oracle9i Database: Fundamentals l (1Z0-031)
Exam 3: Oracle9i Database: Fundamentals ll (1Z0-032)
Exam 4: Oracle9i Database: Performance Tuning (1Z0-033)
Recertification
Oracle announces the requirements for upgrading your certification based on the release
of new products and upgrades. Oracle will give six month’s notice announcing when an
exam version is expiring.
Exam Format
The computer-based exams are multiple-choice tests, consisting of 50-65 questions that
must be completed in 90-120 minutes.
OCP DBA Exam l: Introduction to SQL (1Z0-00
Overview of Oracle Database
Ø Limiting, sorting and manipulating Return Data
Ø Advanced Data Selection in Oracle
Ø Subqueries
Ø Creating Oracle Database Objects
Ø Manipulating Oracle Data
Ø Creating Other Database Objects in Oracle
Ø User Access Control in Oracle
OCP DBA Fundamentals l Exam (1Z0-031)
Basics of the Oracle Database Architecture
Managing the Physical Database Structure
Managing Tablespaces and Datafiles
Storage Structures and Undo Data
Managing Database Objects
Managing Database Users
Basics of the Oracle Database Architecture
Managing the Physical Database Structure
Managing Tablespaces and Datafiles
Storage Structures and Undo Data
Managing Database Objects
Managing Database Users OCP Database Administration Fundamentals l
Globalization Support
OCP DBA Fundamentals l Exam (1Z0-032)
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
Instance and Media Recovery Structures
Ø Configuring the Database Archive 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
OCP DBA Performance Tuning (1Z0-033)
Database Tuning Overview
Ø Oracle Performance Tuning Methodology
Ø Diagnostic and Tuning Tools
Ø Sizing the shared Pool
Ø Sizing the Buffer Cache
Ø Sizing Other SGA Structures
Ø Database Configuration and l/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
Ø OS Considerations and Oracle Resource Manager
