1Z0-141 Exam Questions

View the Exhibit. The EMPLOYEES table contains 100 records. You are developing a Human Resources form that has an Employees block with properties as shown in the exhibit. When you...

View the Exhibit. You are modifying the New_Orders form. You want to change the navigation order of the Orders block so that Order_Status is between Order_Date and Order_Mode in th...

View the Exhibit. You are running a form in debug mode, but you have not set any breakpoints in the code. You click a button that invokes the code shown in the exhibit. While the c...

The Warehouse.fmb module contains two data blocks. You want to display items from each data block on separate content canvases. You must ensure that both content canvases are visib...

LibraryA and LibraryB are in the working directory of the Employees form. Library A is attached to the Employees form. There is a stored procedure in the database called Raise_Sala...

In the Orders form, you create a button in the CONTROL block to send the input focus to the INVENTORIES block and cause it to be queried. You write this code in a When-Button-Press...

A form named Orders is saved to the file system as MY_ORDERS.FMB. You are modifying the Customers form, and you want to code a When-Button-Pressed trigger to invoke the Orders form...

You are developing an application for use by meteorologists. Form1 contains a list item based on a query of cloud types that are stored in a database table. Users can add cloud typ...

During testing, you received comments that the default functionality of the [Commit] key can cause an error message to be displayed if there are no changes to save when it was acti...

View the Exhibit. You are developing an account management system for First National Bank. The Layout Editor for the Customer form is shown in the exhibit. The three buttons on the...

View the Exhibit. You have created three list items, each of which is in a different list style. You have defined the same four list elements for each list item. The exhibit depict...

You are testing a form. How can you programmatically disable validation during testing?

You are running a multiple-form application. The Customers form invokes the Orders form. When the Orders form launches, it displays orders for only the active customer from the Cus...

View the Exhibit. In the Human Resources form shown in the exhibit, you want to modify the prompts, heights, and widths of the Department Id, Manager Id, and Location Id fields in...

Which three statements best describe a Ref Cursor in Forms Builder? (Choose three.)

The validation unit for the Orders form is set to Item. This master-detail form contains an Orders block and a multirecord Order Items block. Why might you want to create a When- V...

The following On-Error trigger was written to give users a more meaningful message when they press the Up key when the cursor is in the first record (the FRM-40100 error) and to di...

View the Exhibit. 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 av...

There is a requirement to invoke the Orders form from the Customers form. Your colleagues offer some suggestions about which built-in to use and their reasons for the choice. Which...

View the Exhibit. master-detail form displays Orders and Order Items. What can you tell about the run-time behavior of the form by looking at the exhibit, assuming that the master-...

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 propertie...

The DBA informed you that a number column called ORDER_STATUS has been added to the ORDERS table. You want to update the Order Entry form to display the additional data. You open t...

A user has requested a change to the Summit.fmb module. The form has two windows, DEPT_WIN and EMP_WIN. DEPT_WIN is always visible to the user. However, EMP_WIN is only occasionall...

You write a form in which there are two text items (FIELD1 and FIELD2) and a button (BTN1) arranged in the following navigation sequence: FIELD1, BTN1, FIELD2 With the focus in FIE...

You need to restrict access to a form. Access must be limited to particular times of the day and to certain authorized users. You write a procedure (get_authorization) in the form...

The database EMPLOYEES table has a foreign key constraint referencing the DEPARTMENTS table. You are developing a Human Resources application. HR clerks use the Employees form to q...

There is a requirement to modify the default functionality of the [Commit] key. To implement this requirement, you decide to write a Key-Commit trigger that will force validation a...

View the Exhibit. You are running the Employees form in debug mode and stepping through a procedure (as shown in the exhibit). You know that the stored function RAISE_SALARIES perf...

The menu that appears by default in a Forms application does not quite meet your needs, so you decide to create a custom menu. You create and compile a menu module called Test with...

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...

You have been asked to define a data block based on a query that is dependent on SQL only. The data will not be updated by the user. Selection of the tables to be queried will be d...

The Products.fmb module has one content canvas, which displays information about products sold by your company. You want to increase the canvas display area by creating an overlay...

View the Exhibit. You created and compiled the Summit menu whose properties are shown in the exhibit. You attach the menu to the Orders form and run it to test the menu. In additio...

In the Product.fmb module, data block items are displayed on two content canvases. You define a set of icon buttons that users must have access to at all times. Which canvas type i...

An application uses a menu that contains a Check type menu item. You have programmatically obtained the menu item ID of the Check item and now you want to write code to toggle its...

The following On-Error trigger was written to give users a more meaningful message when they press the Up key when the cursor is in the first record (the FRM-40100 error) and to di...

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 t...

The database EMPLOYEES table has a foreign key constraint referencing the DEPARTMENTS table. You are developing a Human Resources application. HR clerks use the Employees form to q...

The Warehouse.fmb module contains two data blocks. You want to display items from each data block on separate content canvases. You must ensure that both content canvases are visib...

You have an image item in the Employees form to display an employee photograph. The image item has default values for its properties. You are trying to decide where to place some c...

An application is accessed through the Summit form, which can open the Customers form and the Orders form. The Customers form can also open the Orders form, and the Orders form can...

You created a LOV based upon a three-column Record Group called CUST, which was created at design time. View the Exhibit and examine the structure of the CUST Record Group. At run...

You want to standardize the appearance of certain text items in a particular form, so you create a Visual Attribute called TEXT_ITEM_VA and define values for all of its properties....

What happens when you click Run Form Debug in Forms Builder?

View the Exhibit. 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...

View the Exhibit and examine the form. The Orders form consists of a single-record master block (ORDERS) and a multirecord detail block (ORDER_ITEMS). Form-level triggers have been...

View the Exhibit. You have created three list items, each of which is in a different list style. You have defined the same four list elements for each list item. The exhibit depict...

View the Exhibit. You have created a menu for the Summit Office Supply application that you attach to its main form. The menu, whose Menu Editor is shown in the exhibit, contains s...

View the Exhibit. You are developing an Order Entry form. The When-New-Form-Instance trigger executes a query on the only block in the form. Instead of the alert shown in the exhib...

What type of message indicates a Forms message that cannot be suppressed?