Which of the following 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 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?

You are creating an application on a Windows PC. You want to test a form. How would you start an OC4J instance on the PC?

In the Human Resource form, you created a LOV based on a record group. The record group query selects the job title and job ID from the JOBS table that contains the following records: JOB_TITLE JOB_ID Accountant FI_ACCOUNT Accounting Manager AC_MGR Administration AD_ASST Assistant President AD_PRES Programmer IT_PROG Public Accountant AC_ACCOUNT Purchasing Clerk PU_CLERK Purchasing Manager PU_MAN Sales Manager SA_MAN Sales Representative SA_REP The Job_ID value is returned to the Employees.Job_Id item in the form. You attach the LOV to the Job_ID item and set its Validate property from List property to Yes. You run the form to test it. You enter 'Pro' (without the quotes) into the Job_ID item. What is the behavior when you press the Tab key?

Your colleague created a list item that will be populated at run time by the JOBS Record Group. JOBS is populated from the EMP table using one or more of the following three columns: SAL column, whose data type is number TITLE column, whose data type is varchar2 JOB column, whose data type is varchar2 Assuming that any variables used are properly declared, which built-ins can you to create JOBS?

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?

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?

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?

You created a query Record Group at design time. Which built-in can you use to execute the query defined in the Record Group object?

There is a requirement to invoke the Orders form from the Customers form. Your colleagues offer some suggestions regarding their choice of built-in to be used. They also give the reasons for their respective choices. Which of the following suggestions names a built-in that will meet the requirements and also offers a correct reason?