Skip to main content

1Z0-151 Real Exam Questions

Oracle Fusion Middleware 11g: Build Applications with Oracle Forms

90 questions available · Page 1 of 9

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Single choice

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?

  1. A

    invoke the LOV wizard.

  2. B

    Create a new record group that is based on a SQL query.

  3. C

    Create a new static record group.

  4. D

    Create a list item instead; a list of values is not appropriate for a static list.

Show answer and explanation

Correct answer: A

Explanation

ow to create LOV in Oracle forms?

List of Values(LOV) are used either when a selected list is too long and hence would not be appropriate for a drop down, but needs a search form to select the value.

Steps to create LOV functionality:

* Click on the LOV icon in the object navigator and choose a manual/automatic wizard. This will create a
record group.

* Open a search form in the Dialog Page
* Select values inside this form.

* Return selected values to the original page.

Question 2 Multiple choice

In Forms Builder, the iconic buttons on the form are blank, but when you click Run Form the form appears in the browser with Images in the iconic buttons.

What are two things that you can check to track the source of this problem?

  1. A

    forms Builder runtime preferences

  2. B

    the UI_ICON setting in the operating system

  3. C

    the iconpath setting in the Forms registry file

  4. D

    the UI_ICOM_EXTENSION setting in the operating system

  5. E

    the iconextension setting in the Forms registry file

  6. F

    the FORMS_PATH setting in the Forms environment file

  7. G

    the classpath setting in the operating system

Show answer and explanation

Correct answers: B, C

Explanation

C: assume you put your gif in a directory /icon under your /forms on server, then in the registry.dat file, find the section containing sth below xxx.xxx.iconpath=

xxx.xxx.iconextension =,

set above iconpath=/icon

iconextension =gif

Question 3 Single choice

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.

  1. A

    True

  2. B

    False

Show answer and explanation

Correct answer: B

Question 4 Single choice

You are planning the alerts that are needed for your Human Resources application. You wish to display the following in alerts:
* A message to inform the user about being at the just record
* A warning about a potential conflict with the data just entered
* A message to display a validation error to the user
* A warning that the salary is out of range and that asks whether the user wants to correct it

You want the note symbol ( ) to appear on alerts that display only informative messages, the

warning symbol to appear on messages where you will allow the user to continue despite some data problem, and the alarm boll symbol to appear where the user will not be allowed to continue without correcting the situation that caused the alert to be displayed.

You want to define the minimum number of alerts possible and customize them at run time.

Which alerts should you define?

  1. A

    One Note style alert and caution style alert

  2. B

    One Note style alert and one Stop style alert

  3. C

    On Caution style alert and one stop style alert

  4. D

    On Note style alert, one Caution style alert, and one Stop style alert

  5. E

    Two Caution style alerts and one Stop style alert

Show answer and explanation

Correct answer: D

Explanation

In this scenario we need three different kind of alerts.

How to Create an Alert Like other objects you create at design-time, alerts are created from the Object Navigator.
1. Select the Alerts node in the Navigator, and then select Create.
2. Define the properties of the alert in the Property Palette. Here are the properties that are specific to an alert. This is an abridged list.

Note: Alerts are an alternative method for communicating with the operator. Because they display in a modal window, alerts provide an effective way of drawing attention and forcing the operator to answer the message before processing can continue.

Note 2: Potentially, you can create an alert for every separate alert message that you need to display, but this is usually unnecessary.
You can define a message for an alert at run time, before it is displayed to the operator. This means that a single alert can be used for displaying many messages, providing that the available buttons are suitable for responding to each of these messages.
Create an alert for each combination of:
* Alert style required
* Set of available buttons (and labels) for operator response For example, an application might require one
Note-style alert with a single button (OK) for acknowledgment, one Caution alert with a similar button, and two Stop alerts that each provide a different combination of buttons for a reply. You can then assign a message to the appropriate alert before its display, through the SET_ALERT_PROPERTY built-in procedure.

References:
Oracle Forms Student Guide, How to Create an Alert

Question 5 Single choice

When tabbing through items in the Employees form, users should not be able to navigate to the Salary text item. If they need to update the item, they will have to explicitly navigate to it by using the mouse.

Which property setting accomplishes this requirement?

  1. A

    Enabled = Yes; Keyboard Navigable = No

  2. B

    Enabled = No; Keyboard Navigable = Yes

  3. C

    Enabled = Yes; Keyboard Navigable = Yes

  4. D

    Enabled = No; Keyboard Navigable = No

  5. E

    Automatic Skip = Yes

Show answer and explanation

Correct answer: C

Explanation

