Oracle Fusion Middleware 11g Build Applications with Oracle Forms Set 1

You want to display employee records in tabular format, but the form is not wide enough to display all the items in the Employees block. The employee IDs and names of displayed records should always be visible, but you want to scroll the additional information as users tab through the Items, the form should look like a spreadsheet with the first two columns frozen.
Which canvas types would be most appropriate in this scenario?

You have created a complex menu structure with several types of menu objects. To which objects would you assign menu commands?

To avoid overloading the database during busy times, you decide to restrict the queries that are executed on the Orders form so that users query by either Order ID or Customer ID during these times. Which trigger is most appropriate for the code to enforce this restriction?

You have created an editor named MyEditor, and you want it to be available to edit the text item Product_Description. You can associate the editor with the text item by setting the Editor property of Product_Description to MyEditor.

The Orders form is sometimes run automatically and sometimes run from the Customers form, when it is run from the Customers form, any queries should be restricted to the customer that is currently selected. The Customers form button that runs the Orders form sets a global variable to the current customer ID.
The Orders form has a button labeled Execute Query with the following When-Button Pressed trigger:
DEFAULT_VALUE (NULL, 'GLOBAL.Customer_id');

IF: GLOBAL.customer_id IS NOT NULL
THEN
SET_BLOCK_PROPERTY ('orders', DEFAULT_WHERE, 'orders.customer_id =
' | | :GLOBAL.CUSTOMER_id);
END IF;
EXECUTE_QUERY
You want to duplicate that functionality in a menu item for the Summit menu that is attached To the Orders form.
What changes must you make to the code so that the menu code functions as it does in the form?

You are planning the alerts that are needed for your Human Resources application. You wish to display the following in alerts:
* A message to inform the user about being at the just record
* A warning about a potential conflict with the data just entered
* A message to display a validation error to the user
* A warning that the salary is out of range and that asks whether the user wants to correct it
You want the note symbol ( ) to appear on alerts that display only informative messages, the warning symbol to appear on messages where you will allow the user
to continue despite some data problem, and the alarm boll symbol to appear where the user will not be allowed to continue without correcting the situation that
caused the alert to be displayed.
You want to define the minimum number of alerts possible and customize them at run time.
Which alerts should you define?

You have installed WebLogic and Forms with a default configuration, which has been tested and determined to be correct.
After creating a basic form in the Forms Builder, you click Run Form to test it. Forms Builder displays an error dialog box with the following message:
FRM-10142: The HTTP Listener is not running on at port 9001.
Please start the listener or check your runtime preferences.
What is one action that you can take to resolve this error?

Which statement is always true about using OPEN_FORM to open multiple forms in an application?

You put some code in a Post_Update trigger and raise the FORM_TRIGGER_FAILURE under certain conditions. Does a rollback take place if the trigger falls?

You are coding a When-Checkbox-Changed trigger.
Which statements are available for use in your code?