This website provides targeted information for you searches. Trust the #1 resource for certification information that thousands have come to rely upon for great resources, all at a low price.

Exam Topics

Writing Basic SQL Select Statements
[ ] List the capabilities of SQL SELECT statements
[ ] Execute a basic SELECT statement
[ ] Differentiate between SQL statements and iSQL*Plus commands

Restricting and Sorting Data
[ ] Limit the rows retrieved by a query
[ ] Sort the rows retrieved by a query

Single-Row Functions
[ ] Describe various types of functions available in SQL
[ ] Use character, number, and date functions in SELECT statements
[ ] Use conversion functions

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

Aggregating Data using Group Functions
[ ] Identify the available group functions
[ ] Use group functions
[ ] Group data using the GROUP BY clause
[ ] Include or exclude grouped rows by using the HAVING clause

Subqueries
[ ] Describe the types of problems that subqueries can solve
[ ] Define subqueries
[ ] List the types of subqueries
[ ] Write single-row and multiple-row subqueries

Producing Readable Output with iSQL*Plus
[ ] Produce queries that require a substitution variable
[ ] Produce more readable output
[ ] Create and execute script files

Manipulating Data
[ ] Describe each DML statement
[ ] Insert rows into a table
[ ] Update rows in a table
[ ] Delete rows from a table
[ ] Merge rows in a table
[ ] Control transactions

Creating and Managing Tables
[ ] Describe the main database objects
[ ] Create tables
[ ] Describe the datatypes that can be used when specifying column definition
[ ] Alter table definitions
[ ] Drop, rename and truncate tables

Including Constraints
[ ] Describe constraints
[ ] Create and maintain constraints

Creating Views
[ ] Describe a view
[ ] Create, alter the definition, and drop a view
[ ] Retrieve data through a view
[ ] Insert, update and delete data through a view

Creating Other Database Objects
[ ] Create, maintain and use sequences
[ ] Create and maintain indexes
[ ] Create private and public synonyms

Other related Resources at Actualtests.com

We hope you take advantage of the unlimited access package today. Your query about Oracle Exam Information - ActualTests.com can also be answered if you become a member today. We have all the details in the member zone. You can also download a testing engine for the most popular exams alogwith all the PDF's. They're all included in the package.

Check the MCSE Training page also if you are interested in that certification.