Oracle 1z1-151 Actual PDF : Oracle Fusion Middleware 11g: Build Applications with Oracle Forms

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. in the other forms, refer to the record group as: global.warehouse_rg.
• B. in the 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. in the When-New-Form-instance trigger for the entry form, add a values for the SCOPE argument of CREATE_GROUP_QUERY.
• D. in the 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.
• E. in the When-Button_Pressed triggers of the entry from the buttons that open other forms, add a value for the SESSION argument of OPEN_FORM.

View the Exhibit.

The Summit menu is attached to the Orders form. The Toggle Autoquery menu item is a check box that toggles whether a query is automatically performed when the Orders form is first invoked. If the check box is deselected, users must manually query.
In addition to using the menu, users want to be able to toggle the autoquery preference directly from the form. You add a button named Toggle Autoquery with the following When- Button-Pressed trigger:
DECLARE
mi_id MENUITEMS;
BEGIN
mi_id ;=FIND_ITEM ('Preferences.AutoQuery')
/* Determine the current checked static of the AutoCommit menu checkbox item And toggle the checked state*/ IF GET_ITEM_PROPERTY (mi_id, CHECKED) = 'TRUE' THEN SET_ITEM_PROPERTY (mi_id, CHECKED, PROPERTY_FALSE); ELSE SET_ITEM_PROPERTY (mi_id, CHECKED, PROPERTY_TRUE); END IF; END; However, the trigger does not compile. What three changes must you make so that the trigger compiles successfully?

• A. Change PROPERTY_FALSE to 'FALSE'.
• B. Change PROPERTY_TRUE to 'TRUE'.
• C. Change 'preferences.AutoQuery' to 'AutoQuery'.
• D. Change FIND_ITEM to FIND_MENU_ITEM.
• E. Change 'preferences.AutoQuery' to 'AUTOQUERY'.
• F. Change 'preferences.AutoQuery' to 'orders.preferences.AutoQuery'.
• G. Change GET_ITEM_PROPERTY to GET_MENU_ITEM_PROPERTY
• H. Change 'preferences.AutoQuery' to 'ORDERS.PREFERENCES>AUTOQUERY'.
• I. Change SET_ITEM_PROPERTY to SET_MENU_ITEM_PROPERTY

There are certain errors that are specific to the Salary item on the Employees form. You want to trap these errors only when the user navigates from the Salary item.
You have a form-level On-Error trigger that traps errors that apply to the form in general, but yon additionally code an item-level On-Error trigger for the Salary item.
When testing the form, you find that the general errors are not trapped when you navigate from the Salary item. What can you do to correct this problem?

• A. Change the Execution Hierarchy property for the form-level On-Error trigger.
• B. Call the form level On-Error trigger from the item-level On-Error trigger.
• C. Call the item-level On-Error trigger from the form-level On-Error trigger.
• D. Move all the code to a PL/SQL program unit and call it from both the form level and item level On-Error triggers.
• E. Change the Execution Hierarchy property for the item-level On-Error trigger.

The Orders form, you want to enable users to use Microsoft Excel to create and print an invoice for the customer. The file should be created on the user's computer so that it can be printed with the local printer.
Which WebUtil package would you use to implement this requirement?

• A. CLIENT_TEXT_IO
• B. WEBUTIL_FILE
• C. CLIENT_GET_FILE_NAME
• D. CLIENT_Win_API
• E. CLIENT_HOST
• F. CLIENT_OLE2
• G. WEBUTIL_UTIL

View the Exhibit.

You have begun the process of integrating WebUtil into the Ordes form. What two additional steps must be completed yet?

• A. Write a Pre Form trigger to register WebUtil JavaBeans.
• B. Define WebUtil events that the form listens and responds to.
• C. Attach the WebUtil PL/SQL library to the form.
• D. Move the WebUtil data block to the first position under the Data Blocks node in the Object Navigator.
• E. Subclass the webUtilConfig parameter from the WebUtil object library into the form.
• F. Move the WebUtil data block to the last position under the Data Blocks node in the Object Navigator.