Oracle Oracle Certifications 1Z0-151 Questions & Answers

• Question 41:

  View the Exhibit.

  

  You have begun the process of integrating WebUtil into the Ordes form. What two additional steps must be completed yet?

  A. Write a Pre Form trigger to register WebUtil JavaBeans.

  B. Attach the WebUtil PL/SQL library to the form.

  C. Subclass the webUtilConfig parameter from the WebUtil object library into the form.

  D. Define WebUtil events that the form listens and responds to.

  E. Move the WebUtil data block to the last position under the Data Blocks node in the Object Navigator.

  F. Move the WebUtil data block to the first position under the Data Blocks node in the Object Navigator.

  Correct Answer: CE

  Integrating WebUtil into a Form

  Step 1: Attaching the WebUtil Library (This has already been done in this scenario not B) To use the

  functions of WebUtil in a Forms application, you mustfirst attach the webutil.pll library to any module that

  will use the WebUtil PL/SQL API. Select theAttached Libraries node in the Orders form and click Create.

  This invokes the Attach Librarydialog box, in which you can browse to the location of webutil.pll

  Step 2: Subclassing WebUtil Forms Objects (C)

  Part of the WebUtil utility is a set of Forms objects contained in webutil.olb . This object library contains an

  object group called WebUtil, which you can subclass into your form.

  E: A data block named WEBUTIL; ensure that this is the last block in the Navigator.

  Reference: Oracle Fusion Middleware 11g, Build Applications with Oracle Forms, Integrating WebUtil into a Form

• Question 42:

  What happens when you click Run Form Debug in Forms Builder?

  A. The form runs on your local machine by using a debug executable client.

  B. The form runs in a three-tier environment by using the application server URL that you specify in runtime preferences.

  C. The form runs in a three tier environment by using the [debug] configuration in the FORMSWEB.CFG file.

  D. The form runs in a simulated three-tier environment by using an applet viewer that is included with the product to enable debugging.

  Correct Answer: B

  Directly from the class materials from Oracle: As in the case when you run a form from Forms Builder with the Run Form button, the Run Form Debug button runs the form in a three-tier environment. It takes its settings from the Preferences window that you access by selecting Edit > Preferences from the main menu and clicking the Runtime tab.

• Question 43:

  Immediately after creating a button in the Layout Editor, what is true about the button?

  A. It is an iconic button.

  B. It has no functionality.

  C. It is not mouse navigable.

  D. It is not keyboard navigable.

  E. It is in the control block by default.

  F. It is not enabled.

  Correct Answer: B

• Question 44:

  The Enforce Primary Key property of a data block ensures that the primary key of a new record exists in the database.

  A. True

  B. False

  Correct Answer: A

  Starting with Oracle version 8 Oracle has the ability to enforce primary key and unique key constraints using non-unique indexes.

• Question 45:

  Users do not want to see the "Working" message while a long query completes.

  You are designing a form with a query that takes o long time to execute. What can you do to stop the "Working" message from appearing?

  A. Before the line of code that executes the query, add the line: :SYSTEM.MESSAGE_LEVEL := '10';

  B. Before the line of code that executes the query, add the line: :SYSTEM.SUPPRESS_WORKING : = 'TRUE';

  C. Use the SET_APPLICATION_PROPERTY built-in to set the message level in a When-New- Form-instance trigger.

  D. You do not need to do anything, the default behavior of Forms is to display the "Working" message only if you add code to do so.

  Correct Answer: B

  You can turn the 'Working...' message off with system.suppress_working command.

  SYSTEM.SUPPRESS_WORKING examples

  Assume that you want to have the form filled with data when the operator enters the form. The following

  When-New-Form-Instance trigger will prevent the unwanted updates that would normally occur when

  you fill the blocks with data.

  :System.Suppress_Working := 'TRUE';

  Go_Block ('DEPT');

  Execute_Query;

  Go_Block ('EMP');

  Execute_Query;

  Go_Block ('DEPT');

  :System.Suppress_Working := 'FALSE';

• Question 46:

  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?

  A. The cursor successfully navigates to the first record.

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

  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.

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

  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.

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

  Correct Answer: A

  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.

• Question 47:

  If a display item has a Calculation Mode of Formula, you can call a program unit to perform the calculation.

  A. True

  B. False

  Correct Answer: B

  The formula should use columns that are accessible within the form.

• Question 48:

  You add a display item named Quantity to the Order items block of your Orders form to display the quantity on hand for each product. Quantity is a non-base table item that should reflect the count of an ordered product from the inventories table.

  What is the best way to populate the Order_Iterns.Quantity item?

  A. Post-Query trigger

  B. Pre Query trigger

  C. When-New-Form-instance trigger

  D. When New-Item-instance trigger

  E. You need to define a master-detail relation so that the item is populated automatically.

  Correct Answer: E

  This should be implemented as a master-detail form.

• Question 49:

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

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

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

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

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

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

  Correct Answer: A

  Example, Address has a list of values:

  

• Question 50:

  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?

  A. Layout Editor

  B. Property Palette

  C. Data Block wizard

  D. Layout wizard

  E. Object Navigator

  F. Object Library

  Correct Answer: ADE

  D: Use the Layout Wizard to quickly lay out the items of a data block. The wizard displays the items in a frame on a canvas and lays them out in one of several layout styles, which you can manually alter to your own specifications. You can reenter the Layout Wizard after the initial creation of a frame, enabling you to modify an existing frame, even if it was not created with the Layout Wizard.

  E: The Object Navigator displays all of the form elements, data blocks, menu items, user defined code libraries, built in procedures and functions, and database objects (tables, views).

  The Layout menu has items that control objects on a form much in the way adrawing package does. Objects can be resized, moved, painted and otherwisemanipulated using items on this menu. Incorrect answers:

  B: The Property Palette enables you to set the properties of objects you create in form and menu modules. When you select an object in an editor or in the Object Navigator, the Property Palette updates to show the properties of that object. You can invoke additional Property Palettes as needed, to compare the properties of different objects.

  C: Data Block Wizard Use the Data Block Wizard to easily create or modify data blocks for use in your application. The Data Block Wizard can be reentered after initial creation of the data block, enabling you to modify an existing data block, even if it was not originally created with the wizard.