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 'preferences.AutoQuery' to 'ORDERS.PREFERENCES>AUTOQUERY'.
• B. Change PROPERTY_TRUE to 'TRUE'.
• C. Change 'preferences.AutoQuery' to 'orders.preferences.AutoQuery'.
• D. Change PROPERTY_FALSE to 'FALSE'.
• E. Change 'preferences.AutoQuery' to 'AUTOQUERY'.
• F. Change SET_ITEM_PROPERTY to SET_MENU_ITEM_PROPERTY
• G. Change 'preferences.AutoQuery' to 'AutoQuery'.
• H. Change FIND_ITEM to FIND_MENU_ITEM.
• I. Change GET_ITEM_PROPERTY to GET_MENU_ITEM_PROPERTY

You have a form that called a database stored procedure. You do not want processing to continue, so immediately after the call to the stored procedure, you add the following code:
IF NOT FORM_SUCCESS THEN
MESSAGE ('Stored Procedure failure');
RAISE FORM_TRIGGER_FAILURE;
END IF;
You test the code and input some data that intentionally causes the stored procedure to fail. However, the message that you defined does not appear. What are two possible reasons for this?

• A. You must test for FORM_FATAL when testing for failure of a stored procedure.
• B. You must test for FORM_FAILURE when testing for failure of a stored procedure.
• C. You cannot test for failure of a stored procedure, because database errors are transparent to Forms.
• D. FORM_SUCCESS tests for failure of Forms built-ins, not stored procedures.
• E. You must handle database errors in an exception clause of the trigger.

View the Exhibit.

Iin the Human Resources form shown in the Exhibit, you want to modify the prompts, heights, and widths of the Department Id, Manager Id, and Location Id Holds in the Departments data block.
What must you select before invoking the Layout Wizard in reentrant mode to modify these item properties?

• A. the DEPARTMENT_ID, MANAGER_ID and LOCATION_ID items
• B. the Departments block
• C. Frames
• D. Canvas4
• E. Frame5

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

The Orders application enables the Orders form to be opened from the Customers form.
Users are confused because when they save a new or changed order, they sometimes receive an error message that indicates that no changes have been made.
What could be the possible cause of this problem?

• A. The Orders form is opened in NO_ACTIVATE mode.
• B. The Orders form is opened in ACTIVATE mode.
• C. The Orders form is opened in a different session from the Customers form.
• D. The trigger that opens the Orders form calls COMMIT_FORM after open form.
• E. The Orders form is Opened in the same session as the Customers form.