1Z0-001

(1Z0-001) SQL and PL/SQL

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

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