1Z0-151 Online Practice Questions and Answers

The Order Entry application contains several forms. The inventories form uses an LOV that is based on a record group that queries the Warehouses table to return a warehouse ID. Several of the forms use LOVs that are based on the same query. You decide to centralize the creation of the record group to the entry form of the application, which opens all the other forms, for example, to open the inventories form, there is a When-Button Pressed trigger on the inventories button with the following code;

OPEN _FORM ('inventories');

in a When-New-Form-instance trigger for the entry form, you create the warehouse_rg record group by

using the CREATE_GROUP_QUERY built in with the following arguments:

('warehouse_rg' , 'SELECT ALL WAREHOUSE.WAREHOUSE_ID, WAREHOUSE.WAREHOUSE_NAME FORM WAREHOUSE order by warehouse_name);

You also populate the record group in this trigger.

What must you do to make this record group available to the inventories form and the other forms?

A. in the When-New-Form-instance trigger for the entry form, add a values for the SCOPE argument of CREATE_GROUP_QUERY.

B. in the entry form, move the record group code to the end of the When-Button-Pressed triggers for the buttons that open other forms, so that the record group is created and populated immediately after OPEN_FORM is called.

C. in the entry form, move the record group code to the beginning of the When-Button-Pressed triggers for the button that open other forms, so that the record group is created and populated just before OPEN_FORM is called.

D. in the When-Button_Pressed triggers of the entry from the buttons that open other forms, add a value for the SESSION argument of OPEN_FORM.

E. in the other forms, refer to the record group as: global.warehouse_rg.

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.

On the Employees form, you do not want the cursor to enter the Employee_Id text item, which is the first item in the first block on the form. You code a Pre-Text-item trigger for that item that uses the GO_ITEM built-in to navigate to the next item.

What happens when you run the form from Forms Builder?

A. You receive a compilation error.

B. The form starts to run, but immediately closes. So If an error message Is displayed, you are unable to see it.

C. The form runs, but as soon as it appears, you receive a runtime error.

D. The form runs, but as soon as you perform any navigation, a runtime error occurs.

E. The form runs with no problem.

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

A. Copy the WebUtil object group from the WebUtil object library into a separate object library.

B. Subclass the WebUtil object group from the WebUtil object library into the Orders form.

C. Ensure that the WebUtil block is the last block under the Data Blocks node in the Object Navigator.

D. Ensure that the WebUtil block is the first block under the Data Blocks node in the Object Navigator.

E. Attach the WebUtil library to the Orders form.

F. Copy the WebUtil library to the same directory as the Orders form.

G. in the When-New-Form-instance trigger, register the WebUtil javaBeans.

H. Set the Implementation Class Property for any items that will implement WebUtil JavaBeans.

Iin 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 properties are not defined for this item.

Assuming that the following are defined, which three are valid settings for the initial Value = property of the Shipping_Date Item?

A. $$DBDATE$$

B. :Orders.Order_Date + 3

C. SYSDATE

D. :GLOBAL.SHIP_DATE

E. :PARAMETER.SHIP

F. ORDER_ITEMS_SEQ

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

A. An iconic list button appears next to the text item.

B. A list of values lamp appears as a tool tip when the cursor is placed over the text item.

C. A list of values lamp appears next to the text item.

D. A list of values lamp appears on the status line when the cursor enters the text item.

E. A button with an ellipsis appears in the text Item when the cursor enters the text item.

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 "Working" message from appearing?

A. Before the line of code that executes the query, add the line: :SYSTEM.MESSAGE_LEVEL := '10';

B. Before the line of code that executes the query, add the line: :SYSTEM.SUPPRESS_WORKING : = 'TRUE';

C. Use the SET_APPLICATION_PROPERTY built-in to set the message level in a When-New- Form-instance trigger.

D. You do not need to do anything, the default behavior of Forms is to display the "Working" message only if you add code to do so.

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 text item in that block. They must click the Next Block button to navigate from the Orders block to the Order Items block.

How should you investigate the source of the problem?

A. Check the Pre-Text-Item and Post-Text-Item triggers, because users may be encountering a navigation trap.

B. Check the Navigation properties of the Orders block that have non-default values.

C. Check the Navigation properties of the Order Items block that have non-default values.

D. Check the Navigation properties of the items in the Orders block that have non-default values.

E. Check the Navigation properties of the form that have non-default values.

F. Check that the items in the Order Items block are enabled.

View the Exhibit.

You have just created a new object library as shown in the Exhibit. You want the tabs to have descriptive names.

You cannot change the names of the default object library tabs, so you must create new tabs in order to have descriptive names.

A. True

B. False

View the Exhibit.

You are creating a menu for use with several forms. You create the structure of the menu in the Menu Editor.

As shown in the Object Navigator in the Exhibit, which objects are menu items?

A. MENU3 only

B. ITEM6 only

C. MENU3, ITEM4, ITEM5, ITEM5_MENU, and ITEMG

D. ITEM4, ITEM5, and ITEM6 only

E. ITEM4 and ITEM5 only

F. ITEM 4 and ITEM6 only

G. ITEM5 and ITEM only

H. MENU3 and ITEM5_MENU only