CS 462

Assignment 1

Oracle

Out 1/14/2008, Due 1/21/2008

Objective(s)

1. To report on Oracle’s database server

2. To understand Oracle DBA certification path

3. To look for job opportunities for Oracle DBAs

Turn in

1. This sheet

2. Your report

1. Report on Oracle training programs – what are the contents and how much do they cost. Focus on 3-5 training centers.

2. Report on the latest release of Oracle (11g) and the new features it supports compared to Oracle 10g.

3. Get information on how to become an Oracle certified DBA – what exams must you take, how much do they cost, etc.?

4. Find information on 3-5 job opportunities for Oracle DBAs. Report such information as job duties and requirements, qualifications, and salary.

5. This refers to the Oracle installation on your machine in the lab. List:

a. ORACLE_BASE

b. ORACLE_HOME

c. All the lowest level directories in ORACLE_HOME

Graduate Students

d. Describe the contents of the PGA (Program Global Area).

e. Explain the shared server architecture/configuration and its working. (See the book as the first source.)