Oracle® Certification Program

Candidate Guide

Oracle9i PL/SQL Developer Certified Associate

Oracle9i Forms Developer Certified Professional

January 2005
 Contents
Oracle Certification Program Candidate Guide
Oracle9i PL/SQL Developer Certified Associate
Oracle9i Forms Developer Certified Professional

February 2004

1 Benefits of Oracle Certification

2 Oracle9i PL/SQL Developer Certified Associate and

Oracle9i Forms Developer Certified Professional

3 Preparing for Oracle9i PL/SQL and Forms Developer Tests

4 Registering for Your Tests

5 Taking Your Tests

6 After You Are Certified

7 Special Testing Opportunities

Test Content Checklists

Visit the Oracle Certification Program Web site at [Link]

1 Benefits of Oracle Certification

The demand for professionals in the Beyond OCA, by becoming an Oracle

information technology (IT) industry is Certified Professional (OCP) you
high, and the competition for jobs is demonstrate your understanding of the
intense. Individuals, experienced or new full range of skills required by Oracle
to the profession, need to know what professionals in your chosen job role. An
skills make them attractive to employers. OCP is in high demand in today's
Employers look for ways to select marketplace, and the level of demand is
prospective employees who have the solid expected to grow with each new
foundation of skills needed for effective installation of Oracle technologies around
performance. the world. An Oracle Certification helps
raise your visibility and increases your
The Oracle Certification Program helps
access to the industry's most challenging
the IT industry establish a standard of
opportunities.
competence in key entry-level and
professional job roles. "Oracle’s certification strength in a
An Oracle Certification is a valuable, declining economy is due in part to
industry-recognized credential that the fact that more complex, high-level
signifies a proven level of knowledge and certifications appear to be less
ability. Each higher level of Oracle vulnerable." 2
certification brings a higher standard of The true value of earning an Oracle
benchmarked skill and ability, which can Certification credential is increased
lead to greater opportunities and higher opportunity. With more opportunity come
pay. career growth and higher pay.
"Technical certifications have evolved "Given the key importance of data as
from a hiring tool to a screening tool: an organizational asset, it should come
If you don’t have them, you aren’t to no surprise that DBAs remain in
viewed as a serious candidate." 1 high demand and that related training
B e n e f i t s t o th e T e c h n i cal
certification programs are popular
Prof essiona l even in this time of economic trouble...
By the numbers, Oracle leads the
An Oracle Certified Associate (OCA) DBMS/DBA certification area.” 3
demonstrates a solid understanding of the
foundation skills of a given job role,
which can be applied at an apprentice or
entry level.
By earning an OCA certification, you can
have increased entry-level job
opportunities. It is the stepping-stone to
starting a successful career as an Oracle
professional.

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer Certified
Professional 1
 1 Source: Employers Raise the Bar on Certification, Information
B e n e f i t s t o th e IT Emp lo y e r Week, 2002
The Oracle Certification Program is also 2 Source: IDC Certification Report and Forecast 2002–2006
3 Source: Certified Expert: Working as a Database
valuable to hiring managers who want to Administrator, CertMag, January 2003
distinguish among candidates for critical
IT positions. For companies that send
employees for annual IT training,
certification helps ensure a return on the
training investment by validating the
knowledge and understanding gained
during training sessions. Companies can
also combine certification with an
employee development program to
enhance employee loyalty and
performance on the job. Hiring certified
professionals can have a direct impact on
a company's success.

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 2
2 Oracle9i PL/SQL Developer Certified Associate
Oracle9i Forms Developer Certified Professional

knowledge and skills into increased

O ra cl e9 i Dev elo per
C er tif i cat io n: Ov erv iew visibility through the market's most highly
valued Developer certification. The
The expertise of Oracle Application
Oracle Application Developer Certified
Developers is integral to the success of
Professional credential was related the
today's increasingly complex system
highest in employment value as compared
environments. The best Certified
to all other developer credentials by
Developers operate primarily behind the
scenes. Without their highly valued skills Certification Magazine, April 2003.1
organizations would fail to realize the View the chart on page 5 for a list of
potential of their information required tests to earn the Oracle9i
management and e-business solutions. Application Developer credential.
Oracle Developers can apply their skills to
U pg ra d ing Yo ur Cu rr en t OC P
almost any type of project from business
C red en tia l to Oracle9 i
intelligence solutions to automation.
Oracle Forms Developer Release 6/6i
O ra cl e9 i PL/S Q L Dev elo per
to Oracle9i Upgrade Path (1 exam)
C er tif ie d As so cia te ( OCA)
An OCA certification is an entry-level Candidates certified on Oracle Forms
credential for candidates who have a Developer Release 6/6i may pass exam
proven foundation of basic knowledge, #1Z0-140 (Oracle9i Forms Developer:
which they can build upon as they work New Features) to upgrade their Developer
toward a career as an Oracle Application certification to Oracle9i.
Developer. An OCA can next earn an Oracle Developer Release 1 to Oracle9i
Oracle9i Forms Developer Certified Upgrade Path (2 exams)
Professional (OCP) credential. Candidates certified on Oracle Developer
O ra cl e9 i Fo rms Deve lop er Release 1 are required to pass two exams
C er tif ie d Profe s siona l (O CP) to upgrade their OCP credential: exam
By moving upward and earning OCP #1Z0-130 (Oracle Forms Release 1 to
status, Oracle professionals demonstrate Release 6/6i: New Features) and exam
the complete set of skills that are required #1Z0-140 (Oracle9i Forms Developer:
for working independently as an expert New Features).
Developer. The OCP credential provides
candidates increased opportunities and
higher pay. The OCP path requires that
candidates first earn their OCA-level
credential. To become an OCP, only one
additional exam is required, which
evaluates candidates’ skills with the
Oracle9i Forms Developer toolset. An
OCP certification helps you translate your
January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 3
Ca ndidate Qualif ications 1 Source: "Rating Certifications," Certification
Magazine, April, 2003
Most candidates pursuing their Oracle
Application Developer certification
combine up-to-date training with some
level of on-the-job experience. There is no
"typical" candidate. Many of the questions
on the OCA and OCP tests are based on
real job scenarios. In addition to the
appropriate training, you will need hands-
on experience with the software. Trial
software versions are available through
Oracle University and the Oracle
Technology Network (OTN).

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 4
 R e q u ire d Exa m s f o r O ra cl e 9 i App li ca tio n D eve lop er C er tif i cat io n
