This preview shows page 1. Sign up to view the full content.
Unformatted text preview: enever the Unit_Price or Quantity is changed on the screen.
To achieve this, you have created a non-base-table Calculated item (ITEM_COTAL in the Order Items block)
that calculates UNIT_PROCE * QUANTITY and another non-base-table Calculated item (ORDER_TOTAL in
the Control block) that summarized ITEM_TOTAL.
Which three additional tasks must you do? (Choose three)
A. Set the Database Item property of ORDER_TOTAL to Yes.
B. Set the Update Allowed property of ORDER_TOTAL to Yes.
C. Set the Single Record property of the Control block to Yes.
D. Set the Query All Record property of the Order Items block to Yes.
E. Set the Precompute Summaries property of the Order Items block to Yes.
F. Create a null canvas item based on the ORDER_TOTAL column and set its Copy Value From Item property
G. Write a database trigger to update ORDER_TOTAL in the ORDERS table when a change is written to the
H. Write a stored procedure to update ORDER_TOTAL in the ORDERS table and call it from a
When-Validate-Item trigger whenever a change is made to the UNIT_PRICE or QUANTITY fields.
You are developing a form for customers to order tickets to events. There is an Event_Date item in the Tickets
block of the form that has an LOV whose record group uses the following query.
SELECT event_name, event_date FROM events
ORDER BY event_date
In the Choose_Event block of the form, you want users to be able to select an event name into an Event_Name
item. The event name will be selected from a LOV that is sorted by the name of the event.
You do not want to modify either the LOV or the record group at run time.
Which statement is true for the LOV and the record group as specified at design time?
A. You must define a new LOV for the Choose_Event.Event_Name item that uses a different record group.
B. You must define a new LOV for the Choose_Event.Event_Name item, but you can base it on the same
Actualtests.com - The Power of Knowing 1Z0-141
C. You c...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09