Oracle Oracle Certifications 1Z0-151 Questions & Answers

• Question 61:

  Your company applies three different interest rates for customers based on their credit rating, which is classified as being Excellent, Fair, Poor or Unknown.

  In the years past, clerks entered credit ratings manually, which resulted in some of them being mistyped. To improve data entry accuracy you modify the Customers form so that the Credit_Rating item is a static list item that allows only those four values.

  Users report to you that some of the customer records can no longer be accessed when they use the modified Customers form. How can you fix this problem?

  A. Ensure that required is set to No for the list item so that a blank line appears in the list.

  B. Set the Mapping of Other Values property for the list item.

  C. Set the Default Value property for the list item.

  D. Set the Query Allowed Property for the list Item.

  E. Users must re-enter the records for those customers that cannot be accessed.

  Correct Answer: B

  The important property is the "mapping of other values." This property tells Oracle Forms how to handle values that are not expected.

• Question 62:

  You have designed a form with two content canvases. The window for the first canvas was created implicitly, and you have not changed its default properties.

  You want users to be able to navigate between the canvases easily while viewing both simultaneously. Therefore, you create a second window, changing only its name from the default properties.

  However, when you test the form, you find that you are unable to close either window. What must you do to provide this functionality?

  A. Change the second window to a modal window.

  B. Code a When-Window-Closed trigger for each window.

  C. Set Close Allowed to Yes for both windows.

  D. Set Hide on Exit to Yes for both windows.

  Correct Answer: A

  Note: Modal and Modeless Windows in Oracle Forms A window in oracle forms is a container for all visual objects that make up a Forms application. You can create two different type of windows in oracle forms. Lets have a brief comparisons between these two types of windows.

  *

  Modal Window: A modal window is a restricted window that the user must respond to before moving the input focus to another window. Modal windows: Must be dismissed before control can be returned to a modeless window Become active as soon as they display Require a means of exit or dismissal

  *

  Modeless Window: A modeless window is an unrestricted window that the user can exit freely. Modeless windows: Can display many at once Are not necessarily active when displayed Are the default window type

• Question 63:

  The Employees database table contains more columns than can be displayed at one time in a form. You create a data block that uses all the columns. How can you enable users to interact with all the items and switch between them without scrolling or closing anything?

  A. Define multiple content canvases and display them in multiple modeless windows.

  B. Define multiple content canvases and display them in the same modeless window.

  C. Define multiple content canvases and display them in multiple modal windows.

  D. Define multiple content canvases; display one in a modeless window and the others in modal windows.

  E. This is not possible because items from a single block must be displayed on the same canvas and window.

  Correct Answer: D

  Note 1:

  The most common canvas type is the content canvas (the default type). A content canvas is the "base"

  view that occupies the entire content pane of the window in which it is displayed. You must define at least

  one content canvas for each window you create.

  Note 2:

  Modal and Modeless Windows in Oracle Forms

  A window in oracle forms is a container for all visual objects that make up a Forms application. You can

  create two different type of windows in oracle forms. Lets have a brief comparisons between these two

  types of windows.

  *

  Modal Window: A modal window is a restricted window that the user must respond to before moving the input focus to another window. Modal windows: Must be dismissed before control can be returned to a modeless window Become active as soon as they display Require a means of exit or dismissal

  *

  Modeless Window: A modeless window is an unrestricted window that the user can exit freely. Modeless windows: Can display many at once Are not necessarily active when displayed Are the default window type

• Question 64:

  Iin an Order Entry form, the Order_Items block has a text item called Shipping Date, which is of the Date data type. The Lowest Allowed Value and the Highest Allowed Value properties are not defined for this item.

  Assuming that the following are defined, which three are valid settings for the initial Value = property of the Shipping_Date Item?

  A. $$DBDATE$$

  B. :Orders.Order_Date + 3

  C. SYSDATE

  D. :GLOBAL.SHIP_DATE

  E. :PARAMETER.SHIP

  F. ORDER_ITEMS_SEQ

  Correct Answer: ACD

  A: Use $$DATE$$, $$DATETIME$$, and $$TIME$$ to obtain the local system date/time; use $$DBDATE$$, $$DBDATETIME$$, and $$DBTIME$$ to obtain the database date/time, which may differ from the local system date/time when, for example, connecting to a remote database in a different time zone. ,, Use these variables only to set the value of the Initial Value, Highest Allowed Value or Lowest Allowed Value property.

  Incorrect answers:

  B: This would work within a trigger.

