1Z0-141 Exam Questions

Which statement is true about client-side validation?

Which three statements about display items are true? (Choose three.)

Which two statements are true of a Query Record Group? (Choose two.)

The DBA informed you that a number column called ORDER_STATUS has been added to the ORDERS table. The DBA ran a SQL script to populate that column. You want to update the Orders fo...

The Summit application contains several different forms. You are developing the Orders form of the Summit application. You have coded a trigger in the form to retrieve and format t...

You should enable the user to add additional values to a list item at run time. You must also ensure that the Record Group LOCATIONS, which is used to populate the list item, can b...

You are developing a form that uses alerts to display database messages rather than associated FRM messages when the SQL statements issued by the form cause database errors to occu...

You are developing a form for customers to order tickets to events. There is an Event_Date item in the Tickets block of the form that has an LOV whose record group uses the followi...

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

You are developing a Human Resources application, and you create an Employees button in the Departments form. The When-Button-Pressed trigger calls the Employees form to display th...

You are developing a form that serves as a front end to access the Order Entry application. Within the form you want to store the usernames of those users who have permission to ru...

You are developing a Human Resources form with a single block to display employees. For each employee, you look up the department name to display in a non-base-table item. When you...

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

Order entry clerks use the Orders form to enter the shipping date of an order. Once the shipping date has been entered into the database, the clerks are not allowed to modify it. W...

You created a query Record Group at design time. Which built-in can you use to execute the query defined in the Record Group object?

Some forms that you wrote have been through part of the testing cycle. One of the testers has reported encountering a navigation trap in your Orders form in which the cursor appare...

View the Exhibit. You are developing a Human Resources application. There is a query-only form that displays employee IDs, names, and department numbers. When users double-click an...

You apply the Btn_PC property class to the Exit button and then make several changes in the property values of the button. The Btn_PC property class includes the item type Push But...

View the Exhibit and examine the PL/SQL block. To resolve compiler or run-time errors, what three changes could you make to this code? (Choose three.)

View the Exhibit. You are attempting to drag the Control and CV_Order objects to an object group as shown in the exhibit, but you are unable to release them in the Object Group Chi...

You are running a form in debug mode and you begin to step through the code of a lengthy subprogram. After stepping through a few lines of its code, you realize that the error come...

You create a text item in the Object Navigator. Which property must you change from the default value so that the text item will not be part of the SQL statement when a query is is...

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?

You have been asked to define a data block based on a JOIN of multiple tables. The read- only data will be used for calculations and lookups. The DBA is on holiday and is unable to...

The Orders.fmb module contains two content canvases, both associated with the default window. Items from the DEPT data block are associated with the DEPTCAN canvas. Items from the...

View the Exhibit. You are coding a trigger (shown in the exhibit) to display the database error that occurs when users encounter the FRM-40505 error about being unable to execute a...

While updating an existing customer record using the Customers form, the user invoked the Orders form by clicking the CONTROL.Orders_btn button. The When-Button-Pressed trigger had...

The Orders table in the database contains several thousand records. There is a block in the Orders form that is based on the ORDERS table and displays one record. The block is orde...

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

View the Exhibit and examine the Property Palettes of the BONNY canvas and the CLYDE window. The requirements of the application specify that the CLYDE window should not be resizab...

Which three statements best describe a Table of Records in Forms Builder? (Choose three.)

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

You are building the Customer.fmb module, and you define a multirecord data block based on the CUSTOMERS table. The data block is called CUST. You specify a Tabular layout style fo...

The two-column LOCATION Record Group has 10 rows. At run time, the user wants to mark two or more LOCATION records for use by another Forms Builder object. The rows will be used to...

You designed a standard toolbar to accompany a number of forms so the code behind the buttons is written as generically as possible. One of the features of this toolbar is that the...

Which statement is true about built-ins that invoke one form from another?

You want to create a calculated item in the Control block of the Human Resources form. This item will contain the total of employee salaries for employees in a particular departmen...

You have the Orders form open in Forms Builder. You create an object group in the Orders form and you try to drag various components in the Object Navigator to the object group. Wh...

Which two statements correctly describe the relationship between a content canvas and a window? (Choose two.)

In a multiform application, one form must invoke another. The form modules are called Customers and Orders internally, but the compiled files are saved as CUST.FMX and ORD.FMX, res...

Consider the following scenario: In a multiform application, the user started in FormA. 1. From FormA, the user invoked FormB using CALL_FORM. 2. From FormB, the user invoked FormC...

In the Orders form you define five LOVs, and you create one button to be used to display any of the LOVs. The button is enabled only when the user navigates to a field with an atta...

To centralize some of your processing, you decide to write PL/SQL library modules that contain procedures that can be called from form triggers or menu items. You need to populate...

View the Exhibit. You are coding a When-New-Form-Instance trigger to populate a hierarchical tree item called Emp_Tree that should initially appear as shown in the exhibit. Mr. Kin...

You need to resize the INVENTORY tab canvas. The Viewport Width and Height properties are 200 and 300. You change the values to 150 and 120, respectively. What implication may this...

Which two statements about a Non-Query Record Group are true? (Choose two.)

You are developing a Human Resources form for HR clerks to insert, update, and delete records from the EMPLOYEES table. When the user commits records, Forms displays the default in...

Which statement about the Data properties of a text item is true?

View the Exhibit. You are coding a trigger (shown in the exhibit) to display the database error that occurs when users encounter the FRM-40505 error about being unable to execute a...

What is an indication that the Data Block Wizard is in reentrant mode?