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

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

Oracle Fusion Middleware 11g: Build Applications with Oracle Forms

Question No: 1

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. invoke the LOV wizard.

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

  3. Create a new static record group.

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

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 No: 2

You have created an editor named MyEditor, and you want it to be available to edit the text item Product_Description. You can associate the editor with the text item by setting the Editor property of Product_Description to MyEditor.

  1. True

  2. False

Answer: A

Question No: 3

There are certain errors that are specific to the Salary item on the Employees form. You want to trap these errors only when the user navigates from the Salary item.

You have a form-level On-Error trigger that traps errors that apply to the form in general, but yon additionally code an item-level On-Error trigger for the Salary item.

When testing the form, you find that the general errors are not trapped when you navigate from the Salary item. What can you do to correct this problem?

  1. Call the form level On-Error trigger from the item-level On-Error trigger.

  2. Call the item-level On-Error trigger from the form-level On-Error trigger.

  3. Change the Execution Hierarchy property for the item-level On-Error trigger.

  4. Change the Execution Hierarchy property for the form-level On-Error trigger.

  5. Move all the code to a PL/SQL program unit and call it from both the form level and item level On-Error triggers.

Answer: C

Explanation: when you have a WHEN-NEW-ITEM-INSTANCE :if you create a trigger on item, block and form-level, then only the ITEM-Level will start. If you use the exec-hierarchy Override.If all trigger use After, then the FORM, BLOCK and ITEM starts in that sequence.If all trigger use Before, then the ITEM, BLOCK and FORM starts in that sequence.the execution-hierarchy on FORM-Level is ignored, because there is no higher level than FORM

Question No: 4

You have a form that called a database stored procedure. You do not want processing to continue, so immediately after the call to the stored procedure, you add the following code:

IF NOT FORM_SUCCESS THEN

