Online Access Free 1z0-151 Practice Test

The Orders form, you want to enable users to use Microsoft Excel to create and print an invoice for the customer. The file should be created on the user's computer so that it can be printed with the local printer.
Which WebUtil package would you use to implement this requirement?

• A.CLIENT_Win_API
• B.CLIENT_OLE2
• C.CLIENT_GET_FILE_NAME
• D.CLIENT_HOST
• E.WEBUTIL_FILE
• F.CLIENT_TEXT_IO
• G.WEBUTIL_UTIL

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.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.
• B.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.
• C.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.
• D.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.
• E.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.

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' THEN
GO_BLOCK('order_items');
ELSIF :SYSTEM.cursor_block = 'order_items' THEN
GO_BLOCK('inventories');
ELSIF :SYSTEM.cursor_block = 'inventories' THEN
GO_BLOCK ('orders');
END IF;
The button is not functioning correctly; it does not cause navigation to occur. What must you do to fix the issue?

• A.Change all occurrences of :SYSTEM.cursor_block to :SYSTEM.trigger_block.
• B.Use system variables in the GO_BLOCK statements.
• C.Change the block names to uppercase in the GO_BLOCK statements.
• D.instead of naming the block to navigate to, replace the GO_BLOCK built-in with NEXT_BLOCK
• E.Change the block names to uppercase in the condition (IF ...THEN) statements.
• F.Move the code to a PL/SQL program unit.

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 on your local machine by using a debug executable client.
• C.The form runs in a three-tier environment by using the application server URL that you specify in runtime preferences.
• D.The form runs in a three tier environment by using the [debug] configuration in the FORMSWEB.CFG file.

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 able to navigate between the canvases easily while viewing both simultaneously. Therefore, you create a second window, changing only its name from the default properties.
However, when you test the form, you find that you are unable to close either window.
What must you do to provide this functionality?

• A.Change the second window to a modal window.
• B.Code a When-Window-Closed trigger for each window.
• C.Set Hide on Exit to Yes for both windows.
• D.Set Close Allowed to Yes for both windows.