Paths
Oracle customers and business partners demand hands-on experience from their Oracle
Certified Professionals. In order to meet commitments to Oracle customers and
constituents, Oracle University has recently made a significant investment toward building
more validity and quality into its Certification Program, including scenario-based exam
questions.
E x a m s R e q u ire d
Oracle9i Application Developer Certified Associate
Oracle9i Application Developer Certified Professional
Introduction to Oracle9i Program Oracle9i PL/SQL Oracle9i Forms Oracle9i Forms
Oracle: SQL® with PL/SQL Developer Developer: Build Developer
Certified Internet Certified
Exam # 1Z0-007 Exam # 1Z0-147
Associate Applications Professional
Exam # 1Z0-141

OR
Introduction to Exam # 1Z0-007
Oracle: SQL® and Introduction to Oracle9i: SQL can
PL/SQL™
be taken over the Internet (see
Exam # 1Z0-001
Section 5 of this guide).

O ra cl e9 i App l ica t ion Dev elop er Upgra de Pa th

To upgrade your Oracle Application Developer Release 1 OCP credential to Oracle9i
Application Developer, you must pass the following two upgrade exams.
Oracle Oracle Forms Oracle Internet Oracle9i Forms Oracle9i Forms
Application Developer Rel. 1 Application Developer New Developer
Developer Rel. 1 to Rel. 6/6i New Developer Features Certified
Certified Features Certified Exam # 1Z1-140 Professional
Professional Professional
Exam # 1Z0-130

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 5
3 Preparing for Oracle9i Application Developer Exams

T es t C o n t e n t C h e c k l i s t
Oracle recommends that you prepare for
Oracle9i Developer exams by combining Use the Test Content Checklist to identify
offerings from Oracle University with all the test topics for which you must
practice and on-the-job experience. Start prepare. Oracle may make modifications
by reviewing the topics covered on the to the Test Content Checklist, so visit the
exam in the Test Content Checklist in this OCP Web site at
guide. Then look over the following [Link]
preparation methods for a combination cation/ to download the latest version of
that suits your background. this guide.
O ra cl e Un ive rs i ty P repa ra ti on Add i tio na l P repa ra tio n Too ls
Tools Practice Tests
Instructor-Led Training and Online Library Oracle and Self Test Software have
offered by Oracle University are the best partnered to develop the highest
ways to prepare to become an Oracle quality practice tests available to
Certified Professional. These courses lay individuals seeking Oracle Certified
the foundation of knowledge that you will Professional status. To purchase
need to pass the OCA and OCP exams. practice tests, visit the OCP Web site
Refer to the curriculum map on the at
following page to chart your optimal [Link]
preparation based on Oracle University ification/.
instructor-led training and online library. Oracle Press
Your local Oracle University
representative can advise you on the best Oracle Press publishes both reference
option. For more information, visit the guides and exam preparation guides to
Oracle University Web site at help candidates prepare for their job
[Link] requirements. These can be helpful as
additional sources for study. However,
Pr epar ing on Yo ur Ow n Oracle Press books are not designed to
Experience is the best way to deepen your be used by OCA or OCP candidates as
understanding of the topics covered in their only source of exam preparation.
Oracle University courses. Oracle Oracle Press books are additional
recommends that you extend your references that can be helpful to those
classroom learning either by applying your who have completed hands-on training
new skills and knowledge to the job or or who have real-job experience.
through practice and self-study.

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 6
 O ra cl e9 i App l ica t ion Dev elop er Ce rti fi ca tio n
Oracle University Instructor-Led Training and Online Library titles are shown below:

Introduction to Oracle9i: Program Oracle9i: Build Oracle9i: Forms

Oracle9i: SQL with PL/SQL Internet Developer Certified
Exam # 1Z0-147 Applications Professional
Exam # 1Z0-007 Exam # 1Z0-141

Introduction to Oracle9i: Program Oracle9i: Build Oracle9i: Forms

Oracle9i: SQL with PL/SQL or Internet Developer Certified
Oracle9i: Develop Applications Professional
PL/SQL Program

Introduction to Oracle9i: Program Oracle9i Forms

Oracle9i: SQL with PL/SQL Developer: Use
OR Data Structures
Oracle9i: Develop Effectively
PL/SQL Program Oracle9i Forms
Units Developer:
Enhance Usability
Developer: Build
Internet
Applications I

O ra cl e9 i Fo rms Deve lop er Upg rade Pat h f or C er tif ie d App li ca ti on

Dev elo per R elea se 6/ 6i O CP

Certified Internet Oracle9i Forms Oracle9i: Forms

Application Developer New Developer Certified
Developer, Features Professional
Oracle Forms Exam # 1Z0-140
Developer
Rel. 6/6i

Oracle9i Forms
Developer New
Features

= OCP Exam
= Instructor-Led Training

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 7
4 Registering for Your Tests

Oracle Certification Program exams are S cheduling Your Exam

offered at Oracle University Testing 1. There are three convenient ways to
Centers and through Prometric, the register for exam:
world’s largest provider of testing to the
information technology industry. Many a. Prepare and appear for test at an
Oracle University Locations now also Oracle University Center
offer these exams, and can serve as a Many countries throughout Europe,
convenient alternative for both India, and Asia offer exam
preparation and exam writing at one preparation assistance as well as the
facility. Follow the registration directions exams themselves from one
shown below for scheduling exams at an convenient location. Visit the OCP
Oracle University Center or at an Web site, and you will find phone
Authorized Prometric Testing Center numbers for your local Oracle
(APTC). University Center on the Exam
Registration Web page.
All exams are delivered electronically by ([Link]
means of computer. A brief tutorial certification/[Link])
precedes each test to familiarize you with
the test delivery system. You should b. APTC Online Registration
attempt to answer every question on the Register online at
exam because incomplete answers are [Link]
scored as incorrect. Using a summary c. APTC Telephone Registration
screen you can navigate throughout the Call the Prometric Regional Service
exam, proceeding forward and back Center (RSC) serving your country
among questions. during normal business hours. (A
Rev iew ing t he Can dida te list of RSCs is given on the last page
Ag reem en t of this guide.)
Candidates pursuing Oracle certification 2. Make sure that you have both the
must accept the terms of the Oracle number and title of the exam that you
Certified Associate - Professional are registering for. Schedule your exam
Candidate Agreement before taking the appointment Monday through Saturday
tests. You will be presented with the during normal authorized Prometric
agreement on the screen before the test testing center hours. Hours vary by
starts. You can also review the agreement location.
before your appointment by visiting the
Oracle Certification Program Web site at
[Link]
ation/[Link].

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 8
3. When you register, ask the Prometric C hang ing or Ca nceling You r
customer service representative for a App oi ntme nt
list of valid forms of identification that To cancel or reschedule your test
you will need to present when you take appointment, you must call the Prometric
your exam. You will not be allowed to Regional Service Center. The cancellation
take the test without valid policy by region is:
identification.
The Americas: One business day in
4. Regular exam fees are equivalent to advance
US$125, plus any local taxes. Asia Pacific: By midday (Sydney time)
The exam fee is payable to Prometric the previous business day
by any major credit card (VISA, EMEA: Two business days in advance
MasterCard, American Express, and Japan: Three business days in advance
Switch Cards) at the time of
registration. All discounts must be Candidates who do not appear for the test
applied at the time of paying your or who cancel less than one business day
exam fee. before the test do not receive a refund.

