Oracle 1z0-151 Actual PDF : Oracle Fusion Middleware 11g: Build Applications with Oracle Forms

Why wait to start? ActualPDF emails the complete Oracle Fusion Middleware 11g: Build Applications with Oracle Forms package, 90 1z0-151 practice questions included, about a minute after payment, with customer service answering around the clock if anything goes wrong.

Oracle 1z0-151 Exam Overview:

Certification Vendor:	Oracle
Exam Name:	Oracle Fusion Middleware 11g: Build Applications with Oracle Forms
Exam Number:	1Z0-151
Available Languages:	English
Passing Score:	65%
Related Certifications:	Oracle Certified Professional, Oracle Fusion Middleware 11g Forms Developer
Exam Format:	Scenario-based, Multiple Choice
Certificate Validity Period:	Retired, no recertification required
Real Exam Qty:	70-80
Exam Price:	USD 245
Exam Duration:	135 minutes
Recommended Training:	Oracle Fusion Middleware 11g: Build Applications with Oracle Forms
Exam Registration:	Oracle Education Pearson VUE Registration
Sample Questions:
Exam Way:	Computer-based testing at Pearson VUE centers (exam retired)
Pre Condition:	No mandatory prerequisite; strong SQL and PL/SQL knowledge recommended
Official Syllabus URL:	https://education.oracle.com/certification

Oracle 1z0-151 Exam Syllabus Topics:

1z0-151 Exam FAQ: Before You Book Your Seat

Oracle Fusion Middleware 11g: Build Applications with Oracle Forms Sample Questions:

Question 1

In the Orders form, users often have a need to return to the first record. Because there are many employee records, it may take a long time for them to scroll up to the first record, so you create a button with the label First Record.
When users click the first Record button, you want to display your own custom message instead of the system message "FRM-40100: At first record." The system message should be displayed in other cases when users attempt to scroll above the first record.
You code the following When-Button-Pressed trigger:
:SYSTEM.mesage_level := '5'
UP;
WHILE FORM_SUCCESS LOOP
UP;
END LOOP;
MESSAGE ('This is the first Order');
The button works perfectly to return to the first record and display your custom message instead of the system message. However, users report that as they continue to use the form after clicking the button, no longer see other helpful messages. For example, the message "FRM 40102: Record must be entered or deleted first" no longer appears when they attempt to scroll past the last record.
How can you resolve this Issue so that all system messages continue to be displayed after the trigger code runs?

A. Instead of setting the system message level in the When-Button-Pressed trigger, use an On-Error trigger to customize the message.
B. Add the line of code just before the end of the loop to reset the system message level.
C. instead of setting the system message level to 5 in the code, set it to 50.
D. instead of setting the system message level to 5 in the code, set it to 25.
E. Add a line of code just after the end of the loop to reset the system message level.
F. Set the system message level in a When-New-Form-Instance trigger, so that all system messages appear except when in the scope of the trigger.

Question 2

You have written a Forms application that your users log in to with their database login.
Which Forms component is utilized first when a user runs the application?

A. Forms Servlet
B. Forms Client (applet)
C. Forms Runtime
D. Forms Listener Servlet

Question 3

Which two actions are always necessary when deploying Forms applications that were developed on Windows platform to a UNIX middle tier server?

A. compiling the Forms modules on the development machine
B. creating a menu module for the application
C. moving the forms executable files from the development machine to the middle-tier machine
D. creating a Forms PL/SQL library file to contain the application logic
E. moving the Forms source files from the development machine to the middle tier machine
F. compiling the Forms modules on the middle tier machine
G. installing forms Builder on the middle-tier machine

Question 4

You want to display employee records in tabular format, but the form is not wide enough to display all the items in the Employees block. The employee IDs and names of displayed records should always be visible, but you want to scroll the additional information as users tab through the Items, the form should look like a spreadsheet with the first two columns frozen.
Which canvas types would be most appropriate in this scenario?

A. content canvas and multiple tab canvases
B. content canvas in a window with a horizontal scroll bar
C. content canvas and a stacked canvas with a horizontal scroll bar
D. multiple content canvases
E. content canvas and a tab canvas with multiple tab pages

Question 5

Customers log in to your Orders application by using their customer ID, which is saved as a global variable. When the Orders form first comes up, you want it to be populated with the customer's orders, and you do not want customers to be able to query for another customer's orders.
You code the following triggers:
When-New Form instance on the Orders form:
GO_BLOCK('orders');
EXECUTE_QUERY;
You also have a button in the Control block labeled Query Orders with a When-Button Pressed trigger that has the same code as the When New-Form instance trigger.
To test the form, you run it and log in a Customer 104. When you click Query Orders, all orders are shown, not just those for Customer 104.
What is the best way to correct this issue to ensure that the customer can never query another customer's orders?

A. Delete the Key-Exqry trigger and put its code in an On-Select trigger.
B. Delete the Key-Exeqry trigger and add the its first line after the call to GO_BLOCK in the When-New-Form-instance trigger.
C. Delete the Key-Exqry trigger and put its code in a Pre-Query trigger.
D. Change the last line of the When-Button-Pressed code to:
DO_KEY ('EXECUTE_QUERY');

Solutions: