Oracle 1z0-151 Actual Free Exam Questions & Community Discussion

You are implementing a JavaBean in a form, the bean has no visible component on the form when invoked, the bean displays an input text where users enter a zip code, the bean has a single method that returns a short weather forecast for that zip code as a character value.
How can you retrieve that value so that you can display it to the user?

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

You have the Orders form open in Forms Builder. You create an object group in the Orders form and try to drag various components in the Object Navigator to the object group.
Which two components will you be unable to place in the object group?

View the Exhibit.

The orders form contains two canvases. Orders_CV displays one order and all of its order items.
Help-CV displays context-sensitive help.
When users invoke the help screen for the Customer_Id item, the help information obscures the Custormer_Id item, as shown in the Exhibit. Users would like to be able to see both the item and its help information simultaneously.
How can you move the help information to the right so that the Customer_Id item is visible?

The Orders form, you want to enable users to use Microsoft Excel to create and print an invoice for the customer. The file should be created on the user's computer so that it can be printed with the local printer.
Which WebUtil package would you use to implement this requirement?

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 have been assigned to maintain a forms application that was designed by a developer who has left the company.
The form uses different property classes to standardize the appearance of objects in the form. For example, all buttons should be of the same width.
The CV_Tools canvas contains several buttons. The Print invoice button is not quite wide enough to display its complete label.
In forms Builder, you open the Button_PC property class and change its Width property to a higher number. All the buttons become larger except the Print invoice button, which remains its original size. What could have caused this problem?

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?

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?