1z1-151 試験問題を無料オンラインアクセス
| 試験コード: | 1z1-151 |
| 試験名称: | Oracle Fusion Middleware 11g: Build Applications with Oracle Forms |
| 認定資格: | Oracle |
| 無料問題数: | 90 |
| 更新日: | 2025-12-19 |
You add a display item named Quantity to the Order items block of your Orders form to display the quantity on hand for each product. Quantity is a non-base table item that should reflect the count of an ordered product from the inventories table.
What is the best way to populate the Order_Iterns.Quantity item?
Customers log in to your Orders application by using their customer ID, which is saved as a global variable. When the Orders form first comes up, you want it to be populated with the customer's orders, and you do not want customers to be able to query for another customer's orders.
You code the following triggers:
When-New Form instance on the Orders form:
GO_BLOCK('orders');
EXECUTE_QUERY;
You also have a button in the Control block labeled Query Orders with a When-Button Pressed trigger that has the same code as the When New-Form instance trigger.
To test the form, you run it and log in a Customer 104. When you click Query Orders, all orders are shown, not just those for Customer 104.
What is the best way to correct this issue to ensure that the customer can never query another customer's orders?
View the Exhibit to examine the form.
The text items (Field1, Field2, and Field3) and the button (Check_Values) are in the CONTROL block. The Mouse Navigate property of the button has been set to No.
The following code as been written in a When-Button-Pressed trigger on the Check_Values button:
MESSAGE(:field1| | ' - ' | | :SYSTEM.cursor_item | |
' - ' | | :SYSTEM.trigger_item);
With the focus in Field1 and the values 1, 2, and 3 in the text items, what message will be displayed when the button is clicked.