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
|
|