Introduction to Oracle9i SQL: 1Z0-007 Exam

• Exam Number: 1Z0-007
• Exam Price: US$ 125
• Duration: 120 minutes
• Number of Questions: 52
• Passing Score: 71%

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

please visit http://www.lead2pass.com/1z0-007.html