Online Access Free 1z1-151 Practice Test

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

• A.The form runs in a simulated three-tier environment by using an applet viewer that is included with the product to enable debugging.
• B.The form runs in a three-tier environment by using the application server URL that you specify in runtime preferences.
• C.The form runs on your local machine by using a debug executable client.
• D.The form runs in a three tier environment by using the [debug] configuration in the FORMSWEB.CFG file.

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 tools can you use to correct this problem?

• A.Layout Editor
• B.Property Palette
• C.Layout wizard
• D.Object Navigator
• E.Data Block wizard
• F.Object Library

When tabbing through items in the Employees form, users should not be able to navigate to the Salary text item. If they need to update the item, they will have to explicitly navigate to it by using the mouse.
Which property setting accomplishes this requirement?

• A.Enabled = No; Keyboard Navigable = Yes
• B.Enabled = No; Keyboard Navigable = No
• C.Automatic Skip = Yes
• D.Enabled = Yes; Keyboard Navigable = Yes
• E.Enabled = Yes; Keyboard Navigable = No

View the Exhibit.

You have placed the following code in a Post insert trigger on the Orders block:
SELECT orders_seq.NEXTVAL
INTO :orders.order_id
FORM SYS.dual;
You have also set Item properties for the Order_Id Item in the form so that users cannot directly enter an Order ID.
As the SUMMIT user, you run the form to test it. Yon are able to insert a record in the block, but when you click Save, you have a database error as shown in the Exhibit.
What is the probable cause of this error?

• A.You should assign a temporary value to the Order_Id item before saving the form.
• B.You should create the sequence in the database, because the runtime error is an indication that is does not exist.
• C.You should change the code to select the sequence number from SUMMIT.dual instead.
• D.The code should be in a database trigger instead
• E.The code should be in Pre_insert trigger instead

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.No. It is too late to perform a rollback at this stage because the update has already been applied.
• B.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.
• 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.