Latesttests
2018 Jan Oracle Official New Released 1z0-141
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-141.html

oracle9i forma developer:build internet applications

Question No: 81 – (Topic 1)

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 Customer_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) = #39;STORE_CLERK#39; THEN set_buttons(#39;STORE_CLERK#39;); GO_ITEM(#39;ORDERS.Customer_id#39;);

ELSE

set_buttons(#39;ADMIN_MGR#39;); GO_ITEM(#39;ORDERS.Date_Ordered#39;);

END IF;

What is the best trigger to execute this code?

  1. Pre-Form at form level

  2. When-Validate-Item at form level

  3. When-New-Form-Instance at form level

  4. When-Button-Pressed on any of the enabled buttons

  5. Pre-Block on the first navigable block in the form

  6. When-New-Item-Instance on the Date_Ordered text item

Answer: C

Question No: 82 – (Topic 1)

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

  1. Set the List Style property to combo box.

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

  2. Set the List Style property to Tlist.

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

  3. Set the List Style property to poplist.

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

  4. Set the List Style property to combo box.

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

  5. Set the List Style property to Tlist.

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

  6. Set the List Style property to poplist.

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

Answer: D

Question No: 83 – (Topic 1)

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?

Latesttests 2018 PDF and VCE

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

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

  3. Because the data block is subclassed, you will have to delete the object and then create it again in the desired position.

  4. Because the item is subclassed, you cannot change any of its properties.

Answer: A

Question No: 84 – (Topic 1)

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(#39;execute_query#39;);

A user navigates to the Order Items block and clicks Execute Query. The query does not execute, but instead returns error FRM-41003: quot;This function cannot be performed here.quot;

What can you do to fix this error?

  1. Define a Key-Exeqry trigger at the form level.

  2. Set the Mouse Navigate property to No for the Execute Query button.

  3. Set the Query All Records property to Yes for the Order Items block.

  4. Set the Query Allowed property to Yes for at least one item in the Order Items block.

Answer: B

Question No: 85 – (Topic 1)

You want to create a calculated item in the Control block of the Human Resources form. This item will contain the total of employee salaries for employees in a particular department. Which statement is true about how to create the calculated item?

  1. You can create it by first creating a text item and then changing the item type.

  2. You can create it in the Layout Editor using a special tool that creates a calculated item.

  3. You can create it by first creating a display item and then setting appropriate properties in its Calculation property group.

  4. You can create it in the Layout Editor by selecting the Salary item of the Employees block, selecting the Control block from the block list, clicking the Text Item tool, and drawing a text item on the canvas to automatically calculate a sum of the selected Salary item.

Answer: C

Question No: 86 – (Topic 1)

You are developing a Human Resources form for HR clerks to insert, update, and delete records from the EMPLOYEES table. You are also maintaining an audit table with the following table description:

SQLgt; desc audit_changes

Name Null? Type

——————– ——– —————

TABLE_NAME VARCHAR2 (30)

ID NUMBER

TIMESTAMP DATE

CHANGE_BY VARCHAR2 (30)

CHANGE_TYPE VARCHAR2 (6)

Valid values for the CHANGE_TYPE column are INSERT, UPDATE, and DELETE.

Which trigger(s) must you create or modify in the Human Resources form to track all the information in the audit table?

  1. Post-Commit

  2. Post-Database-Commit

  3. When-Validate-Record

  4. Post-Insert, Post-Update and Post-Delete

  5. You cannot accomplish this using Forms triggers; you must use a database trigger.

Answer: D

Question No: 87 – (Topic 1)

You are designing a Human Resources application that uses a menu to implement most of the code. One of the menu items is labeled Raise Salary. The business rule is that the salary should be raised 2% if the salary of the selected employee shown in the form is less than $25,000 per year, but the raise should be 3% if the value of the salary item is $25,000 or greater. Which condition can you use in the menu code to determine if the current value of the Salary item in the Employees block is less than $25,000?

  1. IF :EMPLOYEES.SALARY lt; 25000 THEN…

  2. IF COPY(#39;EMPLOYEES.SALARY#39;) lt; 25000 THEN…

  3. IF NAME_IN(#39;EMPLOYEES.SALARY#39;) lt; 25000 THEN…

  4. IF FIND_ITEM(#39;EMPLOYEES.SALARY#39;) lt; 25000 THEN…

  5. IF GET_ITEM_PROPERTY(#39;EMPLOYEES.SALARY#39;,DATABASE_VALUE) lt; 25000 THEN…

Answer: C

Question No: 88 – (Topic 1)

View the Exhibit.

You want to create a menu item to enable users to sort the tabular display of a form either by customer ID, last name, or department ID. You decide to create a radio group as shown at run time in the exhibit.

Which statement about this radio group is true?

Latesttests 2018 PDF and VCE

  1. You must create the radio group before creating Radio menu items for it.

  2. You must create a Radio menu item before the radio group is created.

  3. You must name the radio group the same as the submenu name so that it will be associated with that submenu.

  4. You must name the radio group Sort, the same as the submenu label, so that it will be associated with that submenu.

Answer: B

Question No: 89 – (Topic 1)

The menu that appears by default in a Forms application does not quite meet your needs, so you decide to create a custom menu. You create and compile a menu module called Test with three submenus that contain PL/SQL code, and you attach the Test menu to a form. How will the menu of the form appear and perform at run time?

  1. You will see only the three submenus from the Test menu (plus the Window menu that is usually displayed), and you will not be able to call

    code from the default menu in your form.

  2. You will see the three submenus from the Test menu merged with the submenus of the default menu (plus the Window submenu that is

    usually displayed).

  3. You will see only the submenus of the default menu (plus Window), but you will be able to call code from the Test menu in your form.

  4. You will see only the Test menu submenus (plus Window), but you will be able to call code from the default menu in your form.

  5. You will see only the submenus of the default menu (plus Window) until you issue the

REPLACE_MENU built-in in the form.

Answer: A

Question No: 90 – (Topic 1)

An application is accessed through the Summit form, which can open the Customers form and the Orders form. The Customers form can also open the Orders form, and the Orders form can open the Customers form. What should you do to ensure that forms are closed in the proper order so that the session closes down when the last form is exited?

  1. You should keep track of the order of the opening of forms in a global record group.

    Then in the Key-Exit trigger for each form, you should allow only the last form that was opened to be closed.

  2. You should make sure that the Summit form that started the session is the last one closed by coding its Key-Exit trigger to exit only if no other

    forms are open.

  3. You do not need to do anything because Forms keeps track of the forms that are opened internally and does not allow the user to close them

    in the wrong order.

  4. You do not need to do anything. No matter which form is closed last, the session will close properly.

Answer: D

100% Free Download!
Download Free Demo:1z0-141 Demo PDF
100% Pass Guaranteed!
Download 2018 Latesttests 1z0-141 Full Exam PDF and VCE

Latesttests 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

2018 Latesttests IT Certification PDF and VCE