The moment your payment clears, your 1Z0-141 practice questions are already on their way — 2Pass4sure delivers by email within one minute. No shipping, no waiting: download the Oracle9i forma Developer:build internet applications package and start working through 138 practice questions tonight.

Oracle 1Z0-141 Exam Overview:

Oracle 1Z0-141 Exam Syllabus Topics:

Oracle 1Z0-141 Exam FAQ — What Candidates Ask Most

Oracle9i forma Developer:build internet applications Sample Questions:

Question 1

You are developing a customer information application for a pay television company. The customer's home telephone number is used as the account number for the customer.
Clerks must be able to update the telephone number in case of changes or data entry errors.
A data entry clerk will typically open several forms from the Customers form that are synchronized with the currently selected customer using a global variable containing the telephone number.
Although you also need to modify the other forms, what two triggers should you code in the
Customers form to keep the forms synchronized in case the data entry clerk updates the telephone number or selects a different customer? (Choose two.)

A. When-Validate-Item for the phone number item
B. When-New-Record-Instance
C. Key-Next-Record
D. Post-Query
E. When-New-Item-Instance for the phone number item
F. Pre-Query

Question 2

View the Exhibit.
In the Human Resources form shown in the exhibit, you want to modify the prompts, heights, and widths of the Department Id, Manager Id, and Location Id fields in the
Departments data block.
What must you select prior to invoking the Layout Wizard in reentrant mode to modify these item properties?

A. the Departments block
B. Frame8
C. Canvas4
D. Frame5
E. the DEPARTMENT_ID, MANAGER_ID, and LOCATION_ID items

Question 3

In your Employee.fmb module you have an EMP block, which is currently on a content canvas. You want to display items from the EMP block on a new tab canvas. What are two ways to achieve this? (Choose two.)

A. 1. Create a canvas in the Object Navigator.
2. Set the Canvas Type property to Content.
3. For each item, associate the new canvas by specifying the Item Canvas property.
B. 1. Create a tab canvas in the Layout Editor.
2 . For each item, associate the tab canvas by specifying the Canvas property.
3 . Set the Rendered property of each item to Yes.
C. 1. Create a canvas in the Object Navigator.
2 . Set the Canvas Type property to Tab.
3 . For each item, associate the new canvas by specifying the Item Canvas property.
4 . Set the Rendered property of each item to Yes.
D. 1. Create a tab page in the Layout Editor.
2. Associate the content canvas with each item by specifying the Item Canvas property.
3. For each item, associate the tab page by specifying the Tab Page property.
4. Set the Visible property of each item to Yes.
E. 1. Create a canvas in the Object Navigator.
2 . Set the Canvas Type property to Tab.
3 . For each item, associate the new canvas by specifying the Item Canvas property.
4 . For each item, associate the tab page by specifying the Tab Page property.
F. 1. Create a tab canvas in the Layout Editor.
2 . For each item, associate the tab canvas by specifying the Canvas property.
3 . For each item, associate the tab page by specifying the Tab Page property.

Question 4

The validation unit for the Orders form is set to Item. This master-detail form contains an
Orders block and a multirecord Order Items block. Why might you want to create a When-
Validate-Record trigger on the Orders block in this form?

A. to perform some logic every time a user navigates to a different record in the queried block
B. to check that all items in the Order Items block whose Required property is set to Yes have values
C. to check that all items in the Orders block whose Required property is set to Yes have values
D. to check that the shipping date for the order is not earlier than the order date

Question 5

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?

A. Because the data block is subclassed, you will have to delete the object and then create it again in the desired position.
B. Because the data block is subclassed, you can only drag objects to a lower position in the Object Navigator, so you can drag Order_Mode and Customer_Id to a position below
Order_Status.
C. Because the data block is subclassed, you cannot change the order of items in the object navigator, but you can change item properties to affect the navigation order.
D. Because the item is subclassed, you cannot change any of its properties.

Solutions: