Oracle Fusion Middleware 11g Build Applications with Oracle Forms

Here you have the best Oracle 1z0-151 practice exam questions

You have 90 total questions to study from
Each page has 5 questions, making a total of 18 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on October 25, 2025
This site is not affiliated with or endorsed by Oracle.

Question 1 of 90

The Credit_Rating item in the Customers block of an Order Entry form must be restricted to three possible values: Good, Poor, or Null (the latter value indicates that the credit rating has not been determined). Order entry clerks must be able to update this item to any of the preceding three values.
You want to change the item to a check box labeled "Credit Risk" that should be selected if the customer has poor credit, the check box should not be selected if the customer's credit rating is good or undetermined.
Exam 1z0-151: Question 1 - Image 1

You change the item type to Checkbox, set other properties as shown in the Exhibit, and then run your form and insert three records: two with good credit and the check box deselected, and one with poor credit and the check box selected. You commit the data and query the records, with the following result set:
Exam 1z0-151: Question 1 - Image 2

The first two records show an undetermined credit rating, although your intention was to set the value to Good for these customers. What change must you make in the properties of the Credit_Ratinq item to enable values of Good, Poor, and Null to be entered?

Change the initial Value property to Good.

Change the Check Box Mapping of Other Values property to Not Allowed.

Change the initial Value property to Good and the Value When Unchecked property to Null.

Change the initial Value property to Good and the Chock Box Mapping of Other Valued property to Null.

Change the initial Value property to Good and the Check Box Mapping of Other Values property to checked.

Change the item type. It is not appropriate to use a check box to enable entry and update of more than two values in an item.

Correct Answer: F

Incorrect answers:
F: A check box is not limited to two values. F

Question 2 of 90

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

PL/SQL variables

Form items

global variables

system variables

parameters

Correct Answer: B, C, D, E

Question 3 of 90

The Order Entry application contains several forms. The inventories form uses an LOV that is based on a record group that queries the Warehouses table to return a warehouse ID.
Several of the forms use LOVs that are based on the same query. You decide to centralize the creation of the record group to the entry form of the application, which opens all the other forms, for example, to open the inventories form, there is a When-Button Pressed trigger on the inventories button with the following code;
OPEN _FORM ('inventories');
in a When-New-Form-instance trigger for the entry form, you create the warehouse_rg record group by using the CREATE_GROUP_QUERY built in with the following arguments:
('warehouse_rg' , 'SELECT ALL WAREHOUSE.WAREHOUSE_ID, WAREHOUSE.WAREHOUSE_NAME FORM WAREHOUSE order by warehouse_name);
You also populate the record group in this trigger.
What must you do to make this record group available to the inventories form and the other forms?

in the When-New-Form-instance trigger for the entry form, add a values for the SCOPE argument of CREATE_GROUP_QUERY.

in the entry form, move the record group code to the end of the When-Button-Pressed triggers for the buttons that open other forms, so that the record group is created and populated immediately after OPEN_FORM is called.

in the entry form, move the record group code to the beginning of the When-Button-Pressed triggers for the button that open other forms, so that the record group is created and populated just before OPEN_FORM is called.

in the When-Button_Pressed triggers of the entry from the buttons that open other forms, add a value for the SESSION argument of OPEN_FORM.

in the other forms, refer to the record group as: global.warehouse_rg.

Correct Answer: A

Question 4 of 90

View the Exhibit.
Exam 1z0-151: Question 4 - Image 1

Iin the Human Resources form shown in the Exhibit, you want to modify the prompts, heights, and widths of the Department Id, Manager Id, and Location Id Holds in the Departments data block.
What must you select before invoking the Layout Wizard in reentrant mode to modify these item properties?

Frame5

Frames

Canvas4

the Departments block

the DEPARTMENT_ID, MANAGER_ID and LOCATION_ID items

Correct Answer: A

Question 5 of 90

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?

Use FBEAN.ENABLE_EVENT to register a listener for the bean event. Obtain the value of SYSTEM.CUSTOM_ITEM_EVENT in a When-Custom item Event trigger, and then use that value as an argument to the MESSAGE built in.

Use FBEAN.REGISTER_BEAN as an argument to the MESSAGE built in to invoke the bean's method and return the value as a message displayed to the user.

Use FBEAN.REGISTER_BEAN to register the bean, so that when the user enters a zip code into the bean s input text, the value is automatically displayed in the bean area item.

Use FBEAN.ENABLE_EVENT to register a listener for the bean event. Obtain the value of SYSTEM.CUSTOM_EVENT_PARAMETER in a When_Custom-

Correct Answer: D