1Z0-151 Online Practice Questions and Answers

You have created an editor named MyEditor, and you want it to be available to edit the text item Product_Description. You can associate the editor with the text item by setting the Editor property of Product_Description to MyEditor.

A. True

B. False

View the Exhibit.

The DBA has added a 30-character Cust_Middle_Name field to the Customers table and wants you to add it to the Customers form. It should be on the same line as the as the first and last names, which are on the Name tab page of the Tab_Customer canvas that appears in the Layout Editor as shown in the Exhibit. The Tab_Customer tabbed canvas is displayed on the Customer_CV content canvas as shown in the Exhibit.

What must you do to accommodate the additional label and text item and to display the middle name?

A. increase the Width property of the Customer_CV canvas only.

B. increase the Width property of the Tab_Customer canvas only.

C. increase the Width properties of only the Customer_CV canvas and the Tab_Customer canvas.

D. increase the Width properties of the Customer_CV canvas, the Tab_Customer canvas, and the name tab page.

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 as a tool tip when the cursor is placed over the text item.

C. A list of values lamp appears next to 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.

You want to display fields of a form module on multiple layouts that are visible simultaneously, what can enable you to achieve this?

A. multiple content canvases that display in the same window

B. one content canvas that displays in multiple windows

C. multiple content canvases that display in multiple windows

D. multiple forms, because you cannot have multiple content canvases in the same form that are visible simultaneously

View the Exhibit.

The Departments form has form level triggers defined as shown in the Exhibit. You have enabled array DML for the Departments block by setting its DML array size to 5 and setting the Primary Key property of Department id to Yes. You set runtime preferences for Forms Builder to use array processing.

You want to test that array processing is actually occurring, so, as shown in the Exhibit, the On- Update, On-Delete, and on insert triggers have code that:

1.

Displays a message to indicate which trigger is firing for which record?

2.

Does the thing (either updates, deletes, or inserts)

The other triggers simply display a message, indicating the trigger that is firing.

You run the form from Forms Builder, but from the messages, you can tell that array processing is not occurring. What should you change so that array DML gets implemented?

A. Delete the "On-" triggers; these triggers remove default processing, including array processing.

B. Set the DML array size to a value of 10 or greater; for array sizes loss than 10, array processing Is inefficient, and so is not performed.

C. Use the SYNCHRONIZE built-in after the MESSAGE built-in; otherwise, the message are not displayed until the processing is finished, giving the appearance that array processing is not taking place.

D. Set the Enforce Primary Key property of the Department block to Yes; it is not enough to just set the Department_Id to be the primary key.

You have written a When-Validate-Item trigger. You want this trigger to fire even if the form is in Enter-Query mode. What must you do to achieve this?

A. Use the following code at the start of the When Validate-Item trigger: :SYSTEM.mode := 'ENTER-QUERY';

B. Use the following code at the start of the When Validate Item trigger: :SYSTEM.mode := 'NORMAL';

C. Set the Fire in Enter Query Mode property of the When-Validate-Item trigger.

D. You do not need to do anything, because the default for the When Validate Item trigger is to fire in Enter-Query mode.

E. You cannot achieve this, because the When-Validate-Item trigger cannot be set to fire in Enter-Query mode.

View the Exhibit.

You have just created a new object library as shown in the Exhibit. You want the tabs to have descriptive names.

You cannot change the names of the default object library tabs, so you must create new tabs in order to have descriptive names.

A. True

B. False

Customers log in to your Orders application by using their customer ID, which is saved as a global variable. When the Orders form first comes up, you want it to be populated with the customer's orders, and you do not want customers to be able to query for another customer's orders.

You code the following triggers:

When-New Form instance on the Orders form:

GO_BLOCK('orders'); EXECUTE_QUERY;

You also have a button in the Control block labeled Query Orders with a When-Button Pressed trigger that has the same code as the When New-Form instance trigger. To test the form, you run it and log in a Customer 104. When you click Query Orders, all orders are shown, not just those for Customer 104.

What is the best way to correct this issue to ensure that the customer can never query another customer's orders?

A. Delete the Key-Exeqry trigger and add the its first line after the call to GO_BLOCK in the When-NewForm-instance trigger.

B. Change the last line of the When-Button-Pressed code to: DO_KEY ('EXECUTE_QUERY');

C. Delete the Key-Exqry trigger and put its code in an On-Select trigger.

D. Delete the Key-Exqry trigger and put its code in a Pre-Query trigger.

When users enter address information, you want them to be able to select the state from a static list of values. You have not used a list of states before, and there is no database table that contains state information.

What is the first step in creating such a list of values as quickly as possible?

A. invoke the LOV wizard.

B. Create a new record group that is based on a SQL query.

C. Create a new static record group.

D. Create a list item instead; a list of values is not appropriate for a static list.

The Orders form, you want to enable users to use Microsoft Excel to create and print an invoice for the customer. The file should be created on the user's computer so that it can be printed with the local printer.

Which WebUtil package would you use to implement this requirement?

A. CLIENT_GET_FILE_NAME

B. CLIENT_HOST

C. CLIENT_OLE2

D. CLIENT_TEXT_IO

E. CLIENT_Win_API

F. WEBUTIL_FILE

G. WEBUTIL_UTIL