1Z0-151 Online Practice Questions and Answers

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.

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 able to see the bean area item in the Layout Editor so that you can easily interact with it at design time.

What can you do to ensure that the bean area item does not appear on the form at run time?

A. Set its Visible property to No.

B. Set its Height and Width properties to 1.

C. Set its Implementation class programmatically at run time.

D. You do not have to do anything; if Implementation Class does not display a visible component, the bean area does not show at run time.

E. You cannot avoid displaying the Bean area at run time.

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

A. It is an iconic button.

B. It has no functionality.

C. It is not mouse navigable.

D. It is not keyboard navigable.

E. It is in the control block by default.

F. It is not enabled.

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.

A. True

B. False

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 has been set to No.

The following code as been written in a When-Button-Pressed trigger on the Check_Values button:

MESSAGE(:field1| | ' - ' | | :SYSTEM.cursor_item | | ' - ' | | :SYSTEM.trigger_item);

With the focus in Field1 and the values 1, 2, and 3 in the text items, what message will be displayed when the button is clicked.

A. -4

B. 1 -2 -3

C. 1 field1 Check Values

D. Field1 -1 Check Values

E. 1 CONTROL.FIELD1 CONTROL.FIELD1

F. 1 CONTROL.FIELD1 CONTROL.CHECK_VALUES

G. :field1 - :SYSTEM.cursor_item - :SYSTEM.trigger_item

You have a form with a single multi-record block. During a session, a user performs an insert and clicks Save

What is the behavior of the record being inserted violates a database constraint?

A. The record is posted to the database but not committed. The form redisplays the record with an error message so that the user can correct the data. Navigation to another record cannot occur until the correct data is committed or the new record is deleted. If the user exits the form without correcting the entry, a database rollback is performed.

B. The record is committed to the database. The form redisplays the record with an error message so that the user can correct the data. The user is unable to exit the form or move to another record until the correct data is committed of the new record is deleted.

C. A database rollback is performed. The form redisplays the record with an error message so that the user can correct the entry. The user is able to navigate to another record or exit the form.

D. A database rollback is performed. The form redisplays the record with an error message so that an correct the entry. Navigation to another record cannot occur until the correct data is committed or the record is deleted.

E. The record is committed to the database. The form redisplays the record with a warning in case the user would like to correct the entry. The user is able to navigate to another record or exit the form.

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.

You must be careful when coding a When-Button-Pressed trigger, because it does not accept restricted built-ins.

A. True

B. False