Oracle Certification Notes: Part I

I’ve decided that while my wife is studying for her upcoming GMATs, I’m going to study for my Oracle 11g Certified Associate credential (after all, it is a recommended certification). For those of you following along, I’ve changed from 10g to 11g. Might as well get the most recent credential.

So begins a series of posts that will serve as a reference for me, while I study over the next month, in the hopes of taking the first of two exams sometime in February ’09.

Structured Query Language (SQL)
Three separate languages in one form:
Data Definition Language (DDL) – create/maintain database objects
Data Control Language (DCL) – create/maintain users and permissions
Data Modification Language (DML) – add/update/delete data

Oracle Database Objects
Besides the most common objects (e.g., table, row, column, cell, constraint, etc.), here are a few that I’ll need to reference in the future:

Index-organized Table –Similar to a table, except the data is stored based on the index definition, as opposed to randomly (or on a heap)

Cluster – A storage-mechanism object that must be preallocated. Helps to organize multiple, related tables in the same block to reduce the amount of database reads.

User-defined datatype – Can be used to create consistency and apply methods as part of the definition.

Oracle Data Dictionary
Base tables, owned by SYS, contain the meta data for user-defined database objects. Use views to access base tables, as base table names are purposefully cryptic.

USER_ views – Objects owned by schema user.

ALL_ views – Objects owned by the schema user or objects to which the schema user has privileges.

DBA_ views – Privileges required. All objects and utilized by DBAs.

DBA Responsibilities
Beyond the obvious ones (to me anyway!), here’s some others:
Sizing and evaluating server hardware,
Planning and designing the database structure

Posted via Woodland Blog (

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.