Oracle Fusion Middleware 11g: Build Applications with Oracle Forms - 1z0-151 Exam Practice Test

You want to use WebUtil functionality in the Orders form. What three things must you do to integrate WebUtil into the Orders Form?

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?

View the Exhibit.

You are creating a menu for use with several forms. You create the structure of the menu in the Menu Editor.
As shown in the Object Navigator in the Exhibit, which objects are menu items?

Which statement is true about flexible code?

View the Exhibit.

To test how the Orders application works with database triggers, you add to the Orders table the following database trigger that fires before the update of Customer_Id:
BEGIN
If :old.customer_id != : new.customer_id then
RAISE_APPLICATION_ERROR (-20101, 'Database trigger says no!');
end if;
END;
You run the Orders form, change the customer ID, and click Save. You receive the error message "FRM-40509: Oracle error: unable to UPDATE record." You select Help > Display Error, and the Database Error dialog box that is shown in the Exhibit appears.
Which code would you put in your Form-level On-Error trigger to display the ORA- error message instead of the FRM- error message?

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.

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

Which four types of variables must have their names preceded by a colon when they are referenced in trigger code?

You have been assigned to maintain a Forms application that was designed by a developer who has left the company.
The CV_Tools canvas contains several buttons. There is limited space on the canvas, but the first button is not quite wide enough to display its complete label. In the Layout Editor, you widen the button slightly and find that the width of all the buttons increases so that they now overlap each other.
What could have caused this problem?