[Free] 2018(Jan) EnsurePass Examcollection Oracle 1z0-141 Dumps with VCE and PDF 61-70

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-141
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-141.html

oracle9i forma developer:build internet applications

Question No: 61 – (Topic 0)

You created a LOV based upon a three-column Record Group called CUST, which was created at design time.

View the Exhibit and examine the structure of the CUST Record Group.

At run time, the user sometimes requires the LOV to be populated from the PROD Record Group.

Which two built-ins will enable you to create the PROD Record Group and repopulate the LOV? (Choose two.)

Ensurepass 2018 PDF and VCE

  1. RETRIEVE_LIST(lov_id, #39;PROD#39;);

  2. POPULATE_LIST(lov_id, #39;PROD#39;);

  3. SET_LOV_PROPERTY(lov_id,GROUP_NAME,#39;PROD#39;);

  4. CREATE_GROUP_FROM_QUERY (#39;PROD#39;, #39;SELECT P_id, #39;||

    • date_sold as Date, Name as Desc #39;|| #39; from products #39; );

  5. CREATE_GROUP_FROM_QUERY (#39;PROD#39;, #39;SELECT P_id as ID, #39;||

    • Name as Desc, date_sold as Date #39;|| #39; from products #39; );

  6. CREATE_GROUP_FROM_QUERY (#39;PROD#39;, #39;SELECT rownum as Index, P_id as ID, #39;||

  • Name as Desc, date_sold as Date #39;|| #39; from products #39; );

Answer: C,E

Question No: 62 – (Topic 0)

What are two ways that you can assign a value to an item on a form from within the code of a menu item? (Choose two).

  1. Use the COPY built-in.

  2. Use the NAME_IN built-in.

  3. Use the FIND_ITEM built-in.

  4. Use the SET_ITEM_PROPERTY built-in.

  5. Use the EXECUTE_TRIGGER built-in to call code in the form that assigns the value.

Answer: A,E

Question No: 63 – (Topic 0)

Which two statements about FORM_TRIGGER_FAILURE are true? (Choose two).

  1. You cannot raise FORM_TRIGGER_FAILURE in an exception handler.

  2. FORM_TRIGGER_FAILURE does not cause an unhandled exception.

  3. FORM_TRIGGER_FAILURE causes a trigger to fail in a controlled manner.

  4. If you use FORM_TRIGGER_FAILURE to fail a trigger that is called by another trigger, the calling trigger automatically fails.

  5. Processing continues after FORM_TRIGGER_FAILURE is raised until the end of the PL/SQL block that contains it.

  6. You must code an exception handler to define how you want the FORM_TRIGGER_FAILURE exception to function.

Answer: B,C

Question No: 64 – (Topic 0)

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?

  1. 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.

  2. 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.

  3. 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.

  4. 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.

Answer: B

Question No: 65 – (Topic 0)

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?

Ensurepass 2018 PDF and VCE

  1. Set Single Record to Yes.

  2. Set Query All Records to Yes.

  3. Set Query Array Size to a larger number.

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

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

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

Answer: D

Question No: 66 – (Topic 0)

View the Exhibit and examine the PL/SQL code. The code uses the valmess package, which should print out the employee#39;s salary if it exceeds 2345.

To resolve compiler or run-time errors and ensure that the code works as intended, what changes should you make to the trigger code?

Ensurepass 2018 PDF and VCE

  1. No changes are required.

  2. Delete the BEGIN and END keywords.

  3. Define an EXCEPTION section to handle exceptions.

  4. Pass the Forms variable to the package function with the format

    :block_name.item_name.

  5. Define a DECLARE section to declare PL/SQL variables.

Answer: D

Question No: 67 – (Topic 0)

You have been asked to correct a problem with a form that was created by another developer. Users complain that they are unable to query on the employee Hire Date, which is a base table item. What is a possible cause for this problem?

  1. The Hire Date item is a display item.

  2. The Hire Date item has its Enabled property set to No.

  3. The Hire Date item has its Query Allowed property set to Yes.

  4. The Hire Date item width is not large enough to display the complete date.

Answer: A

Question No: 68 – (Topic 0)

The user must be able to invoke a list of values for valid sales representatives in the Orders form. To facilitate this, you created a button and positioned it next to the Sales Rep Id field.

The text item has these properties set:

  • Required: Yes

  • List of Values: SALES_REP_LOV

  • Validate from List: No

    The button has these properties set:

    – Keyboard Navigable: Yes

  • Mouse Navigate: Yes

  • Iconic: Yes

  • Icon Filename: list.ico

An appropriate LOV has been created (called SALES_REP_LOV) and associated with the text item. An icon file (list.gif) exists in the appropriate directory. All other properties are left at their defaults.

You write a When-Button-Pressed trigger at the item level with this code: LIST_VALUES;

To test the form, you attempt to enter a new record. What is the run-time behavior of the form?

  1. The form doesn#39;t compile and therefore cannot be tested.

  2. The icon is not displayed on the button. When you click in the Sales Rep Id field and then click the button, the LOV is invoked.

  3. The icon is displayed on the button. When you click in the Sales Rep Id field and then click the button, the LOV is not invoked and an error is reported.

  4. The icon is not displayed on the button. When you click in the Sales Rep Id field and then click the button, the LOV is not invoked and an error is reported.

  5. The icon is displayed on the button. When you click in the Sales Rep Id field and then click the button, the LOV is invoked.

Answer: D

Question No: 69 – (Topic 0)

An Order Entry form that you are developing contains several blocks. The first is a control block where you create buttons to perform certain actions.

One button, which is mouse and keyboard navigable, contains code to navigate to and perform queries in multiple blocks in the form:

GO_BLOCK(#39;Customers#39;); EXECUTE_QUERY;

GO_BLOCK(#39;Orders#39;); EXECUTE_QUERY; GO_BLOCK(#39;Items#39;); EXECUTE_QUERY;

You do not want trigger processing to continue if there is any type of error in navigating to the Customers block. How should you modify the code?

  1. GO_BLOCK(#39;Customers#39;); if FORM_SUCCESS then EXECUTE_QUERY;

    end if; GO_BLOCK(#39;Orders#39;);

    EXECUTE_QUERY; GO_BLOCK(#39;Items#39;); EXECUTE_QUERY;

  2. GO_BLOCK(#39;Customers#39;); if not FORM_FAILURE then

    raise FORM_TRIGGER_FAILURE;

    end if; EXECUTE_QUERY;

    GO_BLOCK(#39;Orders#39;); EXECUTE_QUERY; GO_BLOCK(#39;Items#39;); EXECUTE_QUERY;

  3. GO_BLOCK(#39;Customers#39;); if not FORM_SUCCESS then

    raise FORM_TRIGGER_FAILURE;

    end if; EXECUTE_QUERY; GO_BLOCK(#39;Items#39;); EXECUTE_QUERY; GO_BLOCK (#39;Items#39;); EXECUTE_QUERY

  4. GO_BLOCK(#39;Customers#39;); if FORM_FATAL then

raise FORM_TRIGGER_FAILURE;

end if; EXECUTE_QUERY;

GO_BLOCK(#39;Orders#39;); EXECUTE_QUERY; GO_BLOCK (#39;Items#39;); EXECUTE_QUERY

Answer: C

Topic 1, B

B

Question No: 70 – (Topic 1)

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.)

  1. 1. Create a tab canvas in the Layout Editor.

    1. For each item, associate the tab canvas by specifying the Canvas property.

    2. Set the Rendered property of each item to Yes.

  2. 1. Create a tab canvas in the Layout Editor.

    1. For each item, associate the tab canvas by specifying the Canvas property.

    2. For each item, associate the tab page by specifying the Tab Page property.

  3. 1. Create a tab page in the Layout Editor.

    1. Associate the content canvas with each item by specifying the Item Canvas property.

    2. For each item, associate the tab page by specifying the Tab Page property.

    3. Set the Visible property of each item to Yes.

  4. 1. Create a canvas in the Object Navigator.

    1. Set the Canvas Type property to Content.

    2. For each item, associate the new canvas by specifying the Item Canvas property.

  5. 1. Create a canvas in the Object Navigator.

    1. Set the Canvas Type property to Tab.

    2. For each item, associate the new canvas by specifying the Item Canvas property.

    3. Set the Rendered property of each item to Yes.

  6. 1. Create a canvas in the Object Navigator.

  1. Set the Canvas Type property to Tab.

  2. For each item, associate the new canvas by specifying the Item Canvas property.

  3. For each item, associate the tab page by specifying the Tab Page property.

Answer: B,F

100% Ensurepass Free Download!
Download Free Demo:1z0-141 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-141 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.