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

You add a display item named Quantity to the Order items block of your Orders form to display the quantity on hand for each product. Quantity is a non-base table item that should reflect the count of an ordered product from the inventories table.
What is the best way to populate the Order_Iterns.Quantity item?

• A. Pre Query trigger
• B. Post-Query trigger
• C. When New-Item-instance trigger
• D. You need to define a master-detail relation so that the item is populated automatically.
• E. When-New-Form-instance trigger

You have written a Forms application that your users log in to with their database login.
Which Forms component is utilized first when a user runs the application?

• A. Forms Runtime
• B. Forms Listener Servlet
• C. Forms Client (applet)
• D. Forms Servlet

You are using a PL/SQL program unit in the Orders form to display an image for the selected product in the Order Items block. The code is called from several different triggers in the form. The code (with line numbers added) is:
1. PROCEDURE get_image IS
2. Product_image_id ITEM := FIND_ITEM ('control.product_image');
3. Filename VARCHAR2(250);
4. BEGIN
5. Filename := TO_CHAR(:order_items.product_id) | | '.jpg';
6. READ_IMAGE_FILE (filename, 'jpeg', product_image_id);
7. END;
Management wants all codes to be in PL/SQL libraries to facilitate reuse. You create a PL/SQL library and drag the program unit from the orders form to the Program Units node of the library. You then delete the program unit from the Orders form.
What three things must you do to compile the PL/SQL library and to use the code in the Orders form?

• A. Change line 5 to:
  filename := to_char(name_in 'order_items.product_id' )) | | '.jpg';.
• B. Attach the library to the orders form.
• C. insert the RELEASE keyword between lines 1 and 2.
• D. Change product_id to an in parameter and filename to an OUT parameter.
• E. Save the library.
• F. Generate the a .plx file.
• G. Change the way the program unit is called in the Orders form.
• H. Delete the BEGIN and END statements (lines 4 and 7).