5. You must schedule a test at least 24

hours in advance.

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 9
5 Taking Your Tests

Ta king Introduction to 2. Sign the test log and present two forms
O ra cl e9 i: SQ L over the of identification. One must be a
I n ter n e t government-issued photo
The Introduction to Oracle9i: SQL exam identification. Both forms of
is now delivered on the Internet in an identification must contain your
effort to make taking this first exam easy signature.
and flexible, and cheap to the OCA 3. The test administrator will give you a
candidate who is just getting started. brief orientation and escort you to a
The exam can be taken anytime, from computer terminal where you will take
anywhere with a PC, current Web browser the test. You are not allowed to bring
(see page 5 of this guide, Internet papers, books, bags, or calculators into
Delivered Tests, for the recommended the room.
browsers), and a recommended Internet 4. Remember to adhere to the
connection of at least 33.6 Kps. requirements set forth in the Oracle
To take this online exam, visit the Oracle Certification Candidate Agreement.
Certification Program Web site. There is You must agree to the terms and
no need for preregistration. Payment can conditions in the agreement before
be made by credit card right on the completing any Oracle Certification
Internet. exam. Any attempt to cheat, assist
others, or remove exam content from
Your score will be available to you
the testing room will not be tolerated
immediately after completion of the exam
and may result in a zero score,
and submittal of your file for grading. If
disallowance of OCP credential, and
you become disconnected during your
even prosecution by law.
exam, you will be able to resume where
you left off when you reconnect. O bta in ing Yo ur Te st Re su lt s
However, the time clock will remain in You will receive your score report
effect. Internet exams have an additional immediately after the test. Beta exam
window of 30 minutes to give you time to score reports are sent to candidates
resolve technical problems. following analysis and scoring of the beta
Ta king a Test a t an exam. Candidates completing a beta
Authorized Prome tr i c Te st i ng version of a test can expect their score
C en ter reports 10–12 weeks following the beta
1. Arrive at the testing center at least 15 period. Your results are automatically
minutes before your scheduled forwarded to Oracle following testing.
appointment. Please keep a copy of all test reports for
your records.

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 10
Retaking a Test If you receive a low score, an Oracle
Candidates must wait 30 days before University training course may be
retaking a failed exam. There are no appropriate for you to gain more
exceptions to this policy. knowledge. Otherwise, if you require only
skill-set review in a few areas, we
If you do not pass an Oracle Certification recommend that you consult Oracle
exam on the first attempt, Oracle University Online Learning, where you
encourages you to make use of the will find each topic area available as a
diagnostic feedback supplied with the short course module. Most modules
score report to review the areas that need require only 45 minutes for completion.
further study. Visit Online Learning at
[Link]

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 11
6 After You Are Certified

Ke ep ing C urren t w ith New

Re ce iv ing Yo ur Ora c le
C er tif i cat io n We lc ome K it O ra cl e Te ch no logy Re lea se s

You will receive your Oracle Certified Oracle is committed to keeping the Oracle
Associate or Oracle Certified Professional Certification Program abreast with the
certificate by mail from Prometric within latest technology. To take full benefit of
30 days after successfully completing all your Oracle Certified Professional
the required exams and course credential, you may find it advantageous
requirements as applicable. You should to upgrade your certification to the latest
use your certificate as verification of your release.
Oracle Certification credential. Re t irem en t of a n O CP T ra ck
If you do not receive your Welcome Kit, When Oracle announces the retirement of
send an e-mail to a track, you will have at least six months
fulfillment@[Link], providing to pass the remaining exams in the retiring
your name, Prometric ID number, current track. If you do not upgrade your
mailing address, and daytime phone certification by the deadline, you will be
number. required to complete all tests within the
O ra cl e Ce rt if ied Prof es s iona l new track to obtain the latest credential.
M e m b e r s W e b S i te Consult the OCP Web site for current
testing requirements.
Upon completion of your Oracle Certified
Professional credential, you will receive Upda ting Yo ur Demog raphic
information on how to obtain a copy of I n f o rma ti o n
the OCP logo in your Welcome Kit. The Visit the Prometric Web site at
logo may be used on business cards and [Link] to update
resumes. your demographic information.
You will also receive a letter of Follow the steps below:
congratulations from Oracle, which will
indicate how you can begin to access the 1. Log in to the site with your e-mail
wealth of OCP benefits that await you. address and password. If you have
This will include the access log in and never registered online before, click the
password that you will need to enter the link to set up your online account.
OCP member online community. 2. In the left navigation bar under Exam
The OCP Members site is available only Services, click Update Profile.
to Oracle Certified Professionals, and not 3. You may update your mailing address,
to Oracle Certified Associates. telephone numbers, and your e-mail
address.
4. Select Next. Your OCP Candidate
information is now updated.

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 12
7 Special Testing Opportunities

Sp ec ia l Oppo r tun it i es : Be ta Beta score reports are sent to candidates

