Master the 1z0-141 oracle9i forma developer:build internet applications content and be ready for exam day success quickly with this Actualtests 1z0-141 exam fees. We guarantee it!We make it a reality and give you real 1z0-141 questions in our Oracle 1z0-141 braindumps.Latest 100% VALID Oracle 1z0-141 Exam Questions Dumps at below page. You can use our Oracle 1z0-141 braindumps and pass your exam.


♥♥ 2017 NEW RECOMMEND ♥♥

Free VCE & PDF File for Oracle 1z0-141 Real Exam (Full Version!)

★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW 1z0-141 Exam Dumps (PDF & VCE):
Available on: http://www.surepassexam.com/1z0-141-exam-dumps.html

Q31. The following On-Error trigger was written to give users a more meaningful message when they press the Up key when the cursor is in the first record (the FRM-40100 error) and to display default messages for all other errors:

IF message_code = 40100 THEN

MESSAGE('You are already at the first record');

ELSE

MESSAGE(message_type || '-' ||

to_char(message_code) || ': ' || message_text);

END IF;

When you test the form, you still get the FRM-40100 message when you press the Up key while the cursor is in the first record. Your custom message does not appear.

What corrections can you make so that the code functions properly?

A. Change all occurrences of message_code, message_type, and message_text to error_code, error_type, and error_text.

B. Eliminate the to_char function because message_code is a varchar2 value.

C. Change all occurrences of message_code, message_type, and message_text to DBMS_error_code, DBMS_error_type, and DBMS_error_text.

D. To keep the remaining code from executing, add after the second line: RAISE FORM_TRIGGER_FAILURE;

Answer: A


Q32. During testing, you received comments that the default functionality of the [Commit] key can cause an error message to be displayed if there are no changes to save when it was activated.

You decide to provide a button for users to validate the form and issue a commit if necessary. To implement this, you write a form-level procedure called VALIDATE_AND_COMMIT.

The same functionality must be provided when the user chooses File > Save from the menu or presses the [Commit] key.

Which should you use?

A. The When-Button-Pressed trigger with the code

DO_KEY('COMMIT_FORM');

A form-level Key-Commit trigger with the code

validate_and_commit;

B. The When-Button-Pressed trigger with the code

DO_KEY('[COMMIT]');

A form-level Key-Commit trigger with the code

DO_KEY('validate_and_commit');

C. The When-Button-Pressed trigger with the code

DO_KEY(commit;);

A form-level Key-Commit trigger with the code

validate_and_commit;

D. The When-Button-Pressed trigger with the code

validate_and_commit;

A form-level Key-Commit trigger with the code

DO_KEY('COMMIT_FORM');

E. The When-Button-Pressed trigger with the code

DO_KEY('COMMIT_FORM');

A form-level Key-Commit trigger with the code

DO_KEY('COMMIT_FORM');

validate_and_commit;

Answer: A


Q33. Which two statements correctly describe the relationship between a content canvas and a window? (Choose two.)

A. Only one content canvas at a time can appear in a window.

B. A content canvas can be associated with two or more windows.

C. Only one content canvas can be associated with a window.

D. A maximum of two content canvases can appear in a window at the same time.

E. One or more content canvases can be associated with a window.

F. A content canvas cannot be larger than the window with which it is associated.

Answer: AE


Q34. View the Exhibit.

You are developing and testing a Forms application on a machine that has plenty of memory. The Customers block, whose Property Palette is shown in the exhibit, is based on a table that contains a large number of records.

The initial query on the block appears quickly. However, after scrolling through hundreds of records in the block, you notice that it is taking longer and longer to retrieve the next set of records. What can you do to improve performance without losing the fast initial response?

A. Set Number of Records Buffered to a smaller number.

B. Set Single Record to Yes.

C. Set Number of Records Buffered to a larger number.

D. Set Number of Records Displayed to a smaller number.

E. Set Query All Records to Yes.

F. Set Query Array Size to a larger number.

Answer: C


Q35. 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||' - '||

