Free 1Z0-141 Questions for Oracle9i forma Developer:build internet applications 1Z0-141 Exam as PDF & Practice Test Engine
View the Exhibit.
You are developing a form for a family-oriented video store. The form will run in query-only mode in a customer kiosk to show information about movies that are available to rent. The
Rating item in the Movies block of the form shown in the upper portion of the exhibit displays the rating of the movie: G, PG, R, or X.
Your customers are not interested in all these values, but they do want to see if the film is rated G to indicate that it is suitable for the whole family.
You decide to change the item to a check box to be displayed as shown in the lower portion of the exhibit. You want users to be able to query any movies, but only those with a G rating will have the check box selected.
You change the item type of the Rating item to Checkbox and set its Label, Value When
Checked (G), and Prompt properties. However, when you run the form to test it and execute an unrestricted query, only those movies with a rating of G are displayed.
What do you need to change so that all movies are returned by the query and the check box properly shows the "For the Whole Family" rating?
You are developing a form for a family-oriented video store. The form will run in query-only mode in a customer kiosk to show information about movies that are available to rent. The
Rating item in the Movies block of the form shown in the upper portion of the exhibit displays the rating of the movie: G, PG, R, or X.
Your customers are not interested in all these values, but they do want to see if the film is rated G to indicate that it is suitable for the whole family.
You decide to change the item to a check box to be displayed as shown in the lower portion of the exhibit. You want users to be able to query any movies, but only those with a G rating will have the check box selected.
You change the item type of the Rating item to Checkbox and set its Label, Value When
Checked (G), and Prompt properties. However, when you run the form to test it and execute an unrestricted query, only those movies with a rating of G are displayed.
What do you need to change so that all movies are returned by the query and the check box properly shows the "For the Whole Family" rating?
Correct Answer: D
Vote an answer
The Orders form has two base table blocks and a control block. There is an Execute Query button in the control block with the following When-Button-Pressed trigger:
DO_KEY('execute_query');
A user navigates to the Order Items block and clicks Execute Query. The query does not execute, but instead returns error FRM-41003: "This function cannot be performed here."
What can you do to fix this error?
DO_KEY('execute_query');
A user navigates to the Order Items block and clicks Execute Query. The query does not execute, but instead returns error FRM-41003: "This function cannot be performed here."
What can you do to fix this error?
Correct Answer: A
Vote an answer
Which statement is true about built-ins that invoke one form from another?
Correct Answer: C
Vote an answer
View the Exhibit.
You created and compiled the Summit menu whose properties are shown in the exhibit.
You attach the menu to the Orders form and run it to test the menu.
In addition to the Window item, which items from the Summit menu will appear in the top- level menu of the running form when the Summit menu is displayed?
You created and compiled the Summit menu whose properties are shown in the exhibit.
You attach the menu to the Orders form and run it to test the menu.
In addition to the Window item, which items from the Summit menu will appear in the top- level menu of the running form when the Summit menu is displayed?
Correct Answer: E
Vote an answer
You are developing a Human Resources application, and you create an Employees button in the Departments form. The When-Button-Pressed trigger calls the Employees form to display the employees in the current department. You have set the Employees button properties so that navigation to the button does not occur. The Validation Unit property of the Departments form is set to Item.
You want to ensure that the Department ID is valid prior to calling the Employees form, even if the user has updated the Department ID and has not navigated out of that item. The
Department_Id item has a When-Validate-Item trigger that performs some complex validation logic.
What code in the When-Button-Pressed trigger would force the When-Validate-Item trigger to fire for the Department_Id item without navigating from the item?
You want to ensure that the Department ID is valid prior to calling the Employees form, even if the user has updated the Department ID and has not navigated out of that item. The
Department_Id item has a When-Validate-Item trigger that performs some complex validation logic.
What code in the When-Button-Pressed trigger would force the When-Validate-Item trigger to fire for the Department_Id item without navigating from the item?
Correct Answer: C
Vote an answer
Which two statements about FORM_TRIGGER_FAILURE are true? (Choose two).
Correct Answer: B,C
Vote an answer
0
0
0
10