1z0-151 Exam Training Practice Tests (Oracle Fusion Middleware 11g: Build Applications with Oracle Forms)]

Question 1

Identify a function of the Forms Servlet.

A. It starts a Forms runtime session. B. It renders the Forms Services application display for the user. C. It creates a dynamic HTML file. D. It manages network requests from the Forms Client. E. It connects to and communicates with the database server.

Correct Answer: A

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

Question 2

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 the same modeless window. B. Define multiple content canvases and display them in multiple modeless windows. C. This is not possible because items from a single block must be displayed on the same canvas and window. D. Define multiple content canvases and display them in multiple modal windows. E. Define multiple content canvases; display one in a modeless window and the others in modal windows.

Correct Answer: E

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

Question 3

To avoid overloading the database during busy times, you decide to restrict the queries that are executed on the Orders form so that users query by either Order ID or Customer ID during these times. Which trigger is most appropriate for the code to enforce this restriction?

A. When-New-Form-instance B. Post-Query C. When-New-Block-instance D. Pre-Query E. On-Query

Correct Answer: D

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

Question 4

When users enter address information, you want them to be able to select the state from a static list of values. You have not used a list of states before, and there is no database table that contains state information.
What is the first step in creating such a list of values as quickly as possible?

A. Create a new record group that is based on a SQL query. B. Create a new static record group. C. Create a list item instead; a list of values is not appropriate for a static list. D. invoke the LOV wizard.

Correct Answer: D

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

Question 5

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

A. True B. False

Correct Answer: B

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

Question 6

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

Correct Answer: B

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

Question 7

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

Correct Answer: C

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

Question 8

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. :field1 - :SYSTEM.cursor_item - :SYSTEM.trigger_item B. 1 -field1 -Check Values C. Field1 -1 - Check Values D. -4 E. 1 -2 -3 F. 1 - CONTROL.FIELD1 - CONTROL.CHECK_VALUES G. 1 - CONTROL.FIELD1 - CONTROL.FIELD1

Correct Answer: F

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

Question 9

You have created a complex menu structure with several types of menu objects. To which objects would you assign menu commands?

A. menu items B. submenus C. all of the above D. individual menus E. main menus

Correct Answer: C

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

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