and Tryout Tests following analysis and scoring of the beta
Oracle may offer beta or tryout versions test.
of OCP tests as new and updated Visit the Oracle Certification Program
questions are developed. Beta and tryout Web site at
tests are generally offered free or at a [Link]
discount from the regular test price. ation/ to find beta and tryout
Participating in beta and tryout tests is a opportunities. Oracle provides detailed
good way to economize on your descriptions of each beta and tryout offer
certification and to be among the first to help you decide whether the tests are
professionals to be certified on a new right for you.
track or product release.

Visit the OCP Web site at [Link]

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 13
 Test Content Checklists

The following test content checklists show the

objectives covered in the Oracle Certification
exams.

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 14
 Test Content Checklist

Introduction to Oracle: SQL® and PL/SQL™

Exam# 1Z0-001
Ov erv iew of R ela tiona l Join a table to itself
D a tab a s e s , S Q L , a n d P L/ S Q L
Agg rega ti ng D a ta U si ng
Discuss the theoretical and physical G ro up Fun c tio ns
aspects of a relational database
Identify the available group functions
Describe the Oracle implementation of
the RDBMS and ORDBMS Describe the use of group functions
Describe the use and benefits of Group data by using the GROUP BY
PL/SQL clause
W r it in g B as ic S QL Sta teme nt s Include or exclude grouped rows by
using the HAVING clause
List the capabilities of SQL SELECT
statements Subqueries

Execute a basic SELECT statement Describe the types of problems that

subqueries can solve
Differentiate between SQL statements
and SQL*Plus commands Define subqueries
Re stricting a nd So rting Data List the types of subqueries
Limit the rows retrieved by a query Write single-row and multiple-row
subqueries
Sort the rows retrieved by a query
M u lt ip le -Co lum n Su bqu er ies
S ing le-Row Functions
Write multiple-column subqueries
Describe various types of functions
available in SQL Describe and explain the behavior of
subqueries when null values are
Use character, number, and date retrieved
functions in SELECT statements
Write subqueries in a FROM clause
Describe the use of conversion
functions P ro d u ci n g R e a d a b l e O u tp u t
w it h S QL* P lu s
D isp lay ing Data f rom M ul t ip le
Tab le s Produce queries that require an input
variable
Write SELECT statements to access
data from more than one table by using Customize the SQL*Plus environment
equality and nonequality joins Produce more readable output
View data that generally does not meet Create and execute script files
a join condition by using outer joins
Save customizations
January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 15
 ® ™
Exam #1Z0-001—Introduction to Oracle: SQL and PL/SQL
(continued)

M an ipu lat i ng Da ta In clud ing Co ns tra in ts

Describe each DML statement Describe constraints
Insert rows into a table Create and maintain constraints
Update rows in a table C rea ting V iews
Delete rows from a table Describe a view
Control transactions Create a view
C rea ting an d Manag ing Tab le s Retrieve data through a view
Describe the main database objects Insert, update, and delete data through
Create tables a view
Describe the data types that can be Drop a view
used when specifying column
definition
Alter table definitions
Drop, rename, and truncate tables

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 16
 ® ™
Exam #1Z0-001—Introduction to Oracle: SQL and PL/SQL
(continued)

O ra cl e Da ta D i ct iona ry Use coding conventions

Describe the data dictionary views a I n tera c tin g w it h th e Ora c le
user may access Server
Query data from the data dictionary Write a successful SELECT statement
O th e r D a t a b a s e O b je c ts in PL/SQL
Describe database objects and their Declare the data type and size of a
uses PL/SQL variable dynamically
Create, maintain, and use sequences Write DML statements in PL/SQL
Create and maintain indexes Control transactions in PL/SQL
Create private and public synonyms Determine the outcome of SQL DML
statements
Co nt ro ll in g U se r A c ces s
W r it in g Co nt ro l St ru c tu re s
Create users
Identify the uses and types of control
Create roles to ease setup and structures
maintenance of the security model
Construct an IF statement
Use the GRANT and REVOKE
statements to grant and revoke object Construct and identify different loop
privileges statements

De c lar ing Var iab le s

Use logic tables

List the benefits of PL/SQL Control block flow by using nested

loops and labels
Describe the basic PL/SQL block and
its sections W o r ki n g w it h C o m p o si te D a ta
Ty pes
Describe the significance of variables
Create user-defined PL/SQL records
in PL/SQL
Create a record with the %ROWTYPE
Declare PL/SQL variables
attribute
Execute a PL/SQL block
Create a PL/SQL table
W r it in g Exe c utab le
S tatemen ts
Create a PL/SQL table of records

Describe the significance of the Describe the difference between

executable section records, tables, and tables of records

Write statements in the executable

section
Describe the rules of nested blocks
Execute and test a PL/SQL block

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 17
 ® ™
Exam #1Z0-001—Introduction to Oracle: SQL and PL/SQL
(continued)

W r it in g Exp l ic i t Cu rs or s H a ndl in g Ex ce p t ion s

Distinguish between an implicit and an Define PL/SQL exceptions
explicit cursor
Recognize unhandled exceptions
Use a PL/SQL record variable
List and use different types of PL/SQL
Write a cursor FOR loop exception handlers
Adva nc ed Ex pl i cit C ur so r Trap unanticipated errors
Co ncep ts
Describe the effect of exception
Write a cursor that uses parameters propagation in nested blocks
Determine when a FOR UPDATE Customize PL/SQL exception message
clause in a cursor is required
Determine when to use the WHERE
CURRENT OF clause
Write a cursor that uses a subquery

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 18
 Test Content Checklist
®
Introduction to Oracle9i: SQL
Exam# 1Z0-007
W r it in g B as ic S QL Se le ct Agg rega ti ng D a ta U si ng
S tatemen ts G ro up Fun c tio ns

List the capabilities of SQL SELECT Identify the available group functions
statements Use group functions
Execute a basic SELECT statement Group data by using the GROUP BY
Differentiate between SQL statements clause
and iSQL*Plus commands Include or exclude grouped rows by
Re stricting a nd So rting Data using the HAVING clause
Limit the rows retrieved by a query Subqueries

