Oracle

Oracle

Overview

Oracle Database 11g Administrator Certified Associate (OCA) Describing the Oracle Architecture Oracle Server SGA Datafiles Background Processes Creating an Oracle Database Database Configuration Assistance Database Templates Managing an Oracle Instance Oracle Enterprise Manager Database Storage Structures Tablespaces Datafiles Tempfiles Database Security System Accounts Application Accounts Database Roles.

Oracle Database 11g Administrator Certified Associate (OCA)

Describing the Oracle Architecture

• Oracle Server
• SGA
• Datafiles
• Background Processes

Creating an Oracle Database

• Database Configuration Assistance
• Database Templates

Managing an Oracle Instance

• Oracle Enterprise Manager

Database Storage Structures

• Tablespaces
• Datafiles
• Tempfiles

Database Security

• System Accounts
• Application Accounts
• Database Roles

Schema Objects

• Tables
• Indexes
• Views
• Synonyms

Data Manipulation Language

• Insert
• Update
• Delete
• Database Packages
• Database Procedures

Undo Data

• Flashback Query

Database Maintenance

• Automatic Workload Repository
• Automatic Database Diagnostic Monitor

Database Performance

• Memory Advisors

Database Backup

• RMAN
• Open database Backup
• Closed database Backup

Database Recovery

• Open Database Recovery
• Closed Database Recovery

Moving Data

• Data Pump
• SQL*Loader