| Exam Code/Number: | 1z0-151Join the discussion |
| Exam Name: | Oracle Fusion Middleware 11g: Build Applications with Oracle Forms |
| Certification: | Oracle |
| Question Number: | 90 |
| Publish Date: | Oct 10, 2026 |
|
Rating
100%
|
|
View the exhibit.
In the OrderItemsForm, you have a control with a button that users can click to navigate to the first record in the block. The button has keyboard Navigable and Mouse Navigable set to No.
You are coding a When-Button-Pressed trigger for the First Record button with the following code:
SCROLL_UP;
WHILE FORM_SUCCESS LOOP
SCROLL_UP;
END LOOP;
What happens when the user clicks First Record with the cursor in the 72nd record in the block, as shown in the Exhibit?
The Orders form is sometimes run automatically and sometimes run from the Customers form, when it is run from the Customers form, any queries should be restricted to the customer that is currently selected. The Customers form button that runs the Orders form sets a global variable to the current customer ID.
The Orders form has a button labeled Execute Query with the following When-Button Pressed trigger:
DEFAULT_VALUE (NULL, 'GLOBAL.Customer_id');
IF: GLOBAL.customer_id IS NOT NULL
THEN
SET_BLOCK_PROPERTY ('orders', DEFAULT_WHERE, 'orders.customer_id =
' | | :GLOBAL.CUSTOMER_id);
END IF;
EXECUTE_QUERY
You want to duplicate that functionality in a menu item for the Summit menu that is attached To the Orders form.
What changes must you make to the code so that the menu code functions as it does in the form?
View the Exhibit.
You are attempting to drag the Control and CV_Order objects to an object group as shown in the Exhibit, but you are unable to release them in the Object Group Children node of the object group.
What is the reason for this?
The Orders database table uses Order_id as its primary key. You have written the following code to use in the Orders block of a form:
SELECT orders_seq.NEXTVAL
INTO :orders.order_id
FROM SYS.dual;
Which statement is true about this code?
You have created an editor named MyEditor, and you want it to be available to edit the text item Product_Description. You can associate the editor with the text item by setting the Editor property of Product_Description to MyEditor.
