A user has requested a change to the Summit.fmb module. The form has two windows, DEPT_WIN and EMP_WIN. DEPT_WIN is always visible to the user. However, EMP_WIN is only occasionally required to be opened. The user complains that once EMP_WIN is open, it is not possible to make the window invisible. The user can navigate between the open windows. You are asked NOT to write code to close EMP_WIN explicitly. What changes should you make to the Summit form?

The DBA informed you that a number column called ORDER_STATUS has been added to the ORDERS table. You want to update the Order Entry form to display the additional data. You open the Layout Editor for the canvas on which items from the Customers, Orders, and Order_Items blocks are displayed. You use the text item tool to create a new text item on the canvas, open its Property Palette, and set the Name property to ORDER_STATUS as well as the Column Name property to Order_Status. When you run the form to test it, the error 'FRM 40505 ORACLE error unable to perform query' crops up? What could be the cause of this error?

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?

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?

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?

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

You create the following four menu items for the main menu of a menu module that is attache=d to a form: Name Label ENTER_QUERY ENTER QUERY EXECUTE_QUERY EXECUTE &QUERY EDIT Edi&t EXIT eXit Which menu item is invoked when a user presses Alt + E at run time?

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?

Which statements are correct with regard to FORM_TRIGGER_FAILURE?

Which statements define a Static Record Group?

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?