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

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: 41

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

  1. Database transactions are always continued across forms.

  2. Code is always shared among forms.

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

  4. A global record group is always created.

  5. Only A and B are true.

  6. Only B and C are true.

  7. Only C and D are true.

  8. None of the statements above are true.

Answer: H

Explanation: OPEN_FORM

Opens the indicated form. Use OPEN_FORM to create multiple-form applications, that is, applications that open more than one form at the same time. OPEN_FORM can be instructed for the two forms to share the same database session and/or library data.


Runs an indicated form while keeping the parent form active. Oracle Forms runs the called form with the same Run form preferences as the parent form. When the called form is exited Oracle Forms processing resumes in the calling form at the point from which you initiated the call toCALL_FORM.CALL_FORM can be instructed to hide or not hide the calling form, replace or not replace the menu, open the new form in query only mode, share or not share library data.


Exits the current form and enters the indicated form. The calling form is terminated as the parent form. If the calling form had been called by a higher form, Oracle Forms keeps the higher call active and treats it as a call to the new form.

Reference: Difference between call_form, new_form and open_form

Question No: 42

Which three statements are true about the PL/SQL Packages panel in the Forms debugger?

  1. You can select an option button to view server packages.

  2. You can view packages only while the runtime process executes PL/SQL.

  3. You can view the values of variables that are defined in the package specification.

  4. You ran select an option button to view the packages that have not yet been instantiated.

Answer: A,B,C

Explanation: PL/SQL Packages Panel: This panel is used only to browse and examine the

PL/SQL packages which are been instantiated while executing the form.

Question No: 43

Which statement is always true about a visual indicator that a text item has a list of values associated with it?

  1. An iconic list button appears next to the text item.

  2. A list of values lamp appears as a tool tip when the cursor is placed over the text item.

  3. A list of values lamp appears next to the text item.

  4. A list of values lamp appears on the status line when the cursor enters the text item.

  5. A button with an ellipsis appears in the text Item when the cursor enters the text item.

Answer: D

Question No: 44

View the Exhibit.

Ensurepass 2018 PDF and VCE

You have placed the following code in a Post insert trigger on the Orders block: SELECT orders_seq.NEXTVAL

INTO :orders.order_id FORM SYS.dual;

You have also set Item properties for the Order_Id Item in the form so that users cannot directly enter an Order ID.

As the SUMMIT user, you run the form to test it. Yon are able to insert a record in the block, but when you click Save, you have a database error as shown in the Exhibit.

What is the probable cause of this error?

  1. The code should be in Pre_insert trigger instead

  2. The code should be in a database trigger instead

  3. You should change the code to select the sequence number from SUMMIT.dual instead.

  4. You should create the sequence in the database, because the runtime error is an indication that is does not exist.

  5. You should assign a temporary value to the Order_Id item before saving the form.

Answer: A

Question No: 45

You have a text item in your form named Object1. You want to create Object2 as an exact duplicate of Object1. You want to be able to change the properties of Object2. However if you change Object1, you do not want Object2 to change.

Which method of reusing Object1 would be best for these requirements?

  1. Copying Object1

  2. Subclassing Object1

  3. Creating a property class from Object1

  4. Putting Object1 in an Object library

  5. Referencing Object1 in a PL/SQL library

Answer: A

Question No: 46

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?

  1. content canvas in a window with a horizontal scroll bar

  2. content canvas and multiple tab canvases

  3. content canvas and a tab canvas with multiple tab pages

  4. content canvas and a stacked canvas with a horizontal scroll bar

  5. multiple content canvases

Answer: D

Explanation: After an entity is divided into groups, if all groups cannot be displayed simultaneously,

it becomes necessary for two or more regions to be displayed in the exact same space, one at a time, using a Tab control. The user can jump to a specific region by selecting a tab or by progressing continuously through all fields of all Tab regions. A set of fields, minimally the primary key fields, should remain visible so the user can maintain

context at all times. There, quot;frozenquot; fields must be placed inside the Tab control on the left side.

When best to use Tab regions:

  • When the user must see all fields of a record in a single window, but they do not need to see them all simultaneously.

  • When entire regions need to be hidden from a user due to security restrictions, the current state of data, or other product installations.

    Question No: 47

    The Orders application enables the Orders form to be opened from the Customers form. Users are confused because when they save a new or changed order, they sometimes receive an error message that indicates that no changes have been made.

    What could be the possible cause of this problem?

    1. The Orders form is Opened in the same session as the Customers form.

    2. The Orders form is opened in a different session from the Customers form.

    3. The Orders form is opened in ACTIVATE mode.

    4. The Orders form is opened in NO_ACTIVATE mode.

    5. The trigger that opens the Orders form calls COMMIT_FORM after open form.

    Answer: A

    Question No: 48

    You must be careful when coding a When-Button-Pressed trigger, because it does not accept restricted built-ins.

    1. True

    2. False

    Answer: B

    Explanation: The When-Button-Pressed trigger:

  • Fires when the operator clicks a button

  • Accepts restricted and unrestricted built-ins

  • Is used to provide convenient navigation, and to display LOVs and many other frequently used functions

Question No: 49

View the Exhibit.

Ensurepass 2018 PDF and VCE

You are attempting to drag the Control and CV_Order objects to an object group as shown in the Exhibit, but you are unable to release them in the Object Group Children node of the object group.

What is the reason for this?

  1. You cannot drag a canvas to an object group.

  2. You cannot drag a block to an object group.

  3. You need separate object groups for different types of objects.

  4. You cannot drag multiple types of objects to an object group at the same time.

  5. You should drag them to the ObjectGroup96 node, not to its Object Group Children node.

Answer: D

Question No: 50

View the Exhibit.

Ensurepass 2018 PDF and VCE

The Departments table in the database contains four columns. In a new form, you use the Data Block Wizard to add all columns to the block, but in the layout Wizard, you choose all columns except Location_Id to add to the canvas. The Object Navigator and layout Editor appear as shown in the Exhibit.

You then decide that you do need to display Location_Id on the canvas. What object must you select before invoking the Layout Editor in re-entrant mode to make this change?

  1. the text item tool in the Layout Editor

  2. Frame 16 in either the Object Navigator or the layout Editor

  3. Canvas4 in either the Object Navigator or the Layout Editor

  4. Location_Id in the Object Navigator

  5. the Departments data block in the Object Navigator

Answer: D

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.