Oracle Forms Build Internet Applications Set 2

You need a field on the Orders form that shows a description of the product being ordered. This field must not be updated directly by the user. Instead, double-clicking in the field should invoke another form where a change can be made.
How can you achieve this?

You have an image item in the Employees form to display an employee photograph, and you are trying to decide where to place some code to manipulate the image item.
If you place the code in a When-Image-Activated trigger, when will the code be executed?

LibraryA and LibraryB are in the working directory of the Employees form. LibraryA is attached to the Employees form. There is a stored procedure in the database called Raise_Salary which must be called without
any parameters. There is no Raise_Salary procedure in the form or in the attached library. A When-Button-Pressed trigger in the Employees form contains this code: raise_salary;
Where does Forms search for the Raise_Salary procedure?

The Products.fmb module has one content canvas, which displays information about products sold by your company. You want to increase the canvas display area by creating an overlay canvas to enable images of selected products to be displayed on request.
How can you size the display area of the overlay canvas?

The Orders.fmb module contains two content canvases, both associated with the default window. Items from the DEPT data block are associated with the DEPTCAN canvas. Items from the EMP data block are associated
with the EMPCAN canvas. The user wants to view DEPT and EMP data at the same time.
What changes would you make to the Orders form?

In the Orders form, users are able to change the status of an Order. Options are HOLD, SHIP and CANCEL, and each option is represented individually in the Layout Editor.
These options are sized and positioned independently of one another, they are mutually exclusive by default. When a new order status is selected, the ORDER_AUDIT_LOG table must be updated by the first trigger to register the changed value.
Which trigger should you select?

The Orders table in the database contains several thousand records. There is a block in the Orders form that is based on the ORDERS table and displays one record. The block is ordered by the Order_Date in descending
order, because order entry clerks usually must access only the most recent orders. Which one of the following combinations of property settings for the Orders block will provide the fastest response time before a record appears in the block upon executing a query?

You need to resize the INVENTORY tab canvas. The Viewport Width and Height properties are 200 and 300. You change the values to 150 and 120, respectively.
What implication may this have on your design?

Which statement about object libraries is true?

The DBA informed you that a number column called ORDER_STATUS has been added to the ORDERS table.
The DBA ran a SQL script to populate that column.
You want to update the Orders form to display the additional data. You currently have a non-base-table display item in the Orders block called Order_Total that you no longer want to use. The Order_Total item is located on
the canvas in the position where you want the Order_Status item to appear. You open the Property Palette for
Order_Total, change its name to Order_Staus, and change its item type to Text Item.
You run the form, but when you execute a query on the block, no data is displayed in the Order_Status item.
What should you do to correct this problem?