Unformatted text preview: a block temporarily, so that the restriction is in effect only for the first
query on the block after setting the property?
A. Set the Where Clause block property at design time
B. Set the DEFAULT_WHERE block property programmatically
C. Set the ONETIME_WHERE block property programmatically
D. Set the Onetime Where Clause block property at design time
E. Set the Default Where clause for the block either at design time or programmatically
F. Set the Onetime Where clause for the block either at design time or programmatically
Your company assigns three possible credit ratings to customers: Poor, Good, and Excellent (represented
numerically by 1, 2, and 3). The DBA has just added a RATING column to the CUSTOMERS table and
Actualtests.com - The Power of Knowing 1Z0-141
has asked you to add an item to your form so that credit ratings can be recorded.
To restrict data entry clerks to one of these three values, you decide to create a radio group for the
You want to allow for an undetermined (Null) credit rating, and users should be able to update the credit
rating from a value to an undetermined rating How can you implement this?
A. Create three radio buttons for each of the credit ratings, and set the Mapping of Other Values for the radio
group to Null
B. Create three radio buttons for each of the credit ratings, and set the Mapping of Other Values for the radio
group to one of the credit rating values.
C. Create four radio buttons, and leave blank the value for the undetermined credit rating
D. Choose a different type of input item, because radio groups do not allow entry and update of null values
Exhibit: View the Exhibit to examine the form.
The text items (Field1, Field2, and Field3) and the button (Check_Values) are in the CONTROL block.
The Mouse Navigate property of the button has been set to No.
The following code has been written in a When-Button-Pressed trigger on the Check_Values button:
MESSAGE(:field1 | |' - '| | :SYSTE...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09