(1Z0-007) Introduction to SQL

SYNOPSIS • Oracle8i DBA OCP ^vs • Oracle9i DBA OCA ^vs

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