Online Access Free 1z0-151 Practice Test

View the Exhibit.

You are creating a menu for use with several forms. You create the structure of the menu in the Menu Editor.
As shown in the Object Navigator in the Exhibit, which objects are menu items?

• A.MENU3, ITEM4, ITEM5, ITEM5_MENU, and ITEMG
• B.MENU3 and ITEM5_MENU only
• C.ITEM4, ITEM5, and ITEM6 only
• D.ITEM5 and ITEM only
• E.ITEM4 and ITEM5 only
• F.MENU3 only
• G.ITEM 4 and ITEM6 only
• H.ITEM6 only

When you plan to use a toolbar canvas, you should allow room for it on the content canvas so that items on the canvas are not obscured.

• A.True
• B.False

Which statement is always true about a visual indicator that a text item has a list of values associated with it?

• A.An iconic list button appears next to the text item.
• B.A list of values lamp appears next to the text item.
• C.A list of values lamp appears as a tool tip when the cursor is placed over the text item.
• D.A list of values lamp appears on the status line when the cursor enters the text item.
• E.A button with an ellipsis appears in the text Item when the cursor enters the text item.

The Credit_Rating item in the Customers block of an Order Entry form must be restricted to three possible values: Good, Poor, or Null (the latter value indicates that the credit rating has not been determined). Order entry clerks must be able to update this item to any of the preceding three values.
You want to change the item to a check box labeled "Credit Risk" that should be selected if the customer has poor credit, the check box should not be selected if the customer's credit rating is good or undetermined.

You change the item type to Checkbox, set other properties as shown in the Exhibit, and then run your form and insert three records: two with good credit and the check box deselected, and one with poor credit and the check box selected. You commit the data and query the records, with the following result set:

The first two records show an undetermined credit rating, although your intention was to set the value to Good for these customers. What change must you make in the properties of the Credit_Ratinq item to enable values of Good, Poor, and Null to be entered?

• A.Change the initial Value property to Good and the Value When Unchecked property to Null.
• B.Change the initial Value property to Good.
• C.Change the item type. It is not appropriate to use a check box to enable entry and update of more than two values in an item.
• D.Change the Check Box Mapping of Other Values property to Not Allowed.
• E.Change the initial Value property to Good and the Check Box Mapping of Other Values property to checked.
• F.Change the initial Value property to Good and the Chock Box Mapping of Other Valued property to Null.

You do not want users to execute queries while in the Order_Items block, so you write the following key-Exeqry trigger for the Order_Items block:
GO_BLOCK('orders');
EXECUTE_QUERY;
This works fine except that in the Order_Items block, when you click Enter Query first, and then click Execute Query, you get the error message "FRM-41009: Function key not allowed." What can you do correct this?

• A.Delete the Key-Exqry trigger and define the following Key-Entqry trigger for the Order_Items block:
  ENTER_QUERY;
  GO_BLOCK ('orders');
• B.Change the Key-Exeqry trigger to:
  IF :SYSTEM.MODE != 'ENTER-QUERY' THEN
  GO_BLOCK('orders');
  EXECUTE_QUERY;
  ELSE
  MESSAGE ('You cannot execute a query in this block');
  ENTER_QUERY;
  GO_BLOCK ('orders');
• C.You cannot change this behavior, but you should use the On-Message trigger to display a more meaningful message.
• D.Delete the Key-Exqry trigger and define the following Key-Entqry trigger for the Order_Items block:
  GO_BLOCK ('orders');
  ENTER_QUERY;
• E.Add the following as the first of the key-Exqry trigger to Yes.
  SYSTEM.mode := 'NORMAL';
• F.Set the Fire in Enter-Query Mode property of the Key-Exeqry trigger to Yes.
• G.Change the key-Exqry trigger to:
  IF : SYSTEM.MODE := 'ENTER-QUERY' THEN
  GO_BLOCK ('orders');
  EXECUTE_QUERY;
  ELSE
  MESSAGE ('you cannot execute a query for the Order_Items block'):
  END IF;
  Define the following Key-Entqry trigger for the Order_Items block:
  GO_BLOCK ('orders');
  ENTER_QUERY