1Z0-151 Online Practice Questions and Answers

The Orders form has four blocks. The Orders and Order_items block are on the CV_Order content canvas;

the inventories block items are on the CV_inventories content canvas; and Control block buttons are on the

CV_Buttons toolbar canvas. All buttons have mouse Navigate set to No.

The Order_Items block is a detail of Orders. The inventories block is a detail of Order_Items, showing the

stock of the selected product.

There is a button in the Control block with a When-Button-Pressed trigger:

IF GET_CANVAS_PROPERTY(:SYSTEM.cursor_item, item_canvas) = 'CV_ORDER' THEN GO_BLOCK

('inventories')

ELSE

GO_BLOCK('orders');

END IF;

When you run the form and click the button, navigation does not occur, and the form displays the runtime

error "FRM-41053: Cannot find Canvas: invalid ID." What should you do to correct this problem?

A. Change the sequence of blocks in the Object Navigator

B. Chang the Mouse Navigator property of the button to yes

C. in the first line of code, change the built-in to GET_ITEM_PROPERTY

D. in the first line of code, change the system variable to: SYSTEM.CURSOR_CANVAS.

E. in the first line of code, change the CV_ORDER to lowercase

F. Chang the argument to the GO_BLOCK built-ins to uppercase

You put some code in a Post_Update trigger and raise the FORM_TRIGGER_FAILURE under certain conditions. Does a rollback take place if the trigger falls?

A. Yes. Although the update has been applied to the database, the old column values are retained as rollback data; so a failure of this trigger automatically reinstates the original values.

B. No. It is too late to perform a rollback at this stage because the update has already been applied.

C. The value have already been applied, so you must programmatically save the old values in the global variables or PL/SQL variables if you want to reinstall the original values.

Yon have created a list item for the Credit__Rating field in the Customers form, the Finance department usually determines a range of scores that pertain to the customer, the values in the list are Excellent, Good, Fair, and Poor, corresponding to the ranges provided by Finance. The default value Fair, because that is the range that applies to most customers.

Sometimes, Finance can provide an exact credit score; so users must be able to enter the exact numerical value if it is known. Often clerks enter the customer data before the performance of a credit check, so they must be able to enter a blank value if the credit rating is not yet determined.

Users want to be able to select a blank value from the list, but the list does not display a blank line for them to select. How can you meet this requirement without changing the default value of the list item?

A. Add a blank line to the list item when you define the static values.

B. Set Mapping of other Values for the Credit_Rating Item to NULL.

C. Set the Required property of the Credit_Rating item to No.

D. Delete the NOT NULL constraint for the Credit_Rating Column in the database.

E. You cannot change this type of list item to display a blank value; users must delete the default value records if the credit rating is not known.

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 interact with all the items and switch between them without scrolling or closing anything?

A. Define multiple content canvases and display them in multiple modeless windows.

B. Define multiple content canvases and display them in the same modeless window.

C. Define multiple content canvases and display them in multiple modal windows.

D. Define multiple content canvases; display one in a modeless window and the others in modal windows.

E. This is not possible because items from a single block must be displayed on the same canvas and window.

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 Children node of the object group.

What is the reason for this?

A. You cannot drag a canvas to an object group.

B. You cannot drag a block to an object group.

C. You need separate object groups for different types of objects.

D. You cannot drag multiple types of objects to an object group at the same time.

E. You should drag them to the ObjectGroup96 node, not to its Object Group Children node.

You add a display item named Quantity to the Order items block of your Orders form to display the quantity on hand for each product. Quantity is a non-base table item that should reflect the count of an ordered product from the inventories table.

What is the best way to populate the Order_Iterns.Quantity item?

A. Post-Query trigger

B. Pre Query trigger

C. When-New-Form-instance trigger

D. When New-Item-instance trigger

E. You need to define a master-detail relation so that the item is populated automatically.

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 appearance of objects in the form. For example, all buttons should be of the same width.

The CV_Tools canvas contains several buttons. The Print invoice button is not quite wide enough to display its complete label.

In forms Builder, you open the Button_PC property class and change its Width property to a higher number. All the buttons become larger except the Print invoice button, which remains its original size. What could have caused this problem?

A. The Print invoice button was copied from, rather than subclassed from, the Button_PC property class.

B. The subclass information property for the Print invoice button is blank.

C. The Width property of the Print invoice button is an inherited property.

D. The Width property of the Button_PC property class is a variant property.

E. The X Position of the print invoice button is a variant property.

F. The X Position Property is not included in the Button_PC property

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 the hierarchical tree shown in Exhibit 1 have been changed from the default?

A. Allow Empty Branches and Multi Selection only

B. Allow Empty Branches and Show Symbols only

C. Multi Selection and Show Symbols only

D. Allow Empty Branches, Multi Selection, and Show Symbols

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.

View the Exhibit.

What four facts can you determine by examining the Object Navigator?

A. The Orders block is a detail block.

B. The Order_Items block is a detail block.

C. An order can be deleted only if it has no order items.

D. If an order is deleted, all of its order items are deleted.

E. You cannot delete order items without deleting the order.

F. You can delete an order without deleting its order items.

G. The Orders block is a master block.

H. The Order_Items block is a master block.

I. If you delete an order item, all of its associated inventory items are deleted.

J. The inventories block is a master block.