Sort the rows retrieved by a query Describe the types of problems that
subqueries can solve
S ing le-Row Functions
Define subqueries
Describe various types of functions
available in SQL List the types of subqueries
Use character, number, and date Write single-row and multiple-row
functions in SELECT statements subqueries
Use conversion functions P ro d u ci n g R e a d a b l e O u tp u t
w it h iS QL * Pl us
D isp lay ing Data f rom M ul t ip le
Tab le s Produce queries that require a
substitution variable
Write SELECT statements to access
data from more than one table by using Produce more readable output
equality and nonequality joins Create and execute script files
View data that generally does not meet M an ipu lat i ng Da ta
a join condition by using outer joins
Describe each DML statement
Join a table to itself by using a self-join
Insert rows into a table
Update rows in a table
Delete rows from a table
Merge rows in a table
Control transactions

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 19
 ®
Exam #1Z0-007—Introduction to Oracle9i: SQL (continued)

C rea ting an d Manag ing Tab le s C rea ting V iews

Describe the main database objects Describe a view
Create tables Create, alter the definition, and drop a
view
Describe the data types that can be
used when specifying column Retrieve data through a view
definition Insert, update, and delete data through
Alter table definitions a view
Drop, rename, and truncate tables C rea ti ng O th er D a t a bas e
O bj ec t s
In clud ing Co ns tra in ts
Create, maintain, and use sequences
Describe constraints
Create and maintain indexes
Create and maintain constraints
Create private and public synonyms

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 20
 Test Content Checklist

Oracle9i: Program with PL/SQL

Exam# 1Z0-147
Ov erv iew of PL/SQ L C rea ti ng F u n ct io ns
Programs
Define what a stored function is
Describe a PL/SQL program construct
Create a function
List the components of a PL/SQL
List how a function can be invoked
block
List the advantages of user-defined
List the benefits of subprograms
functions in SQL statements
Describe how a stored procedure or
List where user-defined functions can
function is invoked
be called from within an SQL
C rea ti ng P ro ce du re s statement
Define what a stored procedure is Describe the restrictions on calling
List the development steps for creating functions from SQL statements
a procedure Remove a function
Create a procedure Describe the differences between
Describe the difference between procedures and functions
formal and actual parameters M a nag ing Sub prog ra m s
List the types of parameter modes Contrast system privileges with object
List the methods for calling a privileges
procedure with parameters Grant privileges
Describe the DEFAULT option for Contrast invokers’ rights with definers’
parameters rights
Create a procedure with parameters Identify views in the data dictionary to
Invoke a procedure that has manage stored objects
parameters
Define a subprogram in the declarative
section of a procedure
Describe how exceptions are
propagated
Remove a procedure

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 21
Exam #1Z0-147—Oracle9i: Program with PL/SQL
(continued)

C rea ting Pa ckag es O ra cle Supplie d Pa ckag es

Use the DESCRIBE command to Describe the benefits of Execute
describe packages, and list their Immediate over DBMS_SQL for
possible components Native Dynamic SQL
Identify a package specification and Identify the flow of execution
body
Use EXECUTE IMMEDIATE
Create packages: Create related
variables, cursors, constants, Describe the use and application of
exceptions, procedures, and functions some Oracle server–supplied packages:
DBMS_DDL, DBMS_JOB, Submit
Designate a package construct as either Jobs, DBMS_OUTPUT, UTL_FILE,
public or private UTL_HTTP, and UTL_TCP
Invoke a package construct M a n ip u lat i n g La rge O b j e c ts
Use a bodiless package Compare and contrast LONG and
Drop packages large object (LOB) data types
Identify benefits of packages Create and maintain LOB data types
M o r e Pa cka g e C o n c e p ts Differentiate between internal and
external LOBs
Write packages that use the
overloading feature Identify and manage Bfiles: Create
directories, use Bfiles, load Bfiles, and
Use Forward Referencing use the Bfilename function
Describe errors with mutually Migrate from LONG To LOB
referential subprograms
Use the DBMS_LOB PL/SQL
Initialize variables with a one-time-only package
procedure
Create LOB columns and populate
Identify persistent states in package them
variables and cursors
Perform SQL operations on LOBS:
Identify restrictions on using packaged Update LOBs with SQL, select from
functions in SQL statements LOBS, and delete LOBS
Invoke packaged functions from SQL Describe the use of temporary LOBs
Use PL/SQL tables and records in
packages

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 22
Exam #1Z0-147—Oracle9i: Program with PL/SQL
(continued)

C rea ti ng Da tabas e Tr igg er s View trigger information in the

Describe the different types of triggers dictionary views
List how triggers are used Manag ing Dep ende ncie s

List guidelines for designing triggers Track procedural dependencies

Create a DML trigger Describe dependent objects and
referenced objects
List the DML trigger components
View dependency information in the
Describe the trigger firing sequence dictionary views
options
Describe how the UTLDTREE script
Use conditional predicates in a DML is used
trigger
Describe how the IDEPTREE and
Create a row-level trigger DEPTREE procedures are used
Create a statement-level trigger Describe a remote dependency
Use the OLD and NEW qualifiers in a List how remote dependencies are
database trigger governed
Create an INSTEAD OF trigger Describe when a remote dependency is
Describe the difference between stored unsuccessfully recompiled
procedures and triggers Describe when a remote dependency is
Describe the trigger execution model successfully recompiled
Alter a trigger status List how to minimize dependency
failures
Remove a trigger
M o r e T r igg e r C o nc e p ts
Define what a database trigger is
Describe events that cause database
triggers to fire
Create a trigger for a DDL statement
Create a trigger for a system event
Describe the functionality of the CALL
statement
Describe the cause of a mutating table
List what triggers can be implemented
for
List the privileges associated with
triggers
January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 23
 Test Content Checklist

Oracle9i Forms Developer: Build Internet

Applications
Exam# 1Z0-141
I n trod u ct io n to Ora c le Form s W o r ki n g i n t h e F o r m s
Dev elo per a nd Ora cl e Fo rm s Dev elo per Env iro nme nt
Serv ices
Describe the main Forms Developer
Describe the components of Oracle9i executables
Developer Suite and Oracle9i Describe the main Forms Developer
Application Server module types
Describe the features and benefits of Describe the main objects in a form
Oracle Forms Services and Oracle module
Forms Developer
Run a form from within Forms Builder
Describe the architecture of Oracle
Forms Service ⎯ Start and stop an OF4J instance
⎯ Set Forms Builder preference to use
Describe Forms Builder components OF4J
Navigate the Forms Builder interface C rea ti ng a Ba si c Fo rm Modu le
Customize the Forms Builder session Create a form module
Use the online help facilities Create data blocks, create data blocks
Ru nn ing a Form s Dev elo per with relationships, and create control
App l ica t ion blocks
Describe the run-time environment: Use wizards in reentrant mode to make
⎯ Explain the role of each changes to the data block and layout
⎯ Modify Forms environment variables Save and compile a form module
⎯ Describe the appearance of a form at Describe Forms file formats and their
run time characteristics
Navigate a Forms application Explain how to deploy a form module
Retrieve both restricted and Produce text files and documentation
unrestricted data
Run a master-detail form module
Describe the two modes of operation
Insert, update, and delete records
Display database errors

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 24
Exam #1Z0-141—Oracle9i Forms Developer: Build Internet
Applications (continued)

