Oracle Fusion Middleware 11g: Build Applications with Oracle Forms - 1z1-151 Exam Practice Test
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?
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
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?
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?
Correct Answer: E
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
Which statement is true about flexible code?
Correct Answer: B
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
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?
Which WebUtil package would you use to implement this requirement?
Correct Answer: B
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
To avoid overloading the database during busy times, you decide to restrict the queries that are executed on the Orders form so that users query by either Order ID or Customer ID during these times. Which trigger is most appropriate for the code to enforce this restriction?
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You have been assigned to maintain the Orders form. Users complain that if the cursor is in the in the Orders block, they cannot navigate to the Order Items block by clicking a text item in that block. They must click the Next Block button to navigate from the Orders block to the Order Items block.
How should you investigate the source of the problem?
How should you investigate the source of the problem?
Correct Answer: F
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
Iin an Order Entry form, the Order_Items block has a text item called Shipping Date, which is of the Date data type. The Lowest Allowed Value and the Highest Allowed Value properties are not defined for this item.
Assuming that the following are defined, which three are valid settings for the initial Value = property of the Shipping_Date Item?
Assuming that the following are defined, which three are valid settings for the initial Value = property of the Shipping_Date Item?
Correct Answer: A,E,F
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
The Orders form has four blocks. The Orders and Order_items block are on the CV_Order content canvas; the inventories block items are on the CV_inventories content canvas; and Control block buttons are on the CV_Buttons toolbar canvas. All buttons have mouse Navigate set to No.
The Order_Items block is a detail of Orders. The inventories block is a detail of Order_Items, showing the stock of the selected product.
There is a button in the Control block with a When-Button-Pressed trigger:
IF GET_CANVAS_PROPERTY(:SYSTEM.cursor_item, item_canvas) = 'CV_ORDER'
THEN
GO_BLOCK ('inventories')
ELSE
GO_BLOCK('orders');
END IF;
When you run the form and click the button, navigation does not occur, and the form displays the runtime error "FRM-41053: Cannot find Canvas: invalid ID." What should you do to correct this problem?
The Order_Items block is a detail of Orders. The inventories block is a detail of Order_Items, showing the stock of the selected product.
There is a button in the Control block with a When-Button-Pressed trigger:
IF GET_CANVAS_PROPERTY(:SYSTEM.cursor_item, item_canvas) = 'CV_ORDER'
THEN
GO_BLOCK ('inventories')
ELSE
GO_BLOCK('orders');
END IF;
When you run the form and click the button, navigation does not occur, and the form displays the runtime error "FRM-41053: Cannot find Canvas: invalid ID." What should you do to correct this problem?
Correct Answer: A
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
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?
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?
Correct Answer: D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).