Exam 1Z0-007: Introduction to Oracle9i: SQL
 | 
E X A M D I F F I C U L T Y
   
| |
|
|
SYNOPSIS • Oracle8i DBA OCP • Oracle9i DBA OCA
Oracle’s Oracle 8i and 9i exam 1Z0-007, “Introduction
to Oracle9i: SQL” is a core requirement for the Oracle 8i and 9i OCP (Oracle
Certified Professional) certifications. It is designed for all database
personnel seeking Oracle certification. There is no specific prerequisite for
this exam.
This exam is easy to
moderately difficult and costs $90 USD. It is an online
exam which may be taken from Thomson
Prometric or from an Oracle
University Training Center
The pass score for this
form-based multiple choice exam is 70%. There are 57 scored questions (“your exam may contain unscored
questions in addition to the scored questions”) and the exam
lasts 2 hours.
The
topics covered by this exam include:
- Writing Basic SQL Select
Statements
- Restricting and Sorting Data
- Single-Row Functions
- Displaying Data from Multiple
Tables
- Aggregating Data using Group
Functions
- Subqueries
- Producing Readable Output with iSQL*Plus
- Manipulating Data
- Creating and Managing Tables
- Including Constraints
- Creating Views
- Creating Other Database Objects
- Controlling User Access
For more information:
http://www.oracle.com/education/certification/objectives/index.html?7.html
Helpful: Compare this exam with others.
|
Email this Page