NAME_IN(:SYSTEM.cursor_item)||' - '||

NAME_IN('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?

A. CONTROL.FIELD1 - CONTROL.FIELD2 - field3

B. CONTROL.FIELD1 - CONTROL.FIELD1 - field1

C. field1 - field1 - field1

D. field1 - field1 - Check Values

E. field1 - field2 - field3

F. field1 - field2 - Check Values

G. field1 - field1 - CONTROL.FIELD1

Answer: G


Q36. View the Exhibit.

You are developing a Human Resources application. There is a query-only form that displays employee IDs, names, and department numbers. When users double-click an employee ID, another form opens displaying all the columns from the EMPLOYEES table so that users can update the records (as shown in the exhibit).

You use a global variable to pass the value for Employee_Id to the update form. When users modify the name and exit the update form, how can you synchronize the data in the query-only form so that the new name is displayed?

A. Requery the data in a Pre-Form trigger of the query-only form.

B. Pass the new name value in a global variable from the update form to the query-only form and assign it to the appropriate name item in a When-New-Form-Instance trigger of the query-only form.

C. Requery the data in a When-Form-Navigate trigger of the query-only form.

D. Pass the new name value in a global variable from the update form to the query-only form and assign it to the appropriate name item in a When-Form-Navigate trigger of the query-only form.

E. Pass the new name value in a global variable from the update form to the query-only form and assign it to the appropriate name item in a Pre-Form trigger of the query-only form.

F. Requery the data in a When-New-Form-Instance trigger of the query-only form.

Answer: C


Q37. You want users to be able to add values to a list item at run time. How do you achieve this?

A. Set the List Style property to Tlist.

From the When-List-Activated trigger, call the Populate_List built-in.

B. Set the List Style property to combo box.

From the When-List-Activated trigger, call the Add_List_Element built-in.

C. Set the List Style property to combo box.

From the When-List_Changed trigger, call the Add_List_Element built-in.

D. Set the List Style property to Tlist.

From the When-Validate-Item trigger, call the Populate_List built-in.

E. Set the List Style property to poplist.

From the When-List-Activated trigger, call the Add_List_Element built-in.

F. Set the List Style property to poplist.

From the When-Validate-Item trigger, call the Add_List_Element built-in.

Answer: C


Q38. While using the LOV Wizard to create the LOV called SALES_REP_LOV, which is based on the SALES_REP_RG record group, you assign it to the Sales_Rep_Name item in the form that you are developing.

After the LOV is created, you realize that you should have assigned the LOV to the Sales_Rep_Id item instead. What can you do to make this change?

A. Change the Record Group Query property of the SALES_REP_RG record group to select into the Sales_Rep_Id item instead of into the Sales_Rep_Name item.

B. Change the Column Mapping properties of the SALES_REP_LOV list of values to return the value to SALES_REP_ID rather than to SALES_REP_NAME.

C. Delete the SALES_REP_LOV list of values and create it again, because once the LOV is created, you cannot modify the item to which it is assigned.

D. Delete the value in the List of Values property for the Sales_Rep_Name item and set the List of Values property of the Sales_Rep_Id item to SALES_REP_LOV.

Answer: D


Q39. You have the Orders form open in Forms Builder. You create an object group in the Orders form and you try to drag various components in the Object Navigator to the object group. Which two components will you be unable to place in the object group? (Choose two.)

A. the When-New-Form-Instance trigger of the Orders form

B. the Product_Id item in the Order_Items block of the Orders form

C. the When-New-Item-Instance trigger of the Order_Items.Quantity item in the Orders from

D. the Order_CV canvas of the Orders form

E. the Orders block of the Orders form

Answer: BC


Q40. In 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 all of the following are defined, which three are valid settings for the Initial Value property of the Shipping_Date item? (Choose three.)

A. :Orders.Order_Date + 3

B. ORDER_ITEMS_SEQ

C. :GLOBAL.SHIP_DATE

D. :PARAMETER.SHIP_DATE

E. SYSDATE

F. $$DBDATE$$

Answer: CDF