Duration:
120 mniutes
Number of Questions:
69
Passing Score:
75%
Passing score subject to change. View Details
Recommended Training and Preparation
Additional Information & Resources
Exam Topics
Fraudulent Activity Policy
Recommended Training and Preparation
Additional Information & Resources
Exam Topics
Introduction
to Oracle Forms Developer and Oracle Forms Services
[ ]
Describe the components of Oracle9i Developer Suite and the Oracle9i
Application Server
[ ]
Describe
the features and benefits of Oracle Forms Services and Oracle Forms
Developer
[ ]
Describe
the architecture of Oracle Forms Services
[ ]
Describe
Forms Builder components
[ ]
Navigate
the Forms Builder interface
[ ]
Customize
the Forms Builder session
[ ]
Use
the online help facilities
Running
a Forms Developer Application
[ ]
Describe
the run-time environment
__
Explain
the role of each
__
Modify
Forms environment variables
__
Describe
the appearance of a form at run time
[ ]
Navigate
a Forms application
[ ]
Retrieve
both restricted and unrestricted data
[ ]
Describe
the two modes of operation
[ ]
Insert,
update, and delete records
[ ]
Display
database errors
Creating
LOVs and Editors
[ ]
Describe
LOVs and editors
[ ]
Design,
create, and associate LOVs with text items in a form module
__
Describe
the relationship between LOVs and record groups
__
Explain
the steps to create an LOV manually
__
Use
the LOV Wizard to create an LOV
__
Set
LOV properties
[ ]
Create
editors and associate them with text items in a form module
Creating
Additional Input Items
[ ]
Describe
the item types that allow input
[ ]
Create
a check box
[ ]
Create
a list item
[ ]
Create
a radio group
Creating
Noninput Items
[ ]
Describe
item types that do not allow input
[ ]
Create
a display item
[ ]
Create
an image item
[ ]
Create
a button
[ ]
Create
a calculated item
[ ]
Create
a hierarchical tree item
[ ]
Create
a bean area item
Creating
Windows and Content Canvases
[ ]
Define
windows, content canvases, and viewports
[ ]
Describe
the relationship between windows and content canvases
[ ]
Create
windows and content canvases
[ ]
Display
a form module in multiple windows and on multiple layouts
Working
with Other Canvas Types
[ ]
Describe
the different types of canvases and their relationships to each other
[ ]
Identify
the appropriate canvas type for different scenarios
[ ]
Create
an overlay effect by using stacked canvases
[ ]
Create a toolbar
[ ]
Create
a tabbed interface
Introduction
to Triggers
[ ]
Define
triggers
[ ]
Describe
the different trigger categories
[ ]
Describe
the components of a trigger
[ ]
Describe the types of statements used in trigger code
[ ]
Describe
the properties that affect the behavior of a trigger
Working
in the Forms Developer Environment
[ ]
Describe
the main Forms Developer executables
[ ]
Describe
the main Forms Developer module types
[ ]
Describe
the main objects in a form module
[ ]
Run
a form from within Forms Builder
__
Start
and stop an OC4J instance
__
Set
Forms Builder preferences to use OC4J
Creating
a Basic Form Module
[ ]
Create
a form module
[ ]
Create
data blocks, create data blocks with relationships and create control
blocks
[ ]
Use
wizards in re-entrant mode to make changes to the data block and layout
[ ]
Save and compile a form module
[ ]
Describe Forms file formats and their characteristics
[ ]
Explain how to deploy a form module
[ ]
Produce text files and documentation
[ ]
Run a master-detail form module
Working
with Data Blocks and Frames
[ ]
Describe
the methods to modify object properties
[ ]
Describe the features of the Property Palette
[ ]
Manipulate
properties through the Property Palette
__
Display
the Property Palette
__
Describe
the property controls for different types of properties
__
Display
multiple Property Palettes
__
Set
properties on multiple objects
__
Copy
properties
[ ]
Control
the behavior and appearance of data blocks
__
Use
visual attributes
__
Use
font, pattern, and color pickers
__
Set
navigation properties
__
Set
records properties
__
Set
database properties
__
Set
scrollbar properties
[ ]
Control
frame properties
[ ]
Delete
data blocks and their components
Working
with Text Items
[ ]
Describe
text items
[ ]
Create
a text item
[ ]
manage
and modify text items using the property palette
[ ]
Display
helpful messages
Producing
Triggers
[ ]
Write
trigger code
__
Create a trigger of appropriate type and scope
__
Describe
the features of the PL/SQL Editor
__
Describe
the features of the Database Trigger Editor
__
Explain
the structure of trigger code
__
Use
variables in triggers
[ ]
Explain
the use of built-in subprograms in Forms applications
[ ]
Describe
the When-Button-Pressed trigger
[ ]
Describe
the When-Window-Closed trigger
Debugging
Triggers
[ ]
Describe
the methods to debug triggers in Forms Builder
[ ]
Describe
the components of the Debug Console
[ ]
Run
a form module in debug mode by using the Run Form Debug button
[ ]
Debug
PL/SQL code
__
Set
breakpoints in code
__
Step
through code
__
View
variable values while form is running
Adding
Functionality to Items
[ ]
Describe
item interaction triggers
[ ]
Supplement
the functionality of input items by using triggers and built-ins
__
Code
interactions with radio groups
__
Code
interactions with check boxes
__
Change
list items at run time
__
Display
an LOV from a button
[ ]
Supplement
the functionality of noninput items by using triggers and built-ins
__
Populate
image items
__
Populate
hierarchical trees
__
Code
interactions with JavaBeans in the bean area item
Run
Time Messages and Alerts
[ ]
Describe
the default messaging behavior of a form
[ ]
Handle
run time failure of built-in subprograms
[ ]
Describe
the different types of Forms Builder messages
[ ]
Cause
a trigger to fail in a controlled manner
[ ]
Control
system messages
[ ]
Create
and control alerts
[ ]
Handle
database server errors
Query
Triggers
[ ]
Explain
the processes involved in querying a data block
[ ]
Describe
query triggers and their scope
[ ]
Control
query array processing
[ ]
Write
triggers to modify query behavior
[ ]
Control
trigger action based on the form's query status
[ ]
Obtain
query information at run time
Validation
[ ]
Describe
the validation process
[ ]
Control
validation:
__
Using
object properties
__
Explain
the effects of the validation unit upon a form
__
Use
an LOV for validation
__
Using
triggers
__
Using
Pluggable Java Components
[ ]
Describe
how Forms tracks validation status
[ ]
Control
when validation occurs
Navigation
[ ]
Describe
how navigation affects the navigation unit and the cursor
[ ]
Distinguish
between internal and external navigation
[ ]
Control
navigation with properties
[ ]
Describe
and use navigation triggers to control navigation
[ ]
Explain how the cursor can become stuck between two items, resulting in a navigation trap
[ ]
Use
navigation built-ins in triggers
Transaction
Processing
[ ]
Explain
the process used by Forms to apply changes to the database
[ ]
Describe
the commit sequence of events
[ ]
Describe
the characteristics and uses of commit triggers
[ ]
Supplement
transaction processing
__
Perform
delete validation
__
Allocate
sequence numbers to records as they are applied to tables
__
Keep
an audit trail
[ ]
Test
the results of trigger DML
[ ]
Override
default transaction processing
[ ]
Describe
how to run against a non-Oracle data source
[ ]
Get
and set the commit status
[ ]
Implement
array DML
Writing
Flexible Code
[ ]
Describe
flexible code
[ ]
Use
system variables to determine:
__
Cursor
focus
__
Trigger
focus
__
Commit
status
[ ]
Describe
built-in subprograms that assist flexible coding
Write
code to reference objects:
__
By
internal ID
__
Indirectly
Sharing
Objects and Code
[ ]
Describe
benefits of reusing objects and code
[ ]
Create
and use property classes
__
Describe
property classes
__
Create
property classes
__
Add
properties to property classes
__
Inherit
properties from property classes
__
Explain
the inheritance symbols in the Property Palette
[ ]
Group
related objects for reuse
[ ]
Copy
and subclass objects
[ ]
Reuse
objects from an object library
__
Describe
object libraries
__
Describe
the benefits of using object libraries
__
Create
object libraries
__
Populate object libraries
__
Modify objects in an object library
__
Create and use SmartClasses
[ ]
Reuse PL/SQL code
Introducing
Multiple Form Applications
[ ]
Describe
the characteristics of multiple form applications
[ ]
Describe
the benefits of multiple form applications
[ ]
Call
one form from another form module
[ ]
Define
multiple form functionality
[ ]
Share
data among open forms
[ ]
Control
opening and closing of multiple forms
[ ]
Synchronize
data among multiple forms
Creating
a Menu Module
[ ]
Describe
the different components of a menu module
[ ]
Create,
save and attach menu modules
[ ]
Set
menu properties using the Property Palette
[ ]
Create
menu toolbars
[ ]
Create
pop-up menus
Managing
Menu Modules
[ ]
Control
menus programmatically
[ ]
Manage
the interaction between the menu and form documents
[ ]
Implement
application security through the menu
Programming
Function Keys
[ ]
Define
key triggers and their uses
[ ]
Program
function keys
[ ]
Describe
the characteristics of key triggers
[ ]
Classify
key triggers
[ ]
Associate
function keys with interface controls
Building
Multiple Form Applications
[ ]
Describe
the various ways of invoking additional forms modules
[ ]
Open
and close form modules
[ ]
Navigate
between form modules
[ ]
Control
open form modules
[ ]
Choose
the most appropriate method for invoking forms
Defining
Data Sources
[ ]
Describe
the various datasource types
[ ]
Base
a data block on a FROM clause query
[ ]
Discuss
the advantages of using a FROM clause query
[ ]
Base
a data block on a stored procedure that returns a REF cursor
[ ]
Return
a table of records from a stored procedure
[ ]
Define
a Data Source with the Data Block Wizard
[ ]
Select
the appropriate data source for a data block
Working
with Record Groups
[ ]
Describe
the record group object
[ ]
Use
record groups
[ ]
Define
record groups at design time
[ ]
Control
record groups by using built-in functions
[ ]
Define
query record groups programmatically and nonprogrammatically
[ ]
Manipulate
record group rows
[ ]
Define
lists of values (LOVs) programmatically
[ ]
Implement
dynamic list items and add values to combo boxes
Using
Database Objects in Forms Applications
[ ]
Recognize
which object types are supported
[ ]
Describe
how object types are represented within Form Builder
[ ]
Create
a block based on relation table with an object or an REF column
[ ]
Populate
a REF column with an LOV
Oracle Certification Program Fraudulent Activity Policy
Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.
If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate's Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate's employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle's authorized vendors, and may be required to pay additional fees for services rendered.
View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.