MESSAGE (#39;Stored Procedure failure#39;); RAISE FORM_TRIGGER_FAILURE; END IF;

You test the code and input some data that intentionally causes the stored procedure to fail. However, the message that you defined does not appear. What are two possible reasons for this?

  1. You must handle database errors in an exception clause of the trigger.

  2. You must test for FORM_FAILURE when testing for failure of a stored procedure.

  3. You must test for FORM_FATAL when testing for failure of a stored procedure.

  4. FORM_SUCCESS tests for failure of Forms built-ins, not stored procedures.

  5. You cannot test for failure of a stored procedure, because database errors are transparent to Forms.

Answer: A,D

Explanation: A: You should use DBMS_ERROR_CODE and DBMS_ERROR_TEXT in an ON-ERROR trigger to trap errors propagated from Oracle server from Forms.

Note: FORM_SUCCESS and FORM_TRIGGER_FAILURE

Either the FORM_SUCCESS built-in or the FORM_TRIGGER_FAILURE exception must be used to handle all Forms errors. FORM_SUCCESS is a Boolean function that evaluates to TRUE or FALSE depending on the success or failure of a Forms built-in.

FORM_TRIGGER_FAILURE is an exception that has to be raised to stop further processingwhenever an error occurs or FORM_SUCCESS evaluates to FALSE. The following sections describe their use in error-message handling.

Question No: 5

Identify a function of the Forms Servlet.

  1. It creates a dynamic HTML file.

  2. It starts a Forms runtime session.

  3. It manages network requests from the Forms Client.

  4. It connects to and communicates with the database server.

  5. It renders the Forms Services application display for the user.

    Answer: A

    Question No: 6

    A user at a remote location reports a problem that occurs when the Orders; form runs and the user clicks the invoice button. You are not able to reproduce the problem, so you decide to use remote debugging.

    The steps involved in diagnosing the problem are listed below, but they are ordered incorrectly. What is the correct sequence of Steps?

    1. You set a breakpoint in the When Button-Pressed trigger for the invoice button.

    2. The user#39;s screen goes blank.

    3. The user reports the host and port to you.

    4. You uses the debugger to step through the code.

    5. The user clicks a button that calls DEBUG.ATTACH.

    6. You attach to the user#39;s process.

    7. You open the Orders.fmb file from which the running .fmx was generated.

    8. The user clicks the invoice button.

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

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

      C. 7, 1, 3, 6, 5, 1, 8, 4

      D. 3, 6, 5, 7, 8, 1, 2, 4

      Answer: A

      Question No: 7

      You have written a When-Validate-Item trigger. You want this trigger to fire even if the form is in Enter-Query mode. What must you do to achieve this?

      1. Use the following code at the start of the When Validate-Item trigger:

        :SYSTEM.mode := #39;ENTER-QUERY#39;;

      2. Use the following code at the start of the When Validate Item trigger:

        :SYSTEM.mode := #39;NORMAL#39;;

      3. Set the Fire in Enter Query Mode property of the When-Validate-Item trigger.

      4. You do not need to do anything, because the default for the When Validate Item trigger

        is to fire in Enter-Query mode.

      5. You cannot achieve this, because the When-Validate-Item trigger cannot be set to fire in Enter-Query mode.

Answer: E

Explanation: Coding Triggers for Enter-Query Mode

Some triggers that fire when the form is in Normal mode (during data entry and saving) may also be fired in Enter-Query mode. You need to consider the trigger type and actions in these cases.

“Fire in Enter-Query Mode”Property

To create a trigger that fires in Enter-Query mode, in its Property Palette set the “Fire in Enter-Query Mode”property to Yes. This property determines whether Forms fires a trigger if the associated event occurs in Enter-Query mode. Not all triggers can do this. See last line in note below.

By default, the “Fire in Enter-Query Mode”property is set to Yes for triggers that accept this. Set it to No in the Property Palette if you want the trigger to fire only in Normal mode.

Note:

The following triggers may fire in Enter-Query mode:

*Key-

  • On-Error

  • On-Message

  • When-triggers, except:

-When-Database-Record

-When-Image-Activated

-When-New-Block-Instance

-When-New-Form-Instance

-When-Create-Record

-When-Remove-Record

-When-Validate-Record

-When-Validate-Item

Question No: 8

You wish to use a javaBean in a form. This javaBean has no visible component.

You use the Layout Editor to create a bean area item that implements this JavaBean. You want to be able to see the bean area item in the Layout Editor so that you can easily interact with it at design time.

What can you do to ensure that the bean area item does not appear on the form at run time?

  1. Set its Visible property to No.

  2. Set its Height and Width properties to 1.

  3. Set its Implementation class programmatically at run time.

  4. You do not have to do anything; if Implementation Class does not display a visible component, the bean area does not show at run time.

  5. You cannot avoid displaying the Bean area at run time.

Answer: A

Question No: 9

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

    Ensurepass 2018 PDF and VCE

  • 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. One Note style alert and caution style alert

  2. One Note style alert and one Stop style alert

  3. On Caution style alert and one stop style alert

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

  5. Two Caution style alerts and one Stop style alert

    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.

      Ensurepass 2018 PDF and VCE

      http://www.erplearner.com/Sources/Form Builder_files/image346.jpg

      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.

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

      Question No: 10

      The Orders form is sometimes run automatically and sometimes run from the Customers form, when it is run from the Customers form, any queries should be restricted to the customer that is currently selected. The Customers form button that runs the Orders form sets a global variable to the current customer ID.

      The Orders form has a button labeled Execute Query with the following When-Button Pressed trigger:

      DEFAULT_VALUE (NULL, #39;GLOBAL.Customer_id#39;);

      IF: GLOBAL.customer_id IS NOT NULL THEN

      SET_BLOCK_PROPERTY (#39;orders#39;, DEFAULT_WHERE, #39;orders.customer_id = #39; | | :GLOBAL.CUSTOMER_id);

      END IF; EXECUTE_QUERY

      You want to duplicate that functionality in a menu item for the Summit menu that is attached To the Orders form.

      What changes must you make to the code so that the menu code functions as it does in the form?

      1. Change both occurrence of :GLOBAL.customer_id to #39;GLOBAL.customer_id#39;.

      2. Change #39;GLOBAL.customer_id#39; in line 1 to :GLOBAL.customer_id.

      3. Change both occurrence of :GLOBAL.customer_id to NAME_IN (#39;GLOBAL.customer_id#39;).

      4. You do not need to change anything; the code compiles and functions correctly in the menu item.

      5. You cannot add this type of code in the menu because it refers to the items on the form

that cannot be referenced from a menu.

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
PDF VCE 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.