1Z0-151 Oracle Fusion Middleware 11g: Build Applications with Oracle Forms

Exam Title: Oracle Fusion Middleware 11g: Build Applications with Oracle Forms
Exam Number: 1Z0-151
Exam Price: $245.00 More on exam pricing
Format: Multiple Choice
Duration: 135 minutes
Number of Questions: 80
Passing Score: 65%
Validated Against: This exam has been validated against 11g.

Take Recommended Training Courses

Complete one of the courses below to prepare for your exam (optional):

Oracle Fusion Middleware 11g: Build Applications with Oracle Forms

Additional Preparation and Information

A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.

Not available at this time

Introduction to Oracle Forms Builder and Oracle Forms Services
Describe the components of Oracle Fusion Middleware 11g
Describe the features and benefits of Oracle Forms Services and Oracle Forms Builder
Describe the architecture of Oracle Forms Services
Describe the course application

Working in the Forms Builder Environment
Describe Forms Builder components
Navigate the Forms Builder interface
Identify the main objects in a form module
Customize the Forms Builder sessionUse the online help facilities
Use the online help facilities
Identify the main Forms executables
Describe the form module types
Set environment variables for design and run time
Run a form from within Forms Builder

Creating a Master-Detail Form
Create data blocks that have relationships with one another
Run a master-detail form module
Modify a data block
Modify the layout of a data block

Working with Text Items
Describe text items
Create a text item
Modify the appearance of a text item
Control the data in a text item
Alter the navigational behavior of a text item
Enhance the relationship between the text item and the database
Add functionality to a text itemDisplay helpful messages
Enhance the relationship between the text item and the database

Creating Additional Input Items
Identify the item types that allow input
Create a check box
Create a list item
Create a radio group

Creating Windows and Content Canvases
Describe the relationship between windows and content canvases
Create windows and content canvases
Display a form module in multiple windows
Display a form module on multiple layouts

Introduction to Triggers
Describe triggers
Identify the different trigger categories
Plan the type and scope of triggers in a form
Explain how trigger properties affect trigger behavior

Debugging Triggers
Describe the components of the debug console
Use the Run Form Debug button to run a form module in debug mode
Explain how to use remote debugging
Debug PL/SQL code

Run-Time Messages and Alerts
Describe the default messaging behavior of a form
Handle run-time failure of built-in subprograms
Identify the different types of forms messages
Control system messages
Create and control alerts
Handle database server errors

Validation
Explain the effects of the validation unit upon a form
Control validation
Describe how Forms tracks validation status
Control when validation occurs

Transaction Processing
Explain the process used by Forms to apply changes to the database
Describe the commit sequence of events
Supplement transaction processing
Allocate sequence numbers to records as they are applied to tables
Implement array data manipulation language (DML)

Sharing Objects and Code
Describe the various methods for reusing objects and code
Inherit properties from property classes
Group related objects for reuse
Explain the inheritance symbols in the Property Palette
Reuse objects from an object library
Reuse PL/SQL code

Introducing Multiple Form Applications
Call one form module from another
Define multiple form functionality
Share data among open forms

Managing Menu Modules
Control menus programmatically
Manage the interaction between the menu and form documents
Implement application security through the menu

Running an Oracle Forms Application
Start WebLogic Server
Describe the run-time environment
Describe the elements in a running form
Navigate a Forms applicatio
Describe the two main modes of operation
Run a form in a Web browser
Retrieve both restricted and unrestricted data
Insert, update, and delete records
Display database errors

Creating a Basic Form Module
Create a form module
Create a data block
Save and run a form module
Identify form file formats and their characteristics
Describe how to deploy a Forms application
Explain how to create documentatoin for a Forms application

Working with Data Blocks and Frames
Identify the components of the Property Palette
Manage object propertiesCreate and use Visual Attributes
Control the behavior and appearance of data blocks
Control frame properties
Create data blocks that do not directly correspond to database tables
Delete data blocks and their components

Creating LOVs and Editors
Describe LOVs and editors
Design, create, and associate LOVs with text items in a form
Create editors and associate them with text items in a form

Creating Noninput Items
Identify 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 ite
Create a bean area ite

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

Producing Triggers
Write trigger code
Explain the use of built-in subprograms in Forms applications
Describe the When-Button-Pressed trigger
Describe the When-Window-Closed trigger

Adding Functionality to Items
Supplement the functionality of input items by using triggers and built-ins
Supplement the functionality of noninput items by using triggers and built-ins

Query Triggers
Explain the processes involved in querying a data block
Describe query triggers and their scope
Write triggers to screen query conditions
Write triggers to supplement query results
Control trigger action based on the form’s query status

Navigation
Distinguish between internal and external navigation
Control navigation with properties
Describe and use navigation triggers
Use navigation built-ins in triggers

Writing Flexible Code
Describe flexible code
Explain the advantages of using system variables
Identify built-in subprograms that assist flexible coding
Write code to reference objects

Using WebUtil to Interact with the Client
Describe the benefits of the WebUtil utility
Integrate WebUtil into a form
Use WebUtil to interact with the client machine

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

QUESTION 2
When tabbing through items in the Employees form, users should not be able to navigate to the
Salary text item. If they need to update the item, they will have to explicitly navigate to it by using
the mouse.
Which property setting accomplishes this requirement?

A. Enabled = Yes; Keyboard Navigable = No
B. Enabled = No; Keyboard Navigable = Yes
C. Enabled = Yes; Keyboard Navigable = Yes
D. Enabled = No; Keyboard Navigable = No
E. Automatic Skip = Yes

Answer: C

