1Z0-151 Exam Questions

You want to display employee records in tabular format, but the form is not wide enough to display all the items in the Employees block. The employee IDs and names of displayed rec...

You have created a complex menu structure with several types of menu objects. To which objects would you assign menu commands?

To avoid overloading the database during busy times, you decide to restrict the queries that are executed on the Orders form so that users query by either Order ID or Customer ID d...

View the Exhibit. The Departments table in the database contains four columns. In a new form, you use the Data Block Wizard to add all columns to the block, but in the layout Wizar...

A clerk is using the Human Resources form, which displays a department and its associated employees on the same canvas. Only two Items in the form are enabled. Possible navigation...

You want to use WebUtil functionality in the Orders form. What three things must you do to integrate WebUtil into the Orders Form?

The Employees database table contains more columns than can be displayed at one time in a form. You create a data block that uses all the columns. How can you enable users to inter...

You have designed a form with two content canvases. The window for the first canvas was created implicitly, and you have not changed its default properties. You want users to be ab...

Identify a function of the Forms Servlet.

Your company applies three different interest rates for customers based on their credit rating, which is classified as being Excellent, Fair, Poor or Unknown. In the years past, cl...

A user at a remote location reports a problem that occurs when the Orders; form runs and the user clicks the invoice button. You are not able to reproduce the problem, so you decid...

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 wish to use a javaBean in a form. This javaBean has no visible component. You use the Layout Editor to create a bean area item that implements this JavaBean. You want to be abl...

You have a form that called a database stored procedure. You do not want processing to continue, so immediately after the call to the stored procedure, you add the following code:...

View the Exhibit. You have integrated the WebUtil utility into the Orders form. You code a When- Button-Pressed trigger to call some WebUtil functionality, and then run the form to...

You want to use the Forms Debugger to diagnose a problem with the RAISE_STATUS program unit that is stored in the database. Forms Builder, you set a breakpoint in the stored code,...

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

View the Exhibit. The Summit menu is attached to the Orders form. The Toggle Autoquery menu item is a check box that toggles whether a query is automatically performed when the Ord...

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

The Orders form has the following triggers defined: 1. Post-Text-Item on Customer_Id 2. Pre-Text-Item on Sales_Rep_Id 3. When-New-Item-instance on Sales_Rep_Id The form's Validatio...

You create a Customers form by using wizards. When you test the form, you notice that you cannot the complete name that is displayed in the Customer_Name text item. Which three too...

View the exhibit. In the OrderItemsForm, you have a control with a button that users can click to navigate to the first record in the block. The button has keyboard Navigable and M...

Immediately after creating a button in the Layout Editor, what is true about the button?

The Enforce Primary Key property of a data block ensures that the primary key of a new record exists in the database.

Users do not want to see the "Working" message while a long query completes. You are designing a form with a query that takes o long time to execute. What can you do to stop the "W...

View the Exhibit. You have begun the process of integrating WebUtil into the Ordes form. What two additional steps must be completed yet?

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

You have been assigned to maintain a forms application that was designed by a developer who has left the company. The form uses different property classes to standardize the appear...

The Orders form has three blocks: Orders, Orders_Items, and inventories. It also has a button labeled Next Block with a When-Pressed trigger. IF :SYSTEM.cursor_block = 'orders' THE...

Which setting of :SYSTEM.MESSAGE_LEVEL suppresses all system messages?

The Orders application enables the Orders form to be opened from the Customers form. Users are confused because when they save a new or changed order, they sometimes receive an err...

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

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

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

In the Orders form, users often have a need to return to the first record. Because there are many employee records, it may take a long time for them to scroll up to the first recor...

View the Exhibit. The orders form contains two canvases. Orders_CV displays one order and all of its order items. Help-CV displays context-sensitive help. When users invoke the hel...

View the Exhibits.The hierarchical tree shown at run time in Exhibit 1 is populated programmatically. Default hierarchical tree properties are shown in Exhibit? Which properties of...

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.

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

You have been assigned to maintain the Orders form. Users complain that if the cursor is in the in the Orders block, they cannot navigate to the Order Items block by clicking a tex...

You have coded the following When Button Pressed trigger: EXECUTE_QUERY; MESSAGE ('Query executed on block'); MESSAGE ('click next to navigate the next record'); When the user clic...

Which two actions are always necessary when deploying Forms applications that were developed on Windows platform to a UNIX middle tier server?

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?

You are using a PL/SQL program unit in the Orders form to display an image for the selected product in the Order Items block. The code is called from several different triggers in...

View the Exhibit. To test how the Orders application works with database triggers, you add to the Orders table the following database trigger that fires before the update of Custom...

To troubleshoot a problem with a form, you have added a call to the MESSAGE () built-in at the beginning of the When-Validate-Item trigger of the Customer_Id then in the Orders Blo...

You have just created radio buttons labeled Outstanding, Exceeds, Meets, and Does not Meet for the employee appraisal rating, but you accidentally created it on the Employee_Traini...

Which type of variable must be declared before it is used in a trigger?

View the Exhibit. You have defined the window, canvas, and text items shown in the Exhibit. What happens when click Run Form?