View the Exhibit.

To test how the Orders application works with database triggers, you add to the Orders table the following database trigger that fires before the update of Customer_Id:
BEGIN
If :old.customer_id != : new.customer_id then
RAISE_APPLICATION_ERROR (-20101, 'Database trigger says no!');
end if;
END;
You run the Orders form, change the customer ID, and click Save. You receive the error message "FRM-40509: Oracle error: unable to UPDATE record." You select Help > Display Error, and the Database Error dialog box that is shown in the Exhibit appears.
Which code would you put in your Form-level On-Error trigger to display the ORA- error message instead of the FRM- error message?

• A. IF ERROR_CODE = 06512 THEN
  MESSSAGE(DBMS_ERROR_TEXT);
  END IF;
• B. IF ERROR_CODE = 20101 THEN
  MESSSAGE(SQLERRM);
  END IF;
• C. IF ERROR-CODE = 20101 THEN
  MESSSAGE (DBMS_ERROR_TEXT);
  END IF;
• D. IF ERROR_CODE = 06512 THEN
  MESSSAGE (SQLERRM);
  END IF;
• E. IF ERROR_CODE = 40509 THEN
  MESSSAGE (DBMS_ERROR_TEXT);
  END IF
• F. IF ERROR_CODE = 40509 THEN
  MESSSAGE (SQLERRM);
  END IF;

A clerk is using the Human Resources form, which displays a department and its associated employees on the same canvas. Only two Items in the form are enabled.
Possible navigation units that can occur during navigation of this form are:
1. Outside the form
2. The Human Resources form
3. The Departments block
4. The Employees block
5. The current Departments record
6. The current Employees record
7. The Department_Id item
8. The Employee_Id item
With the cursor in : Departments.Department_Id, the clerk clicks the
:Employees.Employee_Id item.
What is the sequence of navigational unit movement that occurs?

• A. 1, 2, 3, 4, 5, 6, 7, and 8
• B. 7, 5, 3, 2, 4, 6, and 8
• C. 7, 5, 3, 2, 4, 6, and 8 only
• D. 7 and 8 only
• E. 7, 5, 3, 4, 6, and 8 only

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. When-New-Form-instance trigger
• B. Pre Query trigger
• C. You need to define a master-detail relation so that the item is populated automatically.
• D. Post-Query trigger
• E. When New-Item-instance trigger

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?

• A. as an application message on the status line
• B. as a system message in a system alert
• C. as a system message on the status line
• D. as an application message in a system alert
• E. as an application message in an application alert
• F. as a system message in an application alert

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