Explanation: * Keyboard Navigable property
Description
Determines whether the end user or the application can place the input focus in the item during
default navigation. When set to Yes for an item, the item is navigable. When set to No, Form
Builder skips over the item and enters the next navigable item in the default navigation sequence.
The default navigation sequence for items is defined by the order of items in the Object Navigator.
Applies to all items except chart items and display items
* Default
Yes
Usage Notes
If Enabled or Visible is set to No (PROPERTY_FALSE for runtime), then the items’ or item
instance’s Keyboard navigable property is effectively false. At runtime, when the Enabled property
is set to PROPERTY_FALSE, the Keyboard_Navigable property is also set to
PROPERTY_FALSE. However, if the Enabled property is subsequently set back to
PROPERTY_TRUE, the keyboard Navigable property is NOT set to PROPERTY_TRUE, and
must be changed explicitly.

QUESTION 3
You have a text item in your form named Object1. You want to create Object2 as an exact
duplicate of Object1. You want to be able to change the properties of Object2. However if you
change Object1, you do not want Object2 to change.
Which method of reusing Object1 would be best for these requirements?

A. Copying Object1
B. Subclassing Object1
C. Creating a property class from Object1
D. Putting Object1inan Object library
E. Referencing Object1ina PL/SQL library

Answer: A

Explanation: When you copy an object, a separate, unique version of that object is created in the
target module. Any objects owned by the copied object also get copied. Changes made to a
copied object in the source module do not affect the copied object in the target module.

QUESTION 4
The Orders form has four blocks. The Orders and Order_items block are on the CV_Order content
canvas; the inventories block items are on the CV_inventories content canvas; and Control block
buttons are on the CV_Buttons toolbar canvas. All buttons have mouse Navigate set to No.
The Order_Items block is a detail of Orders. The inventories block is a detail of Order_Items,
showing the stock of the selected product.
There is a button in the Control block with a When-Button-Pressed trigger:
IF GET_CANVAS_PROPERTY(:SYSTEM.cursor_item, item_canvas) = ‘CV_ORDER’ THEN
GO_BLOCK (‘inventories’)
ELSE
GO_BLOCK(‘orders’);
END IF;
When you run the form and click the button, navigation does not occur, and the form displays the
runtime error “FRM-41053: Cannot find Canvas: invalid ID.” What should you do to correct this
problem?

A. Change the sequence of blocksinthe Object Navigator
B. Chang the Mouse Navigator property of the button to yes
C. inthe first line of code, change the built-into GET_ITEM_PROPERTY
D. inthe first line of code, change the system variable to: SYSTEM.CURSOR_CANVAS.
E. inthe first line of code, change the CV_ORDER to lowercase
F. Chang the argument to the GO_BLOCK built-ins to uppercase

Answer: D

Explanation:
Note:
GET_CANVAS_PROPERTY built-in
Description
Returns the given canvas property for the given canvas. .
Syntax
FUNCTION GET_CANVAS_PROPERTY(
canvas_id
Canvas
,property
NUMBER);FUNCTION GET_CANVAS_PROPERTY(
canvas_name
VARCHAR2
,property
NUMBER)

QUESTION 5
Which four types of variables must have their names preceded by a colon when they are
referenced in trigger code?

A. PL/SQL variables
B. Form items
C. global variables
D. system variables
E. parameters

Answer: A,B,C,D

Explanation:
D: Example:
On calling the
raiseEvent method, a trigger named WHEN-CUSTOM-JAVASCRIPT-EVENT is fired
on the server side.
declare
event_val varchar2(300):= :system.javascript_event_value;
begin
if (:system.javascript_event_name=’show’) then
handleShowEvent(event_val);
elsif(:system.javascript_event_name=’grab’) then
handleGrabEvent(event_val);
else
null;
end if;
end;

QUESTION 6
The Order Entry application contains several forms. The inventories form uses an LOV that is
based on a record group that queries the Warehouses table to return a warehouse ID.
Several of the forms use LOVs that are based on the same query. You decide to centralize the
creation of the record group to the entry form of the application, which opens all the other forms,
for example, to open the inventories form, there is a When-Button Pressed trigger on the
inventories button with the following code;
OPEN _FORM (‘inventories’);
in a When-New-Form-instance trigger for the entry form, you create the warehouse_rg record
group by using the CREATE_GROUP_QUERY built in with the following arguments:
(‘warehouse_rg’ , ‘SELECT ALL WAREHOUSE.WAREHOUSE_ID,
WAREHOUSE.WAREHOUSE_NAME FORM WAREHOUSE order by warehouse_name);
You also populate the record group in this trigger.
What must you do to make this record group available to the inventories form and the other forms?

A. inthe When-New-Form-instance trigger for the entry form, add a values for the SCOPE
argument of CREATE_GROUP_QUERY.
B. inthe entry form, move the record group code to the end of the When-Button-Pressed triggers
for the buttons that open other forms, so that the record group is created and populated
immediately after OPEN_FORM is called.
C. inthe entry form, move the record group code to the beginning of the When-Button-Pressed
triggers for the button that open other forms, so that the record group is created and populated just
before OPEN_FORM is called.
D. inthe When-Button_Pressed triggers of the entry from the buttons that open other forms, add a
value for the SESSION argument of OPEN_FORM.
E. inthe other forms, refer to the record group as: global.warehouse_rg.

Answer: A

Explanation:
Note: The CREATE_GROUP_FROM_QUERY built-in is a function and must be invoked as part of
an expression. For example:
DECLARErg_id RecordGroup;BEGIN
rg_id := CREATE_GROUP_FROM_QUERY (’employee_rg’, ‘SELECT id,first_name,last_name,sal
FROM employee’);
END;

Click here to view complete Q&A of 1Z0-151 exam
Certkingdom Review, Certkingdom PDF Torrents