1Z0-141 Demo and Sample
Note: Answers are below each question.
Samples are taken from full version.
You create a text item in the Object Navigator. Which property must you change from the default value 50 that the text item will not be part of the SOL statement when a query is issued on the block?
Which statement is true about built-ins that invoke one form from another?
CALL_FORM cannot be issued while in Enter-Query mode
CALL_FORM does not issue a save point
NEW_FORM invokes the second form in a modal state so the user can navigate freely between the two running forms
NEW_FORM improves performance but consumes more memory because the first form is retained in memory and returning to it is more efficient than reloading it
OPEN_FORM invokes the second form in a modeless state and optionally within a different transaction scope
OPEN_FORM is the only way to invoke the second form in "query only"
How can you restrict a query on a block temporarily, so that the restriction is in effect only for the first query on the block after setting the property?
Set the Where Clause block property at design time
Set the DEFAULT_WHERE block property programmatically
Set the ONETIME_WHERE block property programmatically
Set the Onetime Where Clause block property at design time
Set the Default Where clause for the block either at design time or programmatically
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
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 Rating item.
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?
Create three radio buttons for each of the credit ratings, and set the Mapping of Other Values for the radio group to Null
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.
Create four radio buttons, and leave blank the value for the undetermined credit rating
Choose a different type of input item, because radio groups do not allow entry and update of null values
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 | |' - '| | :SYSTEM.cursor_item | | '
'| | : SYSTEM.trlgger_item) ;
With the focus in Field1, and the values 1, 2 and 3 in the text items, what message will be displayed when the button is pressed?
field1 - 1 - CheckValues
1 - CONTROL.FIELD1 - CONTROL.FIELD1
1 _ CONTROL.FIELD1 - CONTROL.CHECK_VALUES
:field1 - SYSTEM.cursor_item - :SYSTEM.trigge_item
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 $2 5,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?
IF : EMPLOYEES. SALARY < 25000 THEN ...
IF COPY('EMPLOYEES.SALARY') < 25000 THEN ...
IF NAME_IN ('EMPLOYEES. SALARY') <25000 THEN ...
IF FIND_ITEM('EMPLOYEES.SALARY') < 25000 THEN ...
IF GET_ITEM_PROPERTY('EMPLOYEES.SALARY',DATABASE_VALUE) < 25000 THEN ...
The Products.fmb module has one content canvas, which displays information about products sold by your company.
You increase the canvas display area by creating an overlay canvas to enable product images to be displayed on request. At run time, however, the overlay canvas is never displayed; users complain that there is only a brief flash on their screen
How do you correct this problem?
Ensure that the current item is not hidden by the overlay canvas
Call the built-in GET _VIEW_PROPERTY to set the canvas VISIBLE property to True
In the Layout Editor, choose View Stacked Views Then select the overlay canvas in the Stacked Canvases dialog box
Change the stacking order of canvases under the Canvases node in the Object Navigator Ensure that the overlay canvas is the first canvas listed under this node.
Change the stacking order of canvases under the Canvases node in the Object Navigator. Ensure that the overlay canvas is the last canvas listed under this node
You are developing a form for a family-oriented video store. The form will run in query-only mode in a customer kiosk to show information about movies that are available to rent. The Rating item in the Movies block of the form shown in the upper portion of the exhibit displays the rating of the movie: G, PG, R, or X. Your customers are not interested in all these values, but they do want to see if the film is rated G to indicate that it is suitable for the whole family
You decide to change the item to a check box to be displayed as shown in the lower portion of the exhibit You want users to be able to query any movies, but only those with a G rating will have the check box selected.
You change the item type of the Rating item to Checkbox and set its Label, Value When Checked (G), and Prompt properties However, when you run the form to test it and execute an unrestricted query, only those movies with a rating of G are displayed.
What do you need to change so that all movies are returned by the query and the check box properly shows the "For the Whole Family" rating?
Set the Initial Value property of the Rating item to G
Set the Value When Unchecked property of the Rating item to null
Set the Checkbox Mapping of Other Values property of the Rating item to Checked
Set the Checkbox Mapping of Other Values property of the Rating item to Unchecked
Set the Update Allowed, Insert Allowed, and Delete Allowed Properties of the Movies block to No
Change the item type You cannot use a check box for this application because there are more than two possible values for the item
You are developing a customer information application for a pay television company. The customer's home telephone number is used as the account number for the customer. Clerks must be able to update the telephone number in case of changes or data entry errors.
A data entry clerk will typically open several forms from the Customers form that are synchronized with
the currently selected customer using a global variable containing the telephone number.
Although you also need to modify the other forms, what two triggers should you code in the Customers form to keep the forms synchronized in case the data entry clerk updates the telephone number or selects a different customer? (Choose two.)
When-Validate-ltem for the phone number item
When-New-ltem-lnstance for the phone number item
Answer: D, E
In an Order Entry form, the Order_Items block has a text item called Shipping_Date, which is of the Date data type The Lowest Allowed Value and the Highest Allowed Value properties are not defined for this item.
Assuming that all of the following are defined, which three are valid settings for the Initial Value property of the Shipping_Date item? (Choose three.)
: Orders.Order_date + 3
Answer: A, E, ?
To centralize some of your processing, you decide to write PUSQL library modules that contain procedures that can be called from form triggers or menu items.
You need to populate some fields based on values in other fields. Which code do you use?
IF FIND ITEM I 'ORDERS. order total' I > 10000 THEN
FIND_ITEM('ORDERS.large order')' :="Y';
MESSAGE ('WARNING- large order!); END IF;
IF :ORDERS.order total > 10000 THEN
:ORDERS.large order :="Y';
MESSAGE ('WARNING- large order!); END IF;
IF 'ORDERS. Order_total' > 10000 THEN
:ORDERS.large order :="Y'; MESSAGE ('WARNING- large order!); END IF;
IF :ORDERS.order_total> 10000 THEN
COPY ('ORDERS. large_order') ; MESSAGE ('WARNING- large order!); END IF;
IF NAME_IN ( 'ORDERS. Order_total' ) > 10000 THEN
COPY ('Y' ,'ORDERS. large_order') ; MESSAGE ('WARNING- large order!); END IF;
Read more Details »