W o r ki n g w it h D a ta B lo ck s a n d Display helpful messages

F rames
C rea ti ng L OV s a nd Ed i to r s
Describe the methods to modify object
properties Describe LOVs and editors
Describe the features of the Property Design, create, and associate LOVs
palette with text items in a form module
⎯ Describe the relationship between
Manipulate properties through the
LOVs and record groups
Property palette
⎯ Explain the steps to create an LOV
⎯ Display the Property palette
manually
⎯ Describe the property controls for
⎯ Use the LOV Wizard to create an
different types of properties
LOV
⎯ Display multiple Property palettes
⎯ Set LOV properties
⎯ Set properties on multiple objects
Create editors and associate them with
⎯ Copy properties
text items in a form module
Control the behavior and appearance
C rea ti ng Add i tio na l Inp ut
of data blocks Items
⎯ Use visual attributes
Describe the item types that allow
⎯ Use font, pattern, and color pickers input
⎯ Set navigation properties
Create a check box
⎯ Set records properties
⎯ Set database properties Create a list item
⎯ Set scrollbar properties Create a radio group
Control frame properties C rea ting Non inp u t Item s

Delete data blocks and their Describe item types that do not allow
components input
W o r ki n g w it h T e x t It e m s Create a display item
Describe text items Create an image item
Create a text item Create a button
Manage and modify text items by using Create a calculated item
the Property palette Create a hierarchical tree item
⎯ Control data in text item
Create a bean area item
⎯ Alter navigational behavior
⎯ Enhance relationship between text
item and database
⎯ Add functionality to text item

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 25
Exam #1Z0-141—Oracle9i Forms Developer: Build Internet
Applications (continued)

C rea ting Windows and P r o d u ci n g T r i g g e r s

Co nten t Ca nvase s
Write trigger code
Define windows, content canvases, and ⎯ Create a trigger of appropriate type and
viewports scope
Describe the relationship between ⎯ Describe the features of the PL/SQL
windows and content canvases Editor
Create windows and content canvases ⎯ Describe the features of the Database
Trigger Editor
Display a form module in multiple
windows and on multiple layouts ⎯ Explain the structure of trigger code
⎯ Use variables in triggers
Wor king w ith O the r Canvas
Ty pes Explain the use of built-in
Describe the different types of subprograms in Forms applications
canvases and their relationships to each Describe the When-Button-Pressed
other trigger
Identify the appropriate canvas type Describe the When-Window-Closed
for different scenarios trigger
Create an overlay effect by using De bugg ing T r igge rs
stacked canvases Describe the methods to debug
Create a toolbar triggers in Forms Builder
Create a tabbed interface Describe the components of the
Debug Console
I n trod u ct io n to Tr ig ger s
Describe triggers Run a form module in debug mode by
using the Run Form Debug button
Describe the different trigger
categories Debug PL/SQL code
⎯ Set breakpoints in code
Describe the components of a trigger
⎯ Step through code
Describe the types of statements used ⎯ View variable values while form is
in trigger code running
Describe the properties that affect the
behavior of a trigger

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 26
Exam #1Z0-141—Oracle9i Forms Developer: Build Internet
Applications (continued)

A d d in g F u n ct io na li ty to I tem s Q ue ry Tr igg er s
Describe item interaction triggers Explain the processes involved in
querying a data block
Supplement the functionality of input
items by using triggers and built-ins Describe query triggers and their scope
⎯ Code interactions with radio groups Control query array processing
⎯ Code interactions with check boxes Write triggers to modify query
⎯ Change list items at run time behavior
⎯ Display an LOV from a button Control trigger action based on the
Supplement the functionality of form’s query status
noninput items by using triggers and
Obtain query information at run time
built-ins
⎯ Populate image items Va lida t ion

⎯ Populate hierarchical trees Describe the validation process

⎯ Code interactions with JavaBeans in Control validation
the bean area item ⎯ Using object properties
Run-Time Messages and ⎯ Explain the effects of the validation
A le rt s unit upon a form
Describe the default messaging ⎯ Use an LOV for validation
behavior of a form ⎯ Use triggers
Handle run-time failure of built-in ⎯ Use Pluggable Java Component
subprograms Describe how Forms tracks validation
Describe the different types of Forms status
Builder messages Control when validation occurs
Cause a trigger to fail in a controlled Navigation
manner
Describe how navigation affects the
Control system messages navigation unit and the cursor
Create and control alerts Distinguish between internal and
Handle database server errors external navigation
Control navigation with properties
Describe and use navigation triggers to
control navigation
Explain how the navigation trap occurs
Use navigation built-ins in triggers

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 27
Exam #1Z0-141—Oracle9i Forms Developer: Build Internet
Applications (continued)

T ra n sac t ion Pr o c e s s ing ⎯ Create property classes

Explain the process used by Forms to ⎯ Add properties to property classes
apply changes to the database ⎯ Inherit properties from property
Describe the commit sequence of classes
events ⎯ Explain the inheritance symbol in the
Property palette
Describe the characteristics and uses of
commit triggers Group related objects for reuse
Supplement transaction processing Copy and subclass objects
⎯ Perform delete validation Reuse objects from an object library
⎯ Allocate sequence numbers to records ⎯ Describe object libraries
as they are applied to tables ⎯ Describe the benefits of using object
⎯ Keep an audit trail libraries
Test the results of trigger DML ⎯ Create object libraries
Override default transaction processing ⎯ Populate object libraries
⎯ Modify objects in an object library
Describe how to run against a
non_Oracle data source ⎯ Create and use SmartClasses

Get and set the commit status Reuse PL/SQL code

