[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-151 Dumps with VCE and PDF 51-60

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-151
100% Free Download! 100% Pass Guaranteed!

Oracle Fusion Middleware 11g: Build Applications with Oracle Forms

Question No: 51

The Orders form has three blocks: Orders, Orders_Items, and inventories. It also has a button labeled Next Block with a When-Pressed trigger.

IF :SYSTEM.cursor_block = #39;orders#39; THEN


ELSIF :SYSTEM.cursor_block = #39;order_items#39; THEN GO_BLOCK(#39;inventories#39;);

ELSIF :SYSTEM.cursor_block = #39;inventories#39; THEN GO_BLOCK (#39;orders#39;);


The button is not functioning correctly; it does not cause navigation to occur. What must you do to fix the issue?

  1. Change all occurrences of :SYSTEM.cursor_block to :SYSTEM.trigger_block.

  2. Use system variables in the GO_BLOCK statements.

  3. Change the block names to uppercase in the GO_BLOCK statements.

  4. Change the block names to uppercase in the condition (IF …THEN) statements.

  5. instead of naming the block to navigate to, replace the GO_BLOCK built-in with NEXT_BLOCK

  6. Move the code to a PL/SQL program unit.

    Answer: D

    Question No: 52

    You are using a PL/SQL program unit in the Orders form to display an image for the selected product in the Order Items block. The code is called from several different triggers in the form. The code (with line numbers added) is:

    1. PROCEDURE get_image IS

    2. Product_image_id ITEM := FIND_ITEM (#39;control.product_image#39;);

    3. Filename VARCHAR2(250);

    4. BEGIN

    5. Filename := TO_CHAR(:order_items.product_id) | | #39;.jpg#39;;

    6. READ_IMAGE_FILE (filename, #39;jpeg#39;, product_image_id);

    7. END;

      Management wants all codes to be in PL/SQL libraries to facilitate reuse. You create a PL/SQL library and drag the program unit from the orders form to the Program Units node of the library. You then delete the program unit from the Orders form.

      What three things must you do to compile the PL/SQL library and to use the code in the Orders form?

      1. Change line 5 to:

        filename := to_char(name_in #39;order_items.product_id#39; )) | | #39;.jpg#39;;.

      2. insert the RELEASE keyword between lines 1 and 2.

      3. Delete the BEGIN and END statements (lines 4 and 7).

      4. Change product_id to an in parameter and filename to an OUT parameter.

      5. Save the library.

      6. Generate the a .plx file.

      7. Attach the library to the orders form.

      8. Change the way the program unit is called in the Orders form.

Answer: E,G,H Explanation:

E:Save and compile the library.

G: select the Attached Libraries node and click Create.

In the Attach Library dialog box, clickBrowseto navigate to the saved library and open it, then answerYesto the alert that asks if you want to remove the path.

H: Modify the to simply call the procedure from the attached library:

Question No: 53

View the Exhibit to examine the form.

Ensurepass 2018 PDF and VCE

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| | #39; – #39; | | :SYSTEM.cursor_item | | #39; – #39; | | :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

  1. 1 -field1 -Check Values

  2. Field1 -1 – Check Values



  5. :field1 – :SYSTEM.cursor_item – :SYSTEM.trigger_item

Answer: F


Represents the name of the block and item, block.item, where the input focus (cursor) is located.

The value is always a character string.

In this scenario the value is CONTROL.Field1, as the focus is in Field1.


Represents the item (BLOCK.ITEM) in the scope for which the trigger is currently firing. When referenced in a key trigger, it represents the item where the cursor was located when the trigger began. The value is always a character string.

In this scenario the value is CONTROL.CHECK_VALUES, as the CHECK_VALUES button is being clicked.

Question No: 54

View the Exhibits.

Ensurepass 2018 PDF and VCE

The hierarchical tree shown at run time in Exhibit 1 is populated programmatically. Default hierarchical tree properties are shown in Exhibit?

Ensurepass 2018 PDF and VCE

Which properties of the hierarchical tree shown in Exhibit 1 have been changed from the default?

  1. Allow Empty Branches and Multi Selection only

  2. Allow Empty Branches and Show Symbols only

  3. Multi Selection and Show Symbols only

  4. Allow Empty Branches, Multi Selection, and Show Symbols

Answer: A

Explanation: Both Chen and Popp are selected, so Multi-selection is set to Yes (not B).

and – symbols are displayed, so Show Symbols is yes (not B, C, D). Allow Empty Branches is set to Yes (so A is ok), see note below.

Note: Setting Hierarchical Tree Item Properties Hierarchical Tree properties include the following:

  • Item Type: Must be set to Hierarchical Tree

  • Allow Empty Branches: Yes / No. No is the default.

    If set to Yes, all leaf nodes will initially display in the tree with the plus sign ( ) next to it, indicating that expansion is possible, even when there is nothing to expand. If set to Yes, the Show Symbols property must also be set to Yes.

    If set to No, leaf nodes will not have an expand/collapse symbol

  • Multi Selection: Whether multiple nodes may be selected at one time No is the default.

  • Show Lines: Whether a hierarchical tree displays lines leading up to each node Yes is the default.

  • Show Symbols: Whether a hierarchical tree should display or – symbols in front of each branch node

  • Record Group: Name of the record group from which the hierarchical tree derives its values

  • Data Query: Specifies the query-based data source

Question No: 55

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

  1. PL/SQL variables

  2. Form items

  3. global variables

  4. system variables

  5. parameters

Answer: B,C,D,E

Question No: 56

View the Exhibit.

Ensurepass 2018 PDF and VCE

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?

  1. MENU3 only

  2. ITEM6 only


  4. ITEM4, ITEM5, and ITEM6 only

  5. ITEM4 and ITEM5 only

  6. ITEM 4 and ITEM6 only

  7. ITEM5 and ITEM only

  8. MENU3 and ITEM5_MENU only

Answer: D

Explanation: MENU3 and ITEM5_MENU are menus.

Question No: 57

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?

  1. the Orders block of the Orders form

  2. the Order_CV canvas of the Orders form

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

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

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

    Answer: C,E

    Explanation: C: Object libraries can contain individual items; for example, iconic buttons. The smallest unit accepted in an object group is a block.

    E:Including a block in an object group also includes its items, the item-level triggers, the block-level triggers and the relations. You cannot use any of these objects in an object group without the block.

    Question No: 58

    A clerk is using the Human Resources form, which displays a department and its associated employees on the same canvas. Only two Items in the form are enabled.

    Possible navigation units that can occur during navigation of this form are:

    1. Outside the form

    2. The Human Resources form

    3. The Departments block

    4. The Employees block

    5. The current Departments record

    6. The current Employees record

    7. The Department_Id item

    8. The Employee_Id item

With the cursor in : Departments.Department_Id, the clerk clicks the

:Employees.Employee_Id item.

What is the sequence of navigational unit movement that occurs?

A. 1, 2, 3, 4, 5, 6, 7, and 8

B. 7, 5, 3, 2, 4, 6, and 8

C. 7, 5, 3, 2, 4, 6, and 8 only

D. 7, 5, 3, 4, 6, and 8 only

E. 7 and 8 only

Answer: D

Question No: 59

Which symbol when used in an object#39;s Property Palette, indicates an inherited property that has been changed?

Ensurepass 2018 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: C

Question No: 60

To troubleshoot a problem with a form, you have added a call to the MESSAGE () built-in at the beginning of the When-Validate-Item trigger of the Customer_Id then in the Orders Block of the Orders form. The message simply states that the trigger is firing.

You run the form, make a change in Customer_Id, and then tab out of the item but the message does not appear. What are two possible causes for this problem?

  1. The form is in Enter-Query mode.

  2. The item is using an LOV for validation.

  3. The validation unit of the form needs to be changed.

  4. The MESSAGE () built-in is not allowed in validation triggers.

  5. There is a syntax error in the call to the MESSAGE() built-in.

  6. Validation for the Customer_Id item failed.

Answer: A,C

100% Ensurepass Free Download!
Download Free Demo:1z0-151 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-151 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.