Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Jan Oracle Official New Released 1z0-151
100% Free Download! 100% Pass Guaranteed!
http://www.Dumps4cert.com/1z0-151.html

Oracle Fusion Middleware 11g: Build Applications with Oracle Forms

Question No: 11

The Orders form has four blocks. The Orders and Order_items block are on the CV_Order content canvas; the inventories block items are on the CV_inventories content canvas; and Control block buttons are on the CV_Buttons toolbar canvas. All buttons have mouse Navigate set to No.

The Order_Items block is a detail of Orders. The inventories block is a detail of Order_Items, showing the stock of the selected product.

There is a button in the Control block with a When-Button-Pressed trigger:

IF GET_CANVAS_PROPERTY(:SYSTEM.cursor_item, item_canvas) = #39;CV_ORDER#39; THEN

GO_BLOCK (#39;inventories#39;) ELSE

GO_BLOCK(#39;orders#39;); END IF;

When you run the form and click the button, navigation does not occur, and the form displays the runtime error “FRM-41053: Cannot find Canvas: invalid ID.” What should you do to correct this problem?

  1. Change the sequence of blocks in the Object Navigator

  2. Chang the Mouse Navigator property of the button to yes

  3. in the first line of code, change the built-in to GET_ITEM_PROPERTY

  4. in the first line of code, change the system variable to: SYSTEM.CURSOR_CANVAS.

  5. in the first line of code, change the CV_ORDER to lowercase

  6. Chang the argument to the GO_BLOCK built-ins to uppercase

Answer: C

Question No: 12

You create a Customers form by using wizards. When you test the form, you notice that you cannot the complete name that is displayed in the Customer_Name text item. Which three tools can you use to correct this problem?

  1. Layout Editor

  2. Property Palette

  3. Data Block wizard

  4. Layout wizard

  5. Object Navigator

  6. Object Library

Answer: A,B,D

Question No: 13

Which type of variable must be declared before it is used in a trigger?

  1. PL/SQL variable

  2. Form item

  3. global variable

  4. system variable

  5. parameter

Answer: A

Explanation: PL/SQL is the language used in Forms triggers and program units.

PL/SQL lets you declare variables and constants, then use them in SQL and procedural statements anywhere an expression can be used. You must declare a constant or variable before referencing it in any other statements.

Variables can have any SQL datatype, such asCHAR,DATE, orNUMBER, or a PL/SQL- only datatype, such asBOOLEANorPLS_INTEGER.

Note:

PL/SQL#39;s data types correspond with SQL#39;s column types, making it easy to interchange PL/SQL variables with data inside a table.

Question No: 14

View the Exhibit.

Dumps4Cert 2018 PDF and VCE

To test how the Orders application works with database triggers, you add to the Orders table the following database trigger that fires before the update of Customer_Id:

BEGIN

If :old.customer_id != : new.customer_id then RAISE_APPLICATION_ERROR (-20101, #39;Database trigger says no!#39;); end if;

END;

You run the Orders form, change the customer ID, and click Save. You receive the error message quot;FRM-40509: Oracle error: unable to UPDATE record.quot; You select Help gt; Display

Error, and the Database Error dialog box that is shown in the Exhibit appears.

Which code would you put in your Form-level On-Error trigger to display the ORA- error message instead of the FRM- error message?

  1. IF ERROR_CODE = 40509 THEN MESSSAGE (DBMS_ERROR_TEXT); END IF

  2. IF ERROR_CODE = 40509 THEN MESSSAGE (SQLERRM);

    END IF;

  3. IF ERROR_CODE = 06512 THEN MESSSAGE(DBMS_ERROR_TEXT); END IF;

  4. IF ERROR_CODE = 06512 THEN MESSSAGE (SQLERRM);

    END IF;

  5. IF ERROR-CODE = 20101 THEN MESSSAGE (DBMS_ERROR_TEXT); END IF;

  6. IF ERROR_CODE = 20101 THEN MESSSAGE(SQLERRM);

END IF;

Answer: A

Question No: 15

View the Exhibit.

Dumps4Cert 2018 PDF and VCE

The orders form contains two canvases. Orders_CV displays one order and all of its order items.

Help-CV displays context-sensitive help.

When users invoke the help screen for the Customer_Id item, the help information obscures the Custormer_Id item, as shown in the Exhibit. Users would like to be able to see both the item and its help information simultaneously.

How can you move the help information to the right so that the Customer_Id item is visible?

  1. increase the Viewport X Position on the Help_CV canvas.

  2. increase the Viewport X Position on Canvas on the Orders_CV canvas.

  3. Decrease the Width on the Help_CV canvas.

  4. in the Layout Editor for the Orders_CV canvas, select View gt; Stacked Views, and then select the Help_CV canvas. Drag the Help_CV canvas to the right of the Customer_Id item.

    Answer: A Explanation:

    Note: Viewport X Position on Canvas, Viewport Y Position on Canvas property Description

    Specifies the location of the view#39;s upper left corner relative to the upper left corner of the canvas. The size and location of the viewport define the view

    ; that is, the part of the canvas that is actually visible in the window to which the canvas is assigned.

    Applies to canvas

    Question No: 16

    The Orders form has the following triggers defined:

    1. Post-Text-Item on Customer_Id

    2. Pre-Text-Item on Sales_Rep_Id

    3. When-New-Item-instance on Sales_Rep_Id

      The form#39;s Validation Unit property is set to Record.

      When the user navigates from Customer_Id to Sales_Rep_Id, which triggers fire and what is the sequence?

      1. 1, 2, and 3

      2. 1, 3, and 2

      3. 1 and 2 only

      4. 2 and 3 only

      5. 3 only

        Answer: E

        Question No: 17

        View the Exhibit.

        Dumps4Cert 2018 PDF and VCE

        The Departments form has form level triggers defined as shown in the Exhibit. You have enabled array DML for the Departments block by setting its DML array size to 5 and setting the Primary Key property of Department id to Yes. You set runtime preferences for Forms Builder to use array processing.

        You want to test that array processing is actually occurring, so, as shown in the Exhibit, the On-Update, On-Delete, and on insert triggers have code that:

        1. Displays a message to indicate which trigger is firing for which record?

        2. Does the thing (either updates, deletes, or inserts)

          The other triggers simply display a message, indicating the trigger that is firing.

          You run the form from Forms Builder, but from the messages, you can tell that array processing is not occurring. What should you change so that array DML gets implemented?

          1. Delete the quot;On-quot; triggers; these triggers remove default processing, including array processing.

          2. Set the DML array size to a value of 10 or greater; for array sizes loss than 10, array

            processing Is inefficient, and so is not performed.

          3. Use the SYNCHRONIZE built-in after the MESSAGE built-in; otherwise, the message are not displayed until the processing is finished, giving the appearance that array processing is not taking place.

          4. Set the Enforce Primary Key property of the Department block to Yes; it is not enough to just set the Department_Id to be the primary key.

Answer: D

Question No: 18

View the Exhibit.

Dumps4Cert 2018 PDF and VCE

You have defined the window, canvas, and text items shown in the Exhibit. What happens when click Run Form?

  1. The form runs with the cursor initially in TEXT_ITEM8.

  2. The form runs with the cursor initially in TEXT_ITEM9.

  3. The form does not compile until you move TEXT_ITEM8.

  4. The form does not compile until you move TEXT_ITEM10.

Answer: D

Question No: 19

Which setting of :SYSTEM.MESSAGE_LEVEL suppresses all system messages?

  1. 0

  2. 10

  3. 25

  4. 50

  5. You cannot use :SYSTEM.MESSAGE_LEVEL to suppress all system messages

Answer: E

Explanation: Controlling System Messages

You can prevent system messages from being issued, based on their severity level. FormsBuilder classifies every message with a severity level that indicates how critical or trivial the information is; the higher the numbers, the more critical the message. There are six levels that you can affect.

Dumps4Cert 2018 PDF and VCE

Note: Suppressing Messages According to Their Severity

In a trigger, you can specify that only messages above a specified severity level are to be issuedby the form. You do this by assigning a value to the

MESSAGE_LEVEL

system variable. Formsthen issues only those messages that are above the severity level defined in this variable.The default value for

MESSAGE_LEVEL

(at form startup) is 0. This means that messages of all severities are displayed.

Question No: 20

You have installed WebLogic and Forms with a default configuration, which has been tested and determined to be correct.

After creating a basic form in the Forms Builder, you click Run Form to test it. Forms Builder displays an error dialog box with the following message:

FRM-10142: The HTTP Listener is not running on lt;hostgt; at port 9001. Please start the listener or check your runtime preferences.

What is one action that you can take to resolve this error?

  1. Start the Web Logic Administration server.

  2. Start the WLS_FORMS managed server.

  3. Change the serverURL parameter in formsweb.cfg

  4. Start the Oracle HTTP server.

  5. Start WebCache.

Answer: B

Explanation: The WLS managed server WLS_FORMS must be started.

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

Dumps4cert 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

Comments are closed.