Implement array DML I n trod u cin g Mu lt ip le Fo rm

App l ica t ion s
W r it in g Fl ex ib le Cod e
Describe the characteristics of multiple
Describe flexible code form applications
Use system variables to determine: Describe the benefits of multiple form
⎯ Cursor focus applications
⎯ Trigger focus Call one form from another form
⎯ Commit status module
Describe built-in subprograms that Define multiple form functionality
assist flexible coding Share data among open forms
Write code to reference objects: Control opening and closing multiple
⎯ By internal ID forms
⎯ Indirectly Synchronize data among multiple
Sha r ing O bject and C ode forms
Describe benefits of reusing objects
and code
Create and use property classes
⎯ Describe property classes

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 28
Exam #1Z0-141—Oracle9i Forms Developer: Build Internet
Applications (continued)

C re a ti n g M e n u Mod u l e s D ef in in g D a ta S o ur c es
Describe the different components of Describe the various data source types
a menu module Base a data block on a FROM clause
Create, save, and attach menu modules query
Set menu properties by using the Discuss the advantages of using a
Property palette FROM clause query
Create menu toolbars Base a data block on a stored
procedure that returns a REF cursor
Create pop-up menus
M a n a g in g M e n u M o d u le s
Return a table of records from a stored
procedure
Control menus programmatically
Define a data source with the Data
Manage the interaction between the Block Wizard
menu and form documents
Select the appropriate data source for a
Implement application security data block
through the menu
W or ki ng w it h R eco rd G roup s
Pro gramm ing Fu nc t ion K eys
Describe the record group object
Define key triggers and their uses
Use record groups
Program function keys
Define record groups at design time
Describe the characteristics of key
triggers Control record groups by using built-in
functions
Classify key triggers
Define query record groups
Associate function keys with interface programmatically and
controls nonprogrammatically
B u ild in g M u lt ip le Fo rm Manipulate record group rows
App l ica t ion s
Define lists of values (LOVs)
Describe the various ways of invoking programmatically
additional forms modules
Implement dynamic list items and add
Open and close form modules values to combo boxes
Navigate between form modules
Control open form modules
Choose the most appropriate method
for invoking forms

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 29
Exam #1Z0-141—Oracle9i Forms Developer: Build Internet
Applications (continued)

U si n g D a t a b a s e O b je c ts i n
Fo rms App lica tio ns
Recognize which object types are
supported
Describe how object types are
represented within Form Builder
Create a block based on an object table
Create a block based on a relation table
with an object or an REF column
Populate a REF column with an LOV

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 30
 Test Content Checklist

Oracle9i Forms Developer: New Features

Exam# 1Z0-140
Why Upgra de to Ora c le9 i Run a form from the Forms Builder
Fo rms using OC4J
Explain the components of Oracle9i ⎯ Start and stop an OC4J session
Developer Suite ⎯ Set Forms Builder preferences to use
Describe the benefits provided by OC4J
Oracle9i Forms Customize the Forms Services
⎯ Explain the reasons why Forms has configuration
been optimized for the Web ⎯ Define environment variables
⎯ Describe Oracle9i Forms productivity ⎯ Define Forms Servlet parameters
enhancements
M ig ra ti ng Ex i st ing
⎯ Explain the features for global
App l ica t ion s to O ra cl e9 i
deployment of Forms applications Forms
⎯ Explain how Oracle9i Forms provides
integration features Describe the migration path for
applications written in previous
⎯ Describe the openness of Oracle9i versions of Forms
Forms
Explain the methods you can use to
Explain how Oracle9i Forms has been upgrade applications
streamlined
⎯ Explain the types of features removed
Use Oracle9i Forms Migration
from the product Assistant to upgrade a Forms6i
application
⎯ Explain the components that have
been removed from the product Explain issues that can be encountered
when upgrading from Forms versions
De ploy ing Form s App l ica t ion s
o n the Int er ne t before 6i
Describe the architecture of Oracle9i Describe design and upgrade issues
Application Server with applications previously deployed
by other means
Explain the role of Oracle Containers
for J2EE (OC4J) in deploying Explain how to integrate graphs from
applications Forms6i applications
Describe the components of Oracle9i Run Reports from Oracle9i Forms
Forms Services
Describe the process of starting a run-
time session

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 31
Exam #1Z0-140—Oracle9i Forms Developer: New Features
(continued)

D e s ig n ing F o rm s M o d u le s ⎯ Step through code

O u t si d e th e Bu i ld e r
Debug an application remotely
Explain the batch methods of
modifying Forms modules Enable tracing and logging to help
troubleshoot problems:
Describe the benefits of modifying ⎯ Configure Forms Track
Forms with a batch method
⎯ Start a trace
Use the Java API (JDAPI) to modify ⎯ View Forms Trace output
Forms modules
⎯ Describe servlet logging levels
⎯ Explain the advantages of using JDAPI
⎯ Turn on Forms Listener Servlet
⎯ Describe the architecture of JDAPI
logging
⎯ Use JDAPI to:
⎯ Turn on Forms Servlet logging
∏ Manage the JDAPI session ⎯ View the servlet log file
∏ Create a new Form module I n teg rat in g Java in to For ms
∏ Add objects to modules App l ica t ion s
Explain the methods for using Java in
∏ Save and compile modules
Forms applications
∏ Load existing modules
Explain the significance of using JDK
∏ Access child objects of a Forms 1.3
module
Use the improved support for
∏ Modify Forms objects JavaBeans
∏ Delete Forms objects ⎯ Describe JavaBeans
∏ Copy and subclass Forms objects ⎯ Explain how Forms and JavaBeans
interact
∏ Handle exceptions
⎯ Describe the functionality provided by
⎯ Explain how to write generic code the FBean package
⎯ Use javadoc for JDAPI ⎯ Set bean area item properties
Use the Forms to XML conversion ⎯ Respond to JavaBean events
utility to modify Forms modules ⎯ Interact with nonevent JavaBeans
Troub lesho oting Fo rms ⎯ Deploy JavaBeans for use with Forms
Ap p l ica t ion s applications
Describe the components of the Use Pluggable Java Components
Forms Debugger (PJCs)
Use the Debugger to diagnose ⎯ Describe PJCs
problems with a Forms module: ⎯ Implement PJCs
⎯ Set breakpoints
⎯ Run a form in debug mode

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 32
Exam #1Z0-140—Oracle9i Forms Developer: New Features
(continued)