• Question 65:

  Yon have created a list item for the Credit__Rating field in the Customers form, the Finance department usually determines a range of scores that pertain to the customer, the values in the list are Excellent, Good, Fair, and Poor, corresponding to the ranges provided by Finance. The default value Fair, because that is the range that applies to most customers.

  Sometimes, Finance can provide an exact credit score; so users must be able to enter the exact numerical value if it is known. Often clerks enter the customer data before the performance of a credit check, so they must be able to enter a blank value if the credit rating is not yet determined.

  Users want to be able to select a blank value from the list, but the list does not display a blank line for them to select. How can you meet this requirement without changing the default value of the list item?

  A. Add a blank line to the list item when you define the static values.

  B. Set Mapping of other Values for the Credit_Rating Item to NULL.

  C. Set the Required property of the Credit_Rating item to No.

  D. Delete the NOT NULL constraint for the Credit_Rating Column in the database.

  E. You cannot change this type of list item to display a blank value; users must delete the default value records if the credit rating is not known.

  Correct Answer: A

• Question 66:

  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

  Correct Answer: D

• Question 67:

  You want to use WebUtil functionality in the Orders form. What three things must you do to integrate WebUtil into the Orders Form?

  A. Copy the WebUtil object group from the WebUtil object library into a separate object library.

  B. Subclass the WebUtil object group from the WebUtil object library into the Orders form.

  C. Ensure that the WebUtil block is the last block under the Data Blocks node in the Object Navigator.

  D. Ensure that the WebUtil block is the first block under the Data Blocks node in the Object Navigator.

  E. Attach the WebUtil library to the Orders form.

  F. Copy the WebUtil library to the same directory as the Orders form.

  G. in the When-New-Form-instance trigger, register the WebUtil javaBeans.

  H. Set the Implementation Class Property for any items that will implement WebUtil JavaBeans.

  Correct Answer: BCE

  Integrating WebUtil into a Form

  Step 1: Attaching the WebUtil Library (E)

  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 (B)

  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.

  C: 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 68:

  You are coding a When-Checkbox-Changed trigger.

  Which statements are available for use in your code?

  A. unrestricted built-ins only

  B. restricted and unrestricted built-ins only

  C. PL/SQL statements and unrestricted built-ins only

  D. PL/SQL statement-, and any built-ins

  Correct Answer: D

  When-Checkbox-Changed trigger Description Fires when an operator changes the state of a check box, either by clicking with the mouse, or using thekeyboard. Definition Level: form, block, or item Legal Commands: SELECT statements, unrestricted built-ins, restricted built-ins

  Reference: Oracle Forms Developer, When-Checkbox-Changed trigger

• Question 69:

  On the Employees form, you do not want the cursor to enter the Employee_Id text item, which is the first item in the first block on the form. You code a Pre-Text-item trigger for that item that uses the GO_ITEM built-in to navigate to the next item.

  What happens when you run the form from Forms Builder?

  A. You receive a compilation error.

  B. The form starts to run, but immediately closes. So If an error message Is displayed, you are unable to see it.

  C. The form runs, but as soon as it appears, you receive a runtime error.

  D. The form runs, but as soon as you perform any navigation, a runtime error occurs.

  E. The form runs with no problem.

  Correct Answer: C

  You cannot put a restricted built-in (in this case the navigational built-in go_item), in a trigger that is performing navigation. When you run a form described as above, you receive the error `Illegal restricted procedure go_item in pre_text.

• Question 70:

  You put some code in a Post_Update trigger and raise the FORM_TRIGGER_FAILURE under certain conditions. Does a rollback take place if the trigger falls?

  A. Yes. Although the update has been applied to the database, the old column values are retained as rollback data; so a failure of this trigger automatically reinstates the original values.

  B. No. It is too late to perform a rollback at this stage because the update has already been applied.

  C. The value have already been applied, so you must programmatically save the old values in the global variables or PL/SQL variables if you want to reinstall the original values.

  Correct Answer: B

  The record has already been updated. Note: FORM_FAILURE Returns a value that indicates the outcome of the action most recently performed during the current Runform session.

  Use FORM_FAILURE to test the outcome of a builtin to determine further processing within any trigger. To get the correct results, you must perform the test immediately after the action executes. That is, another action should not occur prior to the test.