In the Orders Form you define five LOVs and create one button to be used to display any of the LOVs. The button is enabled only when the user navigates through a field with an attached LOV. If the user supplies only a part of the required input data, LOVs use that input as search criteria to automatically reduce the LOV Contents. If the LOVs hold only one value that can possibly match user-supplied input, the LOVs auto-complete the input field and are not displayed.
Which built-in properties should be used to display the LOVs?

The user must be able to invoke a list of values for valid sales representative in the Orders form. To facilitate this, you created a button and positioned it next to the Sales Rep ID field The text item has these properties set: - Required: Yes - List of Values: SALES_REP_LOV - Validate from List: No The button has these properties set: - Keyboard Navigable: Yes -Mouse Navigate :Yes - Iconic : Yes - Icon Filename :list .ico An appropriate LOV (called SALES_REP_LOV) has been created and associated with the text item. An icon file (list.gif) exists in the appropriate directory. All other properties are left at their defaults. You write a When-Button-Pressed trigger at the item level with this code: LIST_VALUES; To test the form, you attempt to enter a new record. What is the run-time behavior of the form?

The Department form is a part of a multiform application that also includes the Customer and Orders forms. The Department form must include a query-based PRODUCT Record Group. You must ensure that all three forms can access the PRODUCT Record Group. Which built-in will you use to create the PRODUCT Record Group?

Which statements define a Static Record Group?

Which statements are correct with regard to FORM_TRIGGER_FAILURE?

The menu that appears by default in a Forms application does not quite meet your needs, so you decide to create a custom menu. You create and compile a menu module called Test with three submenus that contain PL/SQL code, and attach the Test menu to a form. How will the menu of the form appear and perform at runtime?

You are running a multiple-form application. The Customers Form invoked the Orders Form. When the Orders Form launches, it displays orders for only the active customer from the Customers form. Forms exchange data with the :GLOBAL.CUSTOMER_ID variable. The Orders Form should be restricted to orders for the current customer only the first time a query is issued after invoking the Orders form. Which built-in helps you do this by setting the ONETIME_WHERE property to refer dynamically to the GLOBAL.CUSTOMER_ID?

Which of the following statements is correct with regard to client-side validation?

The Orders form is required to initialize differently for different users. A database procedure (GET_ROLE_NAME) is used to determine which database roles are enabled for the user logging on to the form. If a user has the STORE_CLERK role enabled, certain buttons are disabled and the focus is sent to the Customer_Id text item. If the user has the ADMIN_MGR role enabled, all buttons are available and the focus is sent to the Date_Ordered text item. The buttons are set by a form-level procedure (SET_BUTTONS). The functionality is achieved with this code If get_role_name(USER) = 'STORE_CLERK'THEN set_buttons('STORE_CLERK'); GO_ITEM('ORDERS.Customer_id'); ELSE set_buttons('ADMIN_MGR'); GO_ITEM('ORDERS.Date_Ordered'); END IF; What is the best trigger to execute this code?

You start an OC4J instance on your development PC and then run a form from the Forms Builder. Which of the following statements describes the behavior of OC4J?

You want to create a calculated item in the Control block of the Human Resource form. This item will contain the total of employee salaries for employees in a particular department. Which statement is true about how to create the calculated item?