To achieve this you have created a non base table

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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 to CONTROL.ORDER_TOTAL. G. Write a database trigger to update ORDER_TOTAL in the ORDERS table when a change is written to the ORDER_ITEMS table. 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. Answer: C,D,E QUESTION 47: 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 record group. Actualtests.com - The Power of Knowing 1Z0-141 C. You c...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online