Oracle 1Z0-151 Online Practice Questions and Exam Preparation

Oracle 1Z0-151 Online Questions & Answers

• Question 81:

  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?

  A. The Orders form is Opened in the same session as the Customers form.
  B. The Orders form is opened in a different session from the Customers form.
  C. The Orders form is opened in ACTIVATE mode.
  D. The Orders form is opened in NO_ACTIVATE mode.
  E. The trigger that opens the Orders form calls COMMIT_FORM after open form.
  E. The trigger that opens the Orders form calls COMMIT_FORM after open form.

  ---

  If you want to end the current transaction before opening the next form, call the COMMIT_FORM built-in before OPEN_FORM. You can check to see if the value of :SYSTEM.form_status='CHANGED' to decide whether a commit is needed. Alternatively, you can just post changes to the database with POST , then open the nextform in the same transaction

  Note: Control and Transactions WhenOpening Another Form When you use OPEN_FORM

  *

  By default, control passes immediately to the Orders formand no statements after OPEN_FORM are processed

  *

  If the Activate_Mode argument is set to NO_ACTIVATE ,you retain control in the current form

  *

  The transaction continues unless it was explicitlycommitted before

• Question 82:

  View the Exhibit.

  

  You have just created a new object library as shown in the Exhibit. You want the tabs to have descriptive names.

  You cannot change the names of the default object library tabs, so you must create new tabs in order to have descriptive names.

  A. True
  B. False
  B. False

• Question 83:

  View the Exhibit.

  

  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?

  A. the text item tool in the Layout Editor
  B. Frame 16 in either the Object Navigator or the layout Editor
  C. Canvas4 in either the Object Navigator or the Layout Editor
  D. Location_Id in the Object Navigator
  E. the Departments data block in the Object Navigator
  D. Location_Id in the Object Navigator

• Question 84:

  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?

  A. Set its Visible property to No.
  B. Set its Height and Width properties to 1.
  C. Set its Implementation class programmatically at run time.
  D. 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.
  E. You cannot avoid displaying the Bean area at run time.
  B. Set its Height and Width properties to 1.

  ---

  *

  To hide the Bean on the canvas, select the Bean in the Layout editor. Set the Width and Height properties to 1, and set the background and foreground color to the color of the canvas.

  *

  In the Layout Editor, add a Bean Area to your Canvas. Since it will be a non-visual Bean, you may want to make it small and put it out of the way of the other Items. However, it must be present on the same Canvas as the visual Items to function.

• Question 85:

  You want to use the Forms Debugger to diagnose a problem with the RAISE_STATUS program unit that is stored in the database.

  Forms Builder, you set a breakpoint in the stored code, and then run the Human Resources form in debug mode. You click the Raise_Salaries button, which has a When Button Pressed trigger that calls RAISE_SALARIES.

  However, you are unable to see the RAISE_SALARIES procedure when you step through the code, and it does not appear in the stack frame. What could be the reason for this problem?

  A. You are not connected to the database.
  B. The stored program unit was not compiled with the debug information included.
  C. The breakpoint should have been set in the When-Button-Pressed trigger, not in the stored program unit.
  D. You cannot use the Forms Debugger to diagnose problems with stored program units.
  D. You cannot use the Forms Debugger to diagnose problems with stored program units.

  ---

  The Forms debugger can only step through Forms side code, not database side code. If you Form calls a database procedure, you will not be able to see what it does through the Forms debugger.

• Question 86:

  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

  *

  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?

  A. One Note style alert and caution style alert
  B. One Note style alert and one Stop style alert
  C. On Caution style alert and one stop style alert
  D. On Note style alert, one Caution style alert, and one Stop style alert
  E. Two Caution style alerts and one Stop style alert
  D. On Note style alert, one Caution style alert, and one Stop style alert

  ---

  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.

  

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

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

  A. Database transactions are always continued across forms.
  B. Code is always shared among forms.
  C. A calling form must pass data to a called form.
  D. A global record group is always created.
  E. Only A and B are true.
  F. Only B and C are true.
  G. Only C and D are true.
  H. None of the statements above are true.
  H. None of the statements above are true.

  ---

  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.

  Note:

  CALL_FORM

  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 to CALL_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.

  NEW_FORM

  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.

  Incorrect answers:

  A: session_mode:

  NO_SESSION (The default.): Specifies that the opened form should share the same database session as the current form.

  SESSION: Specifies that a new, separate database session should be created for the opened form.

  C: data_mode

  NO_SHARE_LIBRARY_DATA (The default.):At runtime, Oracle Forms will not share data between forms that have identical libraries attached (at design time). SHARE_LIBRARY_DATA: At runtime, Oracle Forms will share data between

  forms that have identical libraries attached (at design time).

  Reference: Difference between call_form, new_form and open_form

• Question 88:

  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
  A. $$DBDATE$$
  C. SYSDATE
  D. :GLOBAL.SHIP_DATE

  ---

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

  View the Exhibit.

  

  You have integrated the WebUtil utility into the Orders form. You code a When-Button-Pressed trigger to call some WebUtil functionality, and then run the form to test it. Everything works as it should.

  You then write some other triggers and test the form again. Before the form appears, you receive several errors that are similar to the one shown in the Exhibit.

  What is a probable cause of this error?

  A. You have invoked WebUtil functionality from a trigger that does not accept restricted built- ins.
  B. You have invoked WebUtil functionality from a Pre-form trigger.
  C. You did not recompile the WebUtil library after adding new triggers.
  D. You did not enable the GetClientinfo JavaBean.
  E. Java is not installed on the client machine, so SET_JAVA_VERSION returns an error.
  C. You did not recompile the WebUtil library after adding new triggers.

• Question 90:

  When you plan to use a toolbar canvas, you should allow room for it on the content canvas so that items on the canvas are not obscured.

  A. True
  B. False
  B. False

  ---

  Note: Toolbar canvases can contain buttons and other GUI elements, and allow you to provide a common interface for all canvases displayed within a window. You can associate the toolbar canvas with the window shared by the content canvases, and it will display. The location at which the toolbar displays can be controlled by the type of toolbar canvas used. A vertical toolbar canvas is used to display the toolbar along the left or right edge of the window.