Introduction to Oracle9i SQL®

Exam Number:	1Z0-007
Associated Certifications:	Oracle9i DBA OCA Oracle 10g DBA OCA Oracle 11g DBA OCA PL/SQL Developer OCA
Exam Price:	$95.00 USD
Exam Registration:	Register Exam available online

Duration:

120 minutes

Number of Questions:

Passing Score:

71%

Passing score subject to change. View Details

Recommended Training and Preparation

One of the following classes recommended to prepare for exam:

The Introduction to Oracle 9i SQL course covers additional topics that are not covered on the exam.
Introduction to Oracle9i: SQL Self-Study CD Course (NETg Oracle)
Self-Study CD-ROMs are an excellent tool to help you prepare for your exam. SSCDs reinforce the course material and allow you to focus on sections that you need to review. Note: the SSCDs do not count towards your course requirements for certification and should be used as a study aid only.

Additional Information & Resources

Practice Exams

Oracle authorized practice exam from Self Test Software. 1Z0-007 Introduction to Oracle9i: SQL
Oracle authorized practice exam from Transcender: Cert-1Z0-007 : DBCert: Introduction to 9i: SQL

Candidate Guides

Exam Retake Policy

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

Oracle Certification Program Fraudulent Activity Policy

Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.

If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate's Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate's employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle's authorized vendors, and may be required to pay additional fees for services rendered.

View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.