1Z0-141 Exam Questions

The Orders form is required to initialize differently for different users. A database procedure (GET_ROLE_NAME) is used to determine which database roles are enabled for the user l...

You want users to be able to add values to a list item at run time. How do you achieve this?

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

The Orders form has two base table blocks and a control block. There is an Execute Query button in the control block with the following When-Button-Pressed trigger: DO_KEY('execute...

You are developing a Human Resources form for HR clerks to insert, update, and delete records from the EMPLOYEES table. You are also maintaining an audit table with the following t...

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

View the Exhibit. You want to create a menu item to enable users to sort the tabular display of a form either by customer ID, last name, or department ID. You decide to create a ra...

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

View the Exhibit. The Name text item is subclassed from a property class. Which two statements are true about the Keyboard Navigable property of the Name text item whose Property P...

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

What are two ways that you can assign a value to an item on a form from within the code of a menu item? (Choose two).

Which two statements about FORM_TRIGGER_FAILURE are true? (Choose two).

While using the LOV Wizard to create the LOV called SALES_REP_LOV, which is based on the SALES_REP_RG record group, you assign it to the Sales_Rep_Name item in the form that you ar...

View the Exhibit. You are developing and testing a Forms application on a machine that has plenty of memory. The Customers block, whose Property Palette is shown in the exhibit, is...

View the Exhibit and examine the PL/SQL code. The code uses the valmess package, which should print out the employee's salary if it exceeds 2345. To resolve compiler or run-time er...

You have been asked to correct a problem with a form that was created by another developer. Users complain that they are unable to query on the employee Hire Date, which is a base...

The user must be able to invoke a list of values for valid sales representatives in the Orders form. To facilitate this, you created a button and positioned it next to the Sales Re...

An Order Entry form that you are developing contains several blocks. The first is a control block where you create buttons to perform certain actions. One button, which is mouse an...

In your Employee.fmb module you have an EMP block, which is currently on a content canvas. You want to display items from the EMP block on a new tab canvas. What are two ways to ac...

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

Which three menu item types are valid in a menu module? (Choose three.)

You are building two forms. Each form has a button and a non-base table field. When the button is pressed, a complicated calculation is executed. The calculation code queries data...

You are creating a new form for the Order Entry application. You define a record group that will be created when the form is executing using this built-in: CREATE_GROUP(rg_emplist,...

Which value is valid for the iterate parameter in the CREATE_TIMER built-in function?

At design time, you create a query record group for the LOV associated with the HOTEL text item in a form module for the Travel Planner Application. When is the record group popula...

You create a multiple form application. Which built-in must you use to invoke the form modules to enable you to programmatically control navigation between the multiple forms in yo...

You create a master-detail form. The users need to be able to exit the form quickly, adhering to default transaction processing, regardless of the cursor location. You believe you...

You want to create a pie-style chart using the Chart Wizard. What must you do to determine the fields available for use in this chart?

Which two triggers are mouse movement triggers? (Choose two.)

You want to provide a tool that allows users quick access to form modules, by listing them in an Explorer-style interface. Which reusable component do you use?

You created a custom menu for the Order Entry application. The shipping administrator has requested an additional submenu containing four items to invoke various reports . Which co...

Which two built-ins would you use to remove the HOUR_ALARM timer using the timer_id parameter? (Choose two.)

You need to create a data block for query operations in the RETIRED_EMPLOYEES form module. Which three data sources can you use for this block? (Choose three.)

You create a data block based on a relational table containing a REF column. You select the REF column for your form module. What is true about the items based on the REF column at...