This preview shows page 1. Sign up to view the full content.
Unformatted text preview: the query data source name query data source column and query data source
property to create a stored procedure that uses a REF cursor.
E. Launch the data block wizard. Select stored procedure as the data source type and base
the block on the procedure.
Explanation : Stored Procedures can use REF Cursors and they can be the source for the data
block. To set that use the data block wizard and select the specified stored procedure as the
data source and base the block on the procedure.
Which built-in can you use to replace the associated query of a record group? Actualtests.com - The Power of Knowing 1Z0-131
The POPULATE_GROUP_WITH_QUERY built-in populates the record group with a new
return_code := POPULATE_GROUP_FROM_QUERY ('customers', 'SELECT id, name
FROM customer WHERE state = 'Texas');
Which mouse movement trigger can you use to initiate an action when the cursor
navigates out of the current item?
Explanation : When-Mouse-Leave mouse movement trigger is used to track mouse moving
when moving a way from the object. When-Mouse-Enter is used when mouse enters the area
of the specified object
You need to add an existing chart to the EMP canvas. How would you embed this chart
on the form object?
A. Choose the chart wizard to provide the source file and location on the canvas.
B. Use the chart wizard to provide the data block source for the data.
C. Chose file -> import form the menu, select the source file and position on the canvas.
D. Use the chart item tool in the layout editor to click and drag the location, Choose to
create the chart manually and alter the chart property palette to provide the source file.
Explanation : Embedding a chart object on the form is done by using the chart item tool in Actualtests.com - The Power of Knowing 1Z0-131
the layout editor to click and drag the location. , Choose to create the chart manually and alter
the chart property palette to provide the source file
Which file can be opened to see the structure of the default menu?
Explanation : The MENUDEF.MMB file contains the structure of the default menu that can
be modified. The MMX file holds the executable module of the menu.
Payroll application users wants to be able to save a record by pressing a function key.
They have complained that having to click on the save button with the mouse slows
down data entry. To perform this task you perform a key trigger for the F2 function key
that will save a record when pressed. What affect will this change have on the key
A. This change will have no effect on the key's default functionality because it will
overwrite the trigger.
B. The default functionality is replaced by the PL/SQL code in the trigger defined for the
C. Form will determine if the default functionality of the trigger should have precedence
and you see appropriate one based action performed by the user.
D. Key triggers cannot be used to replace the default functionality of function keys.
Explanation : Function keys can have different functionality by placing PL/SQL code on the
key trigger for the specified function key. When code is written in the trigger it will replace
the default functionality of the function key
You are creating a new project for the payroll application. The legacy application
contains some forms and imports that you want to include in the new application. If you
add an existing .FMB file to this project how can you make sure that .FMX is also
A. Set the option to include implicit items.
B. Generate a new .FMX.
Actualtests.com - The Power of Knowing 1Z0-131
C. You cannot use pre-existing .FMB files.
D. Explicitly identify which pre-existing .FMX is dependent on .FMB.
.fmx - contains the executable code of a form module
.fmb - contains the source code of a form module
If you add an existing .FMB file to the project you should explicitly identify which preexisting
.FMX is dependent on .FMB
You have defined all roles necessary for the payroll application. You still need to do
some testing on the application and want to disable menu roles security temporarily.
Which menu module property should you change?
A. Menu Module Roles.
B. Startup Code.
C. Use Security.
Explanation : The Use Security menu module property enables security check for that menu.
It can be disabled by changing the value of this property in the menu.
You are creating a multiform application and need to pass data between forms. Which
limitation will you have if you use form parameters as means of passing this data?
View Full Document
- Fall '09