This preview shows page 1. Sign up to view the full content.
Unformatted text preview: m.
When the called form is exited Form Builder processing resumes in the calling form at the
point from which you initiated the call to CALL_FORM.
The DBA has indicated that lock contention is occurring in the payroll application. To
reduce contention you create a timer that will display an alert prompting the user to
commit a rollback data after they have held a lock for a specified period of time. Which
built-in could you use in a When-Timer-Expired trigger to implement this functionality?
Explanation : SET_TIMER Changes the settings for an existing timer. You can modify the
interval, the repeat parameter, or both. It can be used with SET_APPLICATION_PROPERTY
to get the last timer that was expired. Actualtests.com - The Power of Knowing 1Z0-131
You need to change the text of popup menu that appears when a user right clicks the
mouse in the EMP_DATA block. Where could you find the node for the popup menu in
the object navigator?
A. Built-in packages
C. PL/SQL libraries
D. Object libraries
Explanation : The popup menu node is found in the Form in the Object Navigator.
What is the first step you would take to attack a custom menu module to a form
A. Generate the menu module.
B. Regenerate the form module that the menu will be attached toC. Designate the location of the form module.
Explanation : After building the menu module it needs to generate the menu module to build
the .MMX file then attach the file to the form module.
You are modifying the order entry application and want to disable all function keys that
have not been explicitly defined. Which trigger can you define to accomplish this?
Explanation : A Key-Others trigger fires when an operator presses the associated key.
A Key-Others trigger is associated with all keys that can have key triggers associated with
them but are not currently defined by function key triggers (at any level). A Key-Others
trigger overrides the default behavior of a Runform function key (unless one of the restrictions
apply). When this occurs, however, Form Builder still displays the function key's default
entry in the Keys screen. Actualtests.com - The Power of Knowing 1Z0-131
You are new to the development staff and need to determine the file system location for
a file in a project you are working on. Where can you obtain this information from
within project builder?
A. Property palette.
B. Global registry.
C. User registry.
D. Project view.
Explanation : Project builder save the information about the current projects in the Global
You are creating a general ledger application and want the detain for posted general
applications to be stored in a temporary table before they are committed to the
general_entry table. Which built-in can you use in a pre-commit trigger to create this
Explanation : FORMS_DDL Issues dynamic SQL statements at runtime, including serverside
PL/SQL and DDL. All DDL operations issue an implicit COMMIT and will end the
current transaction without allowing Form Builder to process any pending changes, as well as
losing any locks Form Builder may have acquired.
You have created a customized menu. You want users to be bale to run a SQL report
form menu item without having to provide their username and password. Which two
predefined substitution parameters can you use? (Choose two)
Answer: B, D
Actualtests.com - The Power of Knowing 1Z0-131
Explanation : RUN_PRODUCT can run a SQL report from menu itme. PW and UN are
predefined substitution parameters that you can use.
You need to include a calender class in the orders_entry forms so users can quickly
select a date for the ship_date field. Which trigger could you use to display the calender
when a user invokes the list of values for the ship_date field?
Explanation : KEY-LISTVAL trigger is used to display lists. Calendar class can be
displayed using the KEY-LISTVAL trigger when user invokes the list of values.
You have created a multiform payroll application. Which built-in can you use to
perform navigation between open forms? (Choose three)
Answer: C, D, E
Explanation : CALL_FORM opens the form in modal view and NEW_FORM will hide the
current calling form. GO_FORM, PREVIOUS_FORM and NEXT_FORM can navigate
through an open forms in the application.
You modify the layout of a block using the Layout Wizard. When you are finished, you
notice that there is an additional frame on your canvas and in the Object Navigator.
View Full Document
- Fall '09