Category: 1Z0-141

Exam 1Z0-141: Oracle9i Forms Developer, Build Internet Applications Exam Preparation Material

What do you need to change so that all movies are returned by the query and the check box properly shows 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?

what message will be displayed when the button is pressed?

Exhibit:

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 has been written in a When-Button-Pressed trigger on the Check_Values button:
MESSAGE(:field1 | |’ – ‘| | :SYSTEM.cursor_item | | ‘
– ‘| | :SYSTEM.trlgger_ltem) ;
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 pressed?

How do you correct this problem?

The Products.fmb module has one content canvas, which displays information about products sold by your company.
You increase the canvas display area by creating an overlay canvas to enable product images to be displayed on request. At run time, however, the overlay canvas is never displayed; users complain that there is only a brief flash on their screen
How do you correct this problem?

what can you do to change the navigation order?

Exhibit:

View the Exhibit
You are modifying the New_Orders form. You want to change the navigation order of the Orders block so that Order_Status is between Order_Date and Order_Mode in the navigation order. You attempt to drag the Order_Status item in the Object Navigator (as shown in the exhibit), but Forms does not allow you to release the item in the desired position. Why is this happening, and what can you do to change the navigation order?

What corrections should you make so that the trigger compiles and functions properly?

Exhibit:

You are coding a trigger (shown in the exhibit) to display the database error that occurs when users encounter the FRM-40505 error about being unable to execute a query. You have created an alert called Ouery_Alert. For the FRM-40505 error, the trigger should display the database error message in the Ouery_Alert. For all other errors, the trigger should display default messages on the console message line.
Examine the code for the On-Error trigger. When you attempt to compile this trigger, you receive a compilation error with the message "Error 215 at line2, column 4: String length constraints must be in range (1..32767)".
What corrections should you make so that the trigger compiles and functions properly?

How can you change the Item Type of the Exit button back to Push Button…

You apply the Btn_PC property class to the Exit button and then make several changes in the property values of the button. The Btn_PC property class includes the item type Push Button. You accidentally change the Item Type property of the Exit Button to CheckBox . How can you change the Item Type of the Exit button back to Push Button, restore the subclassed relationship of the Item Type to the property class, and retain any other property changes that you have made?

What are two ways to allow the user to view the display item at run time?

Exhibit:

View the Exhibit and examine the Property Palettes of the BONNY canvas and the CLYDE window. The requirements of the application specify that the CLYDE window should not be resizable.
The form contains two items, both 50 points wide by 15 points high, which are associated with the canvas
The first item is a text item; the X Position property is 30, and the Y Position property is 40.
The second item is a display item; the X Position property is 150, and the Y Position property is 250.
What are two ways to allow the user to view the display item at run time? (Choose two.)

What is the best trigger to execute this code?

The Orders form is required to initialize differently for different users. A database procedure (GET _ROLE_NAME) is used to determine which database roles are enabled for the user logging on to the form If the user has the STORE_CLERK role enabled, certain buttons are disabled and the focus is sent to the Custome_Id text item. If the user has the ADMIN_MGR role enabled, all buttons are available and the focus is sent to the Date Ordered text item. You have written a procedure (SET_BUTTONS) to set the appropriate button properties.
The functionality is achieved with this code:
IF get role name (USER)= ‘STORE_CLERK’ THEN
set_buttons(‘STORE_CLERK’);
GO_ITEM(‘ORDERS.Customer_id’);
ELSE
set_buttons(‘ADMIN_MGR’);
GO_ITEM(‘ORDERS.Date_Ordered’);
END IF;
What is the best trigger to execute this code?

what message will be displayed when the button is clicked?

Exhibit:

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 has been written in a When-Button-Pressed trigger on the Check_Values button:
MESSAGE(:field1 l l’- ‘l l
NAME_IN(:SYSTEM.cursor.item) l l’- ‘l l NAMEIN(‘SYSTEM.cursor.item’)); With the focus in FIELD1, and the values field1, field2, and field3 in the text items, what message will be displayed when the button is clicked?

Which two actions allow the user to view the display item at run time?

Exhibit:

Examine the Property Palettes of the BONNY canvas and the CLYDE window. Two items, both 50 points wide by 15 points high, are associated with the canvas. The first item is a text item, the X Position property is 30, and the Y Position property is 40. The second item is a display item; the X Position property is 150, and the Y Position property is 250 Which two actions allow the user to view the display item at run time? (Choose two)


Page 1 of 1912345...10...Last »