Home
Oracle 7 DBA eCertifications

The following outline describes the content of the Oracle 7 DBA eCertification.  To qualify as an Oracle 7 DBA, you must pass the examination with a score of 60% or higher.  To be certified as a Master Oracle 7 DBA, you must obtain a score of 75% or higher.

Relational Database Concepts

Topic

Subtopic

Additional Concepts

Concept

Additional Concepts

Replication

Architecture

APIs

Architecture

Concept

Architecture

Data Dictionary

Architecture

Integration Approaches

Architecture

Role of RDBMS

Architecture

Schema

Cursors

Concept

Design

Concept

Design

Data Modeling

Design

Denormalization

Design

Logical vs Physical

Design

Normalization

Design

Normalization Forms

Design

Redefining Tables

Indexes

Concept

Indexes

Considerations

Locking

Concept

Locking

Deadlocks

Performance

Common Bottlenecks

Performance

Common Problems/Causes

Performance

Concept

Performance

Dimensions

Performance

Tradeoffs

Procedures

Concept

Referential Integrity

Cascades

Referential Integrity

Concept

Referential Integrity

Keys

Roles

DBA

Roles

System Administrator

Transactions

Concept

Transactions

Recoverability

Triggers

Concept

Views

Concept

Oracle 7 DBA Content

Topic

Subtopic

Architecture

Background Processes

Architecture

Database Objects

Architecture

External Structures

Architecture

Instance

Architecture

Internal Database Structures

Architecture

Internal Memory Structures

Architecture

Networking

Architecture

Replication

Backup and Recovery

Catalog

Backup and Recovery

Import/Export

Backup and Recovery

Log Switch

Backup and Recovery

Noarchivelog/Archivelog Mode

Backup and Recovery

Physical Backups

Backup and Recovery

Types of Failures

Backup and Recovery

Types of Incomplete Recovery

DBA Basics

Auditing

DBA Basics

Clusters

DBA Basics

Constraints

DBA Basics

Control File

DBA Basics

Data Dictionary

DBA Basics

Data Integrity

DBA Basics

Database Objects

DBA Basics

DDL (Data Definition Language)

DBA Basics

Distributed Database

DBA Basics

DML (Data Manipulation Language)

DBA Basics

High Water Mark

DBA Basics

Index

DBA Basics

Privileges

DBA Basics

Profiles

DBA Basics

Redo Log Files

DBA Basics

Roles

DBA Basics

Rollback Segments

DBA Basics

Segments

DBA Basics

Sequence

DBA Basics

SQL*Loader

DBA Basics

SQL*Net

DBA Basics

Table

DBA Basics

Tablespace and Data Files

DBA Basics

Temporary Segments

DBA Basics

Trigger

DBA Basics

Users

DBA Basics

View

PL/SQL

Exceptions

PL/SQL

Explicit Cursor Attributes

PL/SQL

Predefined Exceptions

PL/SQL

SQL Cursor Attributes

Tuning

Blocks

Tuning

Buffer Cache

Tuning

EXPLAIN

Tuning

Latch Contention

Tuning

Lock Contention

Tuning

Redo Log

Tuning

Rollback Segments

Tuning

Shared Pool

Tuning

Sorts

Tuning

Statistics

Tuning

Tools

All eCertification examinations are delivered through the web and use computer adaptive testing (CAT), in which the degree of complexity for questions ares based on previous answers.  Additionally, questions are selected from large question banks, so that it is not productive to memorize questions. 

The expected time to complete the Oracle 7 DBA Administrator eCertification examination is 60 minutes.  In addition to registration with eCertifications.com, all certified professionals may use one of the logos below on their resume followed by a professional certificate which is suitable for framing.

Oracle 7 DBA Oracle 7 DBA Master

 


This page and its contents are Copyright 2010- www.ecertifications.com.
All Rights Reserved.