Error 404--Not Found

The server has not found anything matching the Request-URI. No indication is given of whether the condition is temporary or permanent.

If the server does not wish to make this information available to the client, the status code 403 (Forbidden) can be used instead. The 410 (Gone) status code SHOULD be used if the server knows, through some internally configurable mechanism, that an old resource is permanently unavailable and has no forwarding address.

Covers objectives for the Introduction to Oracle9i: SQL exam (1Z0-007)
The Oracle9i DBA certification provides the foundation for every type of e-business and information management solution. Gaining skills and credibility for your experience on the Oracle9i Database will open new doors for you as an Oracle technical professional. Because Oracle 9i installations can be found throughout the world, there is an increasing demand for those who are Oracle Certified.

Exam Objectives consists of the following:

Writing Basic SQL Select Statements
1) List the capabilities of SQL SELECT statements
2) Execute a basic SELECT statement
3) Differentiate between SQL statements and iSQL*Plus commands

Restricting and Sorting Data
1) Limit the rows retrieved by a query
2) Sort the rows retrieved by a query

Single-Row Functions
1) Describe various types of functions available in SQL
2) Use character, number, and date functions in SELECT statements
3) Use conversion functions

Displaying Data from Multiple Tables
1) Write SELECT statements to access data from more than one table using equality and nonequality joins
2) View data that generally does not meet a join condition by using outer joins
3) Join a table to itself using a self-join

Aggregating Data using Group Functions
1) Identify the available group functions
2) Use group functions
3) Group data using the GROUP BY clause
4) Include or exclude grouped rows by using the HAVING clause

Subqueries
1) Describe the types of problems that subqueries can solve
2) Define subqueries
3) List the types of subqueries
4) Write single-row and multiple-row subqueries

Producing Readable Output with iSQL*Plus
1) Produce queries that require a substitution variable
2) Produce more readable output
3) Create and execute script files

Manipulating Data
1) Describe each DML statement
2) Insert rows into a table
3) Update rows in a table
4) Delete rows from a table
5) Merge rows in a table
6) Control transactions

Creating and Managing Tables
1) Describe the main database objects
2) Create tables
3) Describe the datatypes that can be used when specifying column definition
4) Alter table definitions
5) Drop, rename and truncate tables

Including Constraints
1) Describe constraints
2) Create and maintain constraints

Creating Views
1) Describe a view
2) Create, alter the definition and drop a view
3) Retrieve data through a view
4) Insert, update and delete data through a view
5) Create and use an inline view
6) Perform Top 'N' Analysis

Creating Other Database Objects
1) Create, maintain and use sequences
2) Create and maintain indexes
3) Create private and public synonyms

Controlling User Access
1) Create users
2) Create Roles to ease setup and maintenance of the security model
3) Use the GRANT and REVOKE statements to grant and revoke object privileges