Which four types of variables must have their names preceded by a colon when they are referenced in trigger code?

A. PL/SQL variables

B. Form items

C. global variables

D. system variables

E. parameters

View the Exhibit.

The Departments table in the database contains four columns. In a new form, you use the Data Block Wizard to add all columns to the block, but in the layout Wizard, you choose all columns except Location_Id to add to the canvas. The Object Navigator and layout Editor appear as shown in the Exhibit.

You then decide that you do need to display Location_Id on the canvas. What object must you select before invoking the Layout Editor in re-entrant mode to make this change?

A. the text item tool in the Layout Editor

B. Frame 16 in either the Object Navigator or the layout Editor

C. Canvas4 in either the Object Navigator or the Layout Editor

D. Location_Id in the Object Navigator

E. the Departments data block in the Object Navigator

The Orders form is sometimes run automatically and sometimes run from the Customers form, when it is

run from the Customers form, any queries should be restricted to the customer that is currently selected.

The Customers form button that runs the Orders form sets a global variable to the current customer ID.

The Orders form has a button labeled Execute Query with the following When-Button Pressed trigger:

DEFAULT_VALUE (NULL, 'GLOBAL.Customer_id');

IF: GLOBAL.customer_id IS NOT NULL

THEN

SET_BLOCK_PROPERTY ('orders', DEFAULT_WHERE, 'orders.customer_id = ' | |

:GLOBAL.CUSTOMER_id);

END IF;

EXECUTE_QUERY

You want to duplicate that functionality in a menu item for the Summit menu that is attached To the Orders

form.

What changes must you make to the code so that the menu code functions as it does in the form?

A. Change both occurrence of :GLOBAL.customer_id to 'GLOBAL.customer_id'.

B. Change 'GLOBAL.customer_id' in line 1 to :GLOBAL.customer_id.

C. Change both occurrence of :GLOBAL.customer_id to NAME_IN ('GLOBAL.customer_id').

D. You do not need to change anything; the code compiles and functions correctly in the menu item.

E. You cannot add this type of code in the menu because it refers to the items on the form that cannot be referenced from a menu.

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.

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.

Identify a function of the Forms Servlet.

A. It creates a dynamic HTML file.

B. It starts a Forms runtime session.

C. It manages network requests from the Forms Client.

D. It connects to and communicates with the database server.

E. It renders the Forms Services application display for the user.

If a display item has a Calculation Mode of Formula, you can call a program unit to perform the calculation.

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

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

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_GET_FILE_NAME

B. CLIENT_HOST

C. CLIENT_OLE2

D. CLIENT_TEXT_IO

E. CLIENT_Win_API

F. WEBUTIL_FILE

G. WEBUTIL_UTIL