Oracle Fusion Middleware 11g: Build Applications with Oracle Forms

Question 1

You have the Orders form open in Forms Builder. You create an object group in the Orders form and try to drag various components in the Object Navigator to the object group.
Which two components will you be unable to place in the object group?

A. the Product_id item in the Order_Items block of the Orders form

B. the Order_CV canvas of the Orders form

C. the When-New Form-instance trigger of the Orders form

D. the When-New-Item- instance trigger of the Order_Items.Quantity item in the Orders form

E. the Orders block of the Orders form

Correct Answer: A,D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 2

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_HOST

B. CLIENT_GET_FILE_NAME

C. WEBUTIL_FILE

D. CLIENT_OLE2

E. WEBUTIL_UTIL

F. CLIENT_Win_API

G. CLIENT_TEXT_IO

Correct Answer: D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 3

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.SUPPRESS_WORKING : = 'TRUE';

B. 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.

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

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

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 4

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, ITEM4, ITEM5, ITEM5_MENU, and ITEMG

B. ITEM4 and ITEM5 only

C. ITEM4, ITEM5, and ITEM6 only

D. MENU3 only

E. ITEM 4 and ITEM6 only

F. ITEM6 only

G. MENU3 and ITEM5_MENU only

H. ITEM5 and ITEM only

Correct Answer: C

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 5

View the Exhibit.

To test how the Orders application works with database triggers, you add to the Orders table the following database trigger that fires before the update of Customer_Id:
BEGIN
If :old.customer_id != : new.customer_id then
RAISE_APPLICATION_ERROR (-20101, 'Database trigger says no!');
end if;
END;
You run the Orders form, change the customer ID, and click Save. You receive the error message "FRM-40509: Oracle error: unable to UPDATE record." You select Help > Display Error, and the Database Error dialog box that is shown in the Exhibit appears.
Which code would you put in your Form-level On-Error trigger to display the ORA- error message instead of the FRM- error message?

A. IF ERROR_CODE = 40509 THEN
MESSSAGE (SQLERRM);
END IF;

B. IF ERROR_CODE = 20101 THEN
MESSSAGE(SQLERRM);
END IF;

C. IF ERROR_CODE = 06512 THEN
MESSSAGE (SQLERRM);
END IF;

D. IF ERROR-CODE = 20101 THEN
MESSSAGE (DBMS_ERROR_TEXT);
END IF;

E. IF ERROR_CODE = 40509 THEN
MESSSAGE (DBMS_ERROR_TEXT);
END IF

F. IF ERROR_CODE = 06512 THEN
MESSSAGE(DBMS_ERROR_TEXT);
END IF;

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 6

Which statement is always true about using OPEN_FORM to open multiple forms in an application?

A. Only C and D are true.

B. A global record group is always created.

C. Only B and C are true.

D. A calling form must pass data to a called form.

E. Database transactions are always continued across forms.

F. Code is always shared among forms.

G. Only A and B are true.

H. None of the statements above are true.

Correct Answer: H

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 7

The Orders form has the following triggers defined:
1. Post-Text-Item on Customer_Id
2. Pre-Text-Item on Sales_Rep_Id
3. When-New-Item-instance on Sales_Rep_Id
The form's Validation Unit property is set to Record.
When the user navigates from Customer_Id to Sales_Rep_Id, which triggers fire and what is the sequence?

A. 1 and 2 only

B. 1, 2, and 3

C. 1, 3, and 2

D. 3 only

E. 2 and 3 only

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 8

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. This is not possible because items from a single block must be displayed on the same canvas and window.

C. Define multiple content canvases; display one in a modeless window and the others in modal windows.

D. Define multiple content canvases and display them in multiple modal windows.

E. Define multiple content canvases and display them in the same modeless window.

Correct Answer: C

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 9

You have installed WebLogic and Forms with a default configuration, which has been tested and determined to be correct.
After creating a basic form in the Forms Builder, you click Run Form to test it. Forms Builder displays an error dialog box with the following message:
FRM-10142: The HTTP Listener is not running on <host> at port 9001.
Please start the listener or check your runtime preferences.
What is one action that you can take to resolve this error?

A. Start the WLS_FORMS managed server.

B. Change the serverURL parameter in formsweb.cfg

C. Start WebCache.

D. Start the Oracle HTTP server.

E. Start the Web Logic Administration server.

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Oracle Fusion Middleware 11g: Build Applications with Oracle Forms - 1z0-151 Exam Practice Test

Latest Update

Useful Links

Contact Us