Solution Oracle, OCC
OLTP/OLAP
Career Center
Oracle Skills Matrix v1.2
This is the core skill set necessary to
obtain certification as an Oracle database administrator.
|
Skill |
Versions 7.x |
Versions 8.x |
Versions 9.x |
|
Backup/Recovery |
Yes |
Yes |
Yes |
|
Batch processing |
Yes |
Yes |
Yes |
|
Export/Import |
Yes |
Yes |
Yes |
|
Capacity planning |
Yes |
Yes |
Yes |
|
Clustering and redundancy design |
Yes |
Yes |
Yes |
|
Daily maintenance |
Yes |
Yes |
Yes |
|
Database maintenance plans, scheduling, alerts |
Yes |
Yes |
Yes |
|
DCL/DDL/DML |
Yes |
Yes |
Yes |
|
Devices, databases and tablespaces – design, creation, and
updating |
Yes |
Yes |
Yes |
|
Disaster Recovery |
Yes |
Yes |
Yes |
|
Documentation - policies and procedures |
Yes |
Yes |
Yes |
|
Hardware/RAID |
Yes |
Yes |
Yes |
|
Indexing and index optimization |
Yes |
Yes |
Yes |
|
Install/Configure/Upgrade |
Yes |
Yes |
Yes |
|
Load balancing |
Yes |
Yes |
Yes |
|
Logical design (schema) |
Yes |
Yes |
Yes |
|
Migration |
Yes |
Yes |
Yes |
|
Monitoring |
Yes |
Yes |
Yes |
|
NT, Unix |
NT, Unix |
NT, Unix |
|
|
Yes |
Yes |
Yes |
|
|
OLAP (Data warehousing) |
Yes |
Yes |
Yes |
|
OLTP |
Yes |
Yes |
Yes |
|
Performance Tuning (Optimization) |
Yes |
Yes |
Yes |
|
Physical design |
Yes |
Yes |
Yes |
|
Query Optimization |
Yes |
Yes |
Yes |
|
Replication |
Yes |
Yes |
Yes |
|
Security (User) administration |
Yes |
Yes |
Yes |
|
SQL |
Yes |
Yes |
Yes |
|
Oracle end of architecture (2-tier, 2½-tier, 3-tier &
other n-tier) |
Yes |
Yes |
Yes |
|
Oracle end of ecommerce solutions |
Yes |
Yes |
Yes |
|
Oracle vendor relations |
Yes |
Yes |
Yes |
|
Stored procedures, triggers, constraints, views |
Yes |
Yes |
Yes |
|
Tables, fields (columns), records (rows) - creation and
updating |
Yes |
Yes |
Yes |
|
Troubleshooting |
Yes |
Yes |
Yes |