View the Exhibit.The Departments form has form level triggers defined as shown in the Exhibit. You have enabled array DML for the Departments block by setting its DML array size to 5 and setting the Primary Key property of Department id to Yes. You set runtime preferences for Forms Builder to use array processing.You want to test that array processing is actually occurring, so, as shown in the Exhibit, the On-Update, On-Delete, and on insert triggers have code that:1. Displays a message to indicate which trigger is firing for which record?2. Does the thing (either updates, deletes, or inserts)The other triggers simply display a message, indicating the trigger that is firing.You run the form from Forms Builder, but from the messages, you can tell that array processing is not occurring. What should you change so that array DML gets implemented?
You have been assigned to maintain the Orders form. Users complain that if the cursor is in the in the Orders block, they cannot navigate to the Order Items block by clicking a text item in that block. They must click the Next Block button to navigate from the Orders block to the Order Items block.How should you investigate the source of the problem?
You have coded the following When Button Pressed trigger:EXECUTE_QUERY;MESSAGE ('Query executed on block');MESSAGE ('click next to navigate the next record');When the user clicks the button, how is the message "Query executed on block" displayed?
Which two actions are always necessary when deploying Forms applications that were developed on Windows platform to a UNIX middle tier server?
You have written a When-Validate-Item trigger. You want this trigger to fire even if the form is in Enter-Query mode. What must you do to achieve this?
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 IS2. Product_image_id ITEM := FIND_ITEM ('control.product_image');3. Filename VARCHAR2(250);4. BEGIN[1]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 theProgram 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?