* Keyboard Navigable property
Description
Determines whether the end user or the application can place the input focus in the item during default navigation. When set to Yes for an item, the item is navigable. When set to No, Form Builder skips over the item and enters the next navigable item in the default navigation sequence. The default navigation sequence for items is defined by the order of items in the Object Navigator.
Applies to all items except chart items and display items

* Default
Yes
Usage Notes
If Enabled or Visible is set to No (PROPERTY_FALSE for runtime), then the items' or item instance's
Keyboard navigable property is effectively false. At runtime, when the Enabled property is set to PROPERTY_FALSE, the Keyboard_Navigable property is also set to PROPERTY_FALSE. However, if the Enabled property is subsequently set back to PROPERTY_TRUE, the keyboard Navigable property is NOT set to PROPERTY_TRUE, and must be changed explicitly.

Question 6 Single choice

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?

  1. A

    Forms Client (applet)

  2. B

    Forms Runtime

  3. C

    Forms Servlet

  4. D

    Forms Listener Servlet

Show answer and explanation

Correct answer: A

Explanation

Note: ORACLE APPLICATION SERVER FORMS SERVICES ARCHITECTURE.
The OracleAS Forms
Services consists of three components: a Forms Client that is downloaded automatically to the end user's browser and cached, the Forms Listener Servlet, and the Forms Runtime - on the middle tier.

Forms Client (Java Applet)
When a user runs a Forms session, the Forms Client - a thin 100 percent Java Applet - dynamically downloads from the Oracle Application Server. This generic Java Applet provides the user interface for the associated Forms Runtime process on the middle tier, and handles user interaction and visual feedback such as that generated by navigating between items or checking a checkbox. The same Java applet is used for any Forms application, therefore it is downloaded only once and cached on the client and so is available for subsequent Forms applications

Question 7 Multiple choice

The Orders form, whose properties have not been changed from the default, has two non-base table text items to display the sales representative's first and last names.

You want to ensure that entries made in these Items correspond to an existing employee, so you write a When-Validate-Item trigger for the Sales_Rep_First_Name text item:

SELECT LAST_NAME Into :last_name FROM employees
WHERE first_name = :first_name;
EXCEPTION
WHEN NO_DATA_FOUND THEN
MESSAGE ('There is no sales rep by this name');

When you test the form and enter a first name that does not exist in the database, the message that you specified appears, but the cursor goes to the Sales_Rep_Last_Name item. You want the cursor to remain in the Sales_Rep__First Name item until a correct first name is entered.

Also, as you continue to test the form, at times, the cursor does not leave the Sales_Rep_First_Name item after you enter a name, but no error message appears.

Which two things can you do to correct these problems?

  1. A

    Add the code to handle the FORM_TRIGGER_FAILURE exception.

  2. B

    Raise the FORM_TRIGGER_FAILURE exception.

  3. C

    Add code to handle the TOO_MANY_ROWS exception.

  4. D

    Raise the TOO_MANY_ROWS exception.

  5. E

    Code an On-Error trigger.

  6. F

    Code an On-Message trigger.

  7. G

    Write a When-Validate-Item trigger for the Sales_Rep_Last_Name item.

  8. H

    Move the code to a form-level When-Validate-Item trigger.

  9. I

    Change the form's validation Unit property to Record.

Show answer and explanation

Correct answers: A, C

Explanation

A: FORM_TRIGGER_FAILURE Exception
Triggers fail only when one of the following occurs: *An unhandled exception
*When you request the trigger to fail by raising the built-in exception FORM_TRIGGER_FAILURE
This exception is defined and handled by Forms Builder, beyond the visible trigger text that youwrite. You can raise this exception:
* In the executable part of a trigger, to skip remaining actions and fail the trigger *In an exception handler, to fail the trigger after your own exception-handling actions havebeen obeyedIn either case, Forms Builder has its own exception handler for FORM_TRIGGER_FAILURE , which fails the trigger but does not cause an unhandled exception. This means that you can fail the trigger in a controlled manner.

C: When you use SELECT in a PL/SQL block, it's important to make sure that exactly one row will always be returned by your query. If more than one row is returned, the TOO_MANY_ROWS exception occurs.

Note 1_ When-Validate-Item fires when Forms validates an item.

Note 2: The scope of a trigger is determined by its position in the formobject hierarchy--that is, thetype of object under which you create the trigger. There are three possible levels that answer the"What Level?"question in the slide graphic:-
Form level:

The trigger belongs to the form and can fire due to events across the entireform.- Block level: The trigger belongs to a block and can fire only when this block is the currentblock.- Item level: The trigger belongs to an individual item and can fire only when this item isthe current item

