 |
| Creating Additional Input Items |
01. Exhibit:
You are modifying a form that has four buttons on a canvas. Button2, Button3, and Button4 are all sub classed from Button1. You want to change the width of all the buttons, so you open the Property Palette for Button1 and change its width to 60. In the Layout Editor, you can see that all buttons have become smaller except for Button3. You open the Property Palette for Button3 (as shown in the exhibit).
Why did the width for Button3 not change to 60?
A. Button3 was not properly sub classed.
B. Width is a changed property in Button3.
C. Width is a variant property in Button3.
D. Width is a default property in Button3.
E. Width is an inherited property in Button3.
Answer: C
02. Which three statements about display items are true? (Choose three)
A. A display item cab be a database item.
B. The content of a display item can be read and changed programmatically.
C. If a display item is part of a control block, its Calculation Mode property is ignored.
D. A display item does not have a Format Mask property, so a text item must be used where that functionality is required.
E. The contents of a display item can be validated using a Key-Next-Item trigger with the scope of the display item.
F. A display item does not have a Multi-Line property, so a text item must be used where that functionality is required.
Answer: A,B,F
03. The Orders form must display the item total for products ordered. You decide to implement this functionality by creating an item in the ORDER_ITEMS block as a Calculated item. The item total is calculated by multiplying the UNIT_PRICE of the product by the QUANTITY ordered.
Which two items properties must be set? (Choose two)
A. Database item must be set to No.
B. Update Allowed must be set to No.
C. Summary Function must be set to Sum.
D. Item Type must be set to Display Item.
E. Calculation Mode must be set to Formula.
F. Calculation Mode must be set to Summary.
G. Summarized Block must be set to ORDER_ITEMS.
H. Formula must be set to an appropriate calculation.
Answer: A,E
04. Exhibit:
SQL> desc orders
Name Null? Type
------------------------------ -------------- ------------------
ORDER_ID NOT NULL NUMBER(12)
ORDER_DATE NOT NULL DATE
ORDER_MODE VARCHAR2(8)
CUSTOMER_ID NOT NULL NUMBER(6)
ORDER_STATUS NUMBER(2)
ORDER_TOTAL NUMBER(8,2)
SALES_REP_ID NUMBER(6)
SQL> desc order_items
Name Null? Type
----------------------------- -------------- ------------------
ORDER_ID NOT NULL NUMBER(12)
LINE_ITEM_ID NOT NULL NUMBER(3)
PRODUCT_ID NOT NULL NUMBER(6)
UNIT_PRICE NUMBER(8,2)
QUANTITY NUMBER(8)
ITEM_TOTAL NUMBER(10,2)
Examine the structure of the ORDERS and ORDER_ITEMS tables.
The ORDERS table has been denormalized in that the column ORDER_TOTAL contains the total cost for all ORDER_ITEMS linked to particular order via the foreign key ORDER_ID. You need to create a form that maintains the denormalized column in the database and displays the updated Order_Total whenever 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_PRI CE or QUANTITY fields.
Answer: C,D,E
05. There is a requirement to replace the standard List of Values functionality with a separate LOV from that will be invoked via a call to a procedure (show_lov_form).
This will be implemented via a button, but the [List] key and the Edit > Display List option in the default menu should also invoke the LOV form. Which triggers should you use?
A. A form-level Key-Listval trigger with the code
DO_KEY('LIST_VALUES');
and the When-Button-Pressed trigger with the code
show_lov_form;
B. A form-level Key-Listval trigger with the code
DO_KEY('LIST_VALUES');
and the When-Button-Pressed trigger with the code
DO_KEY('LIST_VALUES');
C. A form-level Key-Listval trigger with the code
show_lov_form;
and the When-Button-Pressed trigger with the code
DO_KEY('LIST_VALUES');
D. A form-level Key-Listval trigger with the code
LIST_VALUES;
and the When-Button-Pressed trigger with the code
EXECUTE_TRIGGER('show_lov_form');
Answer: C
06. You want to create a calculated item in the Control block of the Human Resourced 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?
A. You can create it by first creating a text item and then changing the item type.
B. You can create it in the Layout Editor using a special tool that creates a calculated item.
C. You can create it by first creating a display item and then setting appropriate properties in its Calculation property group.
D. 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
07. The LINE data block is defined in the Order.fmb module. LINE items are displayed in the default window at run time. In a second window, called BUTTONS, you display a set of icon buttons. At run time, the user must be able to freely navigate between the two windows.
Which statement identifies the types of windows to define?
A. Both windows must be defined as dialog and modal.
B. Both windows must be defined as document and modal.
C. Both windows must be defined as document and modeless.
D. The default window must be defined as modeless and the BUTTONS window must be modal.
E. The default window must be defined as modal and the BUTTONS window must be modeless.
Answer: C
0 Comments