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

The Employees database table contains more columns than can be displayed at one time in a form. You create a data block that uses all the columns. How can you enable users to interact with all the items and switch between them without scrolling or closing anything?

You have designed a form with two content canvases. The window for the first canvas was created implicitly, and you have not changed its default properties.
You want users to be able to navigate between the canvases easily while viewing both simultaneously. Therefore, you create a second window, changing only its name from the default properties.
However, when you test the form, you find that you are unable to close either window. What must you do to provide this functionality?

Identify a function of the Forms Servlet.

Your company applies three different interest rates for customers based on their credit rating, which is classified as being Excellent, Fair, Poor or Unknown.
In the years past, clerks entered credit ratings manually, which resulted in some of them being mistyped. To improve data entry accuracy you modify the Customers form so that the Credit_Rating item is a static list item that allows only those four values.
Users report to you that some of the customer records can no longer be accessed when they use the modified Customers form. How can you fix this problem?

A user at a remote location reports a problem that occurs when the Orders; form runs and the user clicks the invoice button. You are not able to reproduce the
problem, so you decide to use remote debugging.

The steps involved in diagnosing the problem are listed below, but they are ordered incorrectly. What is the correct sequence of Steps?
1. You set a breakpoint in the When Button-Pressed trigger for the invoice button.
2. The user's screen goes blank.
3. The user reports the host and port to you.
4. You uses the debugger to step through the code.
5. The user clicks a button that calls DEBUG.ATTACH.
6. You attach to the user's process.
7. You open the Orders.fmb file from which the running .fmx was generated.
8. The user clicks the invoice button.

You wish to use a javaBean in a form. This javaBean has no visible component.
You use the Layout Editor to create a bean area item that implements this JavaBean. You want to be able to see the bean area item in the Layout Editor so that you  can easily interact with it at design time.
What can you do to ensure that the bean area item does not appear on the form at run time?

You have a form that called a database stored procedure. You do not want processing to continue, so immediately after the call to the stored procedure, you add the following code: IF NOT FORM_SUCCESS THEN MESSAGE ('Stored Procedure failure'); RAISE FORM_TRIGGER_FAILURE; END IF; You test the code and input some data that intentionally causes the stored procedure to fail. However, the message that you defined does not appear. What are two possible reasons for this?

You want to use the Forms Debugger to diagnose a problem with the RAISE_STATUS program unit that is stored in the database.
Forms Builder, you set a breakpoint in the stored code, and then run the Human Resources form in debug mode. You click the Raise_Salaries button, which has a
When Button Pressed trigger that calls RAISE_SALARIES.
However, you are unable to see the RAISE_SALARIES procedure when you step through the code, and it does not appear in the stack frame. What could be the reason for this problem?

The Orders form has the following triggers defined:
1. Post-Text-Item on Customer_Id
2. Pre-Text-Item on Sales_Rep_Id
3. When-New-Item-instance on Sales_Rep_Id
The form's Validation Unit property is set to Record.
When the user navigates from Customer_Id to Sales_Rep_Id, which triggers fire and what is the sequence?

Which statement is always true about a visual indicator that a text item has a list of values associated with it?