Question 8 Multiple choice

View the Exhibit.

What four facts can you determine by examining the Object Navigator?

  1. A

    The Orders block is a detail block.

  2. B

    The Order_Items block is a detail block.

  3. C

    An order can be deleted only if it has no order items.

  4. D

    If an order is deleted, all of its order items are deleted.

  5. E

    You cannot delete order items without deleting the order.

  6. F

    You can delete an order without deleting its order items.

  7. G

    The Orders block is a master block.

  8. H

    The Order_Items block is a master block.

  9. I

    If you delete an order item, all of its associated inventory items are deleted.

  10. J

    The inventories block is a master block.

Show answer and explanation

Correct answers: B, C, D, G

Explanation

B: Order_Items is a detail block.
C (not F): A master block record cannot be deleted if there are corresponding detail block records.
D: To delete an order, all the corresponding order items must be deleted, for example through an ON-CHECK-DELETE-MASTER trigger.
G: The Orders block is a master block.

Incorrect answers:
E: Order_items can very well be deleted without deleting the corresponding order.
J: There are no triggers for INVENTORIES.
Either Master or Detail Triggers would have been created if it was either a Master or Detail block.

Note: Master/Detail Triggers:
Oracle Forms generates master/detail triggers automatically when a master/detail relation is defined between blocks. The default master/detail triggers enforce coordination between records in a detail block and the master record in a master block. Unless developing custom block-coordination schemes, you do not need to define these triggers.
* On-Check-Delete-Master Fires when Oracle Forms attempts to delete a record in a block that is a master block in a master/detail relation.
* On-Clear-Details Fires when Oracle Forms needs to clear records in a block that is a detail block in a master/detail relation because those records no longer correspond to the current record in the master block.
* On-Populate-Details Fires when Oracle Forms needs to fetch records into a block that is the detail block in a master/detail relation so that detail records are synchronized with the current record in the master block.

Question 9 Single choice

You have been assigned to maintain the Orders form. Users complain that if the cursor is in the in the Orders block, they cannot navigate to the Order Items block by clicking a text item in that block. They must click the Next Block button to navigate from the Orders block to the Order Items block.

How should you investigate the source of the problem?

  1. A

    Check the Pre-Text-Item and Post-Text-Item triggers, because users may be encountering a navigation trap.

  2. B

    Check the Navigation properties of the Orders block that have non-default values.

  3. C

    Check the Navigation properties of the Order Items block that have non-default values.

  4. D

    Check the Navigation properties of the items in the Orders block that have non-default values.

  5. E

    Check the Navigation properties of the form that have non-default values.

  6. F

    Check that the items in the Order Items block are enabled.

Show answer and explanation

Correct answer: A

Explanation

The Navigation Trap
You have seen that the Pre-and Post-navigation triggers fire during navigation, and when they fail the internal cursor attempts to return to the current item(SYSTEM.CURSOR_ITEM).The diagram below illustrates the navigation trap. This can occur when a Pre-or Post-navigation trigger fails and attempts to return the logical cursor to its initial item. However, if the initial item has a Pre-Text-Item trigger that also fails the cursor has nowhere to go, and a fatal error occurs.
Note:
Be sure to code against navigation trigger failure

Question 10 Single choice

View the exhibit.

In the OrderItemsForm, you have a control with a button that users can click to navigate to the first record in the block. The button has keyboard Navigable and Mouse Navigable set to No.

You are coding a When-Button-Pressed trigger for the First Record button with the following code:

SCROLL_UP;
WHILE FORM_SUCCESS LOOP
SCROLL_UP;
END LOOP;

What happens when the user clicks First Record with the cursor in the 72nd record in the block, as shown in the Exhibit?

  1. A

    The cursor successfully navigates to the first record.

  2. B

    A runtime error is encountered because there is no scroll bar for the block.

  3. C

    The display scrolls so that the first record is visible, bur the cursor stays on the last visible record, which should be record 10.

  4. D

    The form goes into an infinite loop and has to be killed by using operating system commands.

  5. E

    internal navigation to the first record occurs, but the visible cursor remains on record 72. You should add the SYNCHRONIZE command to synchronize the display with the internal state of the form.

  6. F

    Because there is no scroll bar, the cursor navigates only as far as the first visible record, which is

    record 63.

Show answer and explanation

Correct answer: A

Explanation

SCROLL_UP built-in
Description
Scrolls the current block's list of records so that previously hidden records with lower sequence numbers are displayed. This action displays records that were "above" the block's display.SCROLL_UP puts the input focus in the instance of the current item in the displayed record that has thehighest sequence number.