E nha ncing the Use r ⎯ Use built-ins to manipulate time zones

E x p e ri e nc e
Publish one URL for applications that
Design an LOV that can be canceled will be displayed in different languages
for long-running queries based on the browser setter
Write code that retrieves the Forms ⎯ Explain how browser language settings
version are communicated to the applications
server
Write code to restrict a query only the
first time it is executed ⎯ Describe how the language setting
determines the application that runs
De ploy ing Form s App l ica t ion s
Globally ⎯ Deploy language-specific applications

Specify item length for single-byte, Describe the TranslationHub tool to

multiple-byte, and variable-byte translate Forms modules into different
character sets languages
⎯ Explain how to start TranslationHub
Adjust functionality for different time
zones ⎯ Describe the TranslationHub user
interface
⎯ Explain how time zone conversion
works ⎯ Explain the steps to translate an
application
⎯ Modify environment variables to
enable time zone conversion

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 33
 Prometric Regional Service Centers

Regional Service Centers

Sydney, Australia Regional Service Center (direct dial#) +612.9414.3663
Lelystad, Netherlands Regional Service Center (direct dial#) +31.320.23.9894
Tokyo, Japan Regional Service Center (direct dial#) + 813.3269.9620
Latin America Regional Service Center (direct dial#) +1.410.843.4300
North America Regional Service Center (toll-free#) +1.800.891.3626

How t o U s e Th is Tab le
1. Locate your country in the table.

2. Call the Prometric Regional Service Center (RSC) listed for your country. The RSC
numbers are shown in the box above. If there is a toll-free number for your country to
the Regional Service Center, then it should be in the following table. For a list of testing
sites in your country, refer to [Link] Test Center Locator.
COUNTRY RSC TOLL-FREE # COUNTRY RSC TOLL-FREE #
Algeria Leystad Curacao, NA Latin America

Argentina Latin America Cyprus Lelystad

Australia Australia [Link] Czech Republic Lelystad

Austria Leystad 0660.8582 Denmark Lelystad

Bahamas Latin America Dominican Republic Latin America

Bangladesh Australia Ecuador Latin America

Barbados Latin America Egypt Lelystad

Belgium Lelystad 0800.1.7414 Estonia Lelystad

Bermuda Latin America Fiji Australia

Bolivia Latin America Finland Lelystad

Botswana Lelystad France Lelystad [Link]

Brazil Latin America 000.817.965.5340 Gabon Lelystad

Brunei Australia Bahrain Lelystad

Bulgaria Lelystad Georgian Republic Lelystad

Cameroon Lelystad Germany Lelystad 0130.83.97.08

Canada North America Ghana Lelystad

Cayman Islands Latin America Great Britain Lelystad [Link]

Chile Latin America Greece Lelystad

China Australia 1.0800.610.0036 Guam Australia 1888.249.6392

Colombia Latin America 980.13.0932 Guatemala Latin America

Costa Rica Latin America Honduras Latin America

Croatia Lelystad Hong Kong Australia 800.96.8444

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 34
COUNTRY RSC TOLL-FREE # COUNTRY RSC TOLL-FREE #
Hungary Lelystad Portugal Lelystad

Iceland Lelystad Puerto Rico Latin America

India Australia Reunion Island Lelystad

Indonesia Australia 001.803.61608 Romania Lelystad

Ireland Lelystad [Link] Russia Lelystad

Israel Lelystad Saudi Arabia Lelystad

Italy Lelystad 1.6787.8441 Senegal Lelystad

Ivory Coast Lelystad Singapore Australia 800.616.1132

Jamaica Latin America 1.800.892.1978 Slovakia Lelystad

Japan Tokyo 0120.387737 Slovenia Lelystad

Jordan Lelystad South Africa Lelystad

Kazakhstan Lelystad South Korea Australia 007.8611.3095

Kenya Lelystad Spain Lelystad

Kuwait Lelystad Sri Lanka Australia

Latvia Lelystad Suriname Latin America

Lebanon Lelystad Sweden Lelystad

Lithuania Lelystad Switzerland Lelystad 0800.55.69.66

Luxembourg Lelystad Taiwan Australia 008.061.1141

Macau Australia Tanzania Lelystad

Macedonia Lelystad Thailand Australia 01.800.611.2401

Malaysia Australia 1800.80.0508 Trinidad & Tobago Latin America

Malta Lelystad Tunisia Lelystad

Martinique Lelystad Turkey Lelystad

Mauritius Lelystad Ukraine Lelystad

Mexico Latin America 95.800.332.1034 United Arab Emirates Lelystad

Morocco Lelystad United States North America 1.800.891.3926

Namibia Lelystad Uruguay Latin America

Nepal Australia Venezuela Latin America

Netherlands Lelystad 0800.022.7584 Vietnam Australia 612.9414.3666

New Caledonia Australia Yugoslavia Lelystad

New Zealand Australia 0800.44.1689 Zimbabwe Lelystad

Nigeria Lelystad

Norway Lelystad

Oman Lelystad

Pakistan Australia

Panama Latin America

Papua New Guinea Australia

Paraguay Latin America

Peru Latin America

Philippines Australia [Link].0126

Poland Lelystad

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 35
 Oracle Corporation World Headquarters Oracle Corporation is the world’s
500 Oracle Parkway leading supplier of software for
information management, and the
Copyright © Oracle, 2004. Redwood Shores, CA 94065 USA world’s second largest independent
All Rights Reserved Worldwide Inquiries: software company. The company
offers its database, tools, and
Printed in the USA +1.650.506.7000
application products, along with
V02.04 +1.650.506.7200 (Fax) related consulting, education, and
[Link] support services, in more than 145
countries around the world.
[Link]
Oracle is a registered trademark,
[Link]
SQL*Plus, and Oracle8, Oracle8i and
Oracle Certification Program Inquiries: Oracle9i are trademarks or
Contact your local Oracle University registered trademarks of Oracle
Representative from Corporation. Other names may be
[Link] trademarks of their respective
owners.
US telephone Inquiries:
1.800.633.0575

January 2005 — Oracle Certification Program Candidate Guide: Oracle9i PL/SQL Developer Certified Associate and Oracle9i Forms Developer
Certified Professional 36