About Exam

Exam number/code: 1Z0-132
Exam name: Oracle9i, Build Internet Applications II
Exam no. of questions: 60 Questions
Duration: 90 minutes
Passing score: 77%
Question types: Multiple choice questions (MCQ's), Multiple choice single answer, Multiple choice multiple answer, Drag and drop & Simulations (optional)

• Creating a Menu Module
• Managing Menu Modules
• Programming Function Keys
• Responding to Mouse Events
• Controlling Windows and Canvases Programmatically
• Defining Data Sources
• Working with Oracle8 Objects in Forms Developer
• Controlling Data Block Relationships
• Building Multiple Form Applications
• Working with Record Groups
• Including Charts and Reports
• Applying Timers
• Using Server Features in Forms Developer
• Using Reusable Components

Exam Objectives

Creating a Menu Module

• Identify the components of a menu
• Create, save, and attach menu modules
• Set menu properties using the Property Palette
• Create menu toolbars
• Create pop-up menus

Managing Menu Modules

• Control the menu programmatically using menu built-ins
• Implement menu security using both database roles and the appropriate built-ins

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

Responding to Mouse Events

• Describe mouse events
• Cause a form module to respond to mouse movement

Controlling Windows and Canvases Programmatically

• Display a form document in multiple windows
• Write code to interact with windows
• Manipulate windows programmatically
• Manipulate canvas-views programmatically
• Use large data blocks

Defining Data Sources

• Describe the various data source types
• Base a data block on a FROM clause query
• Describe the advantages of using a FROM clause query
• Base a data block on a stored procedure
• Return a REF cursor from a stored procedure
• Return a table of records from a stored procedure
• Select the appropriate data source for a data block

Working with Oracle8 Objects in Forms Developer

• Recognize which object types are supported
• Describe how object types are represented within Oracle Forms Developer
• Create a block based on an object table
• Create a block based on a relation table with an object or a REF column
• Populate a REF column with an LOV

Controlling Data Block Relationships

• Define block coordination
• Coordinate data blocks by using REF relations
• Describe the characteristics and principles of relation- handling code
• Implement a coordination- type toggle
• Force one commit per master record

Building Multiple Form Applications

• Describe the different ways of invoking additional forms
• Open, call, and close forms
• Navigate between forms
• Control opened forms and called forms
• Manage transaction processing for opened forms and called forms
• Choose the most appropriate method for invoking forms
• Pass form parameters

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
• Define nonquery record groups programmatically
• Manipulate record group rows
• Define lists of values (LOVs) programmatically
• Manipulate list items programmatically
• Implement dynamic list items
• Add values to combo boxes

Including Charts and Reports

• Include charts in an application
• Include reports in an application

Applying Timers

• Describe timers
• Create a timer
• Modify a timer
• Delete a timer
• Handle timer expiration

Using Server Features in Forms Developer

• Use Oracle server functionalities in forms
• Deal with server-side PL/SQL
• Recognize w