|
Introduction to Oracle9i:
SQL
Exam Number: 1Z0-007
Associated Certifications:
Oracle9i DBA OCA
Application Developer R.6i OCP
Application Developer R.9i OCA
Exam Price: $90.00 USD
Duration: 120 minutes
Passing Score: 71%
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
|
