Exam 1Z0-001: Oracle8i Introduction to Oracle SQL and PL/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 exam 1Z0-001, “Introduction to
Oracle: SQL and PL/SQL” is a core requirement for the Oracle 8i OCP (Oracle
Certified Professional) certification. It is designed for all database
personnel seeking Oracle certification. There is no specific prerequisite for
this exam.
This exam is moderately
difficult and costs $125 USD. It may be taken from Thomson Prometric.
The pass score for this
form-based multiple choice exam is 68%. 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:
- Overview of Relational Databases, SQL and PL/SQL
- Writing Basic SQL Statements
- Restricting and Sorting Data
- Single Row Functions
- Displaying Data from Multiple Tables
- Aggregating Data Using Group Functions
- Subqueries
- Multiple-Column Subqueries
- Producing Readable Output with SQL*Plus
- Manipulating Data
- Creating and Managing Tables
- Including Constraints
- Create and Maintain Constraints
- Oracle Data Dictionary
- Other Database Objects
- Controlling User Access
- Declaring Variables
- Writing Executable Statements
- Interacting with the Oracle Server
- Writing Control Structures
- Working with Composite Datatypes
- Writing Explicit Cursors
- Advanced Explicit Cursor Concepts
- Handing Exceptions
For more information:
http://www.oracle.com/education/certification/objectives/index.html?1.html
Helpful: Compare this exam with others.
|
Email this Page
1 down, 4 more to go