Oracle Oracle Certifications 1Z0-151 Questions & Answers

• Question 51:

  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'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?

  A. 1, 2, and 3

  B. 1, 3, and 2

  C. 1 and 2 only

  D. 2 and 3 only

  E. 3 only

  Correct Answer: A

  All three triggers fire when you navigate

• Question 52:

  View the Exhibit.

  

  The Summit menu is attached to the Orders form. The Toggle Autoquery menu item is a check box that

  toggles whether a query is automatically performed when the Orders form is first invoked. If the check box

  is deselected, users must manually query.

  In addition to using the menu, users want to be able to toggle the autoquery preference directly from the

  form. You add a button named Toggle Autoquery with the following When-Button- Pressed trigger:

  DECLARE

  mi_id MENUITEMS;

  BEGIN

  mi_id ;=FIND_ITEM ('Preferences.AutoQuery')

  /* Determine the current checked static of the AutoCommit menu checkbox item And toggle the checked

  state*/

  IF GET_ITEM_PROPERTY (mi_id, CHECKED) = 'TRUE' THEN

  SET_ITEM_PROPERTY (mi_id, CHECKED, PROPERTY_FALSE);

  ELSE

  SET_ITEM_PROPERTY (mi_id, CHECKED, PROPERTY_TRUE);

  END IF;

  END;

  However, the trigger does not compile. What three changes must you make so that the trigger compiles

  successfully?

  A. Change FIND_ITEM to FIND_MENU_ITEM.

  B. Change 'preferences.AutoQuery' to 'orders.preferences.AutoQuery'.

  C. Change 'preferences.AutoQuery' to 'AutoQuery'.

  D. Change 'preferences.AutoQuery' to 'ORDERS.PREFERENCES>AUTOQUERY'.

  E. Change 'preferences.AutoQuery' to 'AUTOQUERY'.

  F. Change GET_ITEM_PROPERTY to GET_MENU_ITEM_PROPERTY

  G. Change SET_ITEM_PROPERTY to SET_MENU_ITEM_PROPERTY

  H. Change PROPERTY_FALSE to 'FALSE'.

  I. Change PROPERTY_TRUE to 'TRUE'.

  Correct Answer: AFG

  A: Note: FIND_MENU_ITEM built-in Description Searches the list of menu items and returns a menu item ID when it finds a valid menu item with the given name. You must define an appropriately typed variable to accept the return value. Define the variable with a type of MenuItem.

  Note 2:

  FIND_ITEM built-in

  Description

  Searches the list of items in a given block and returns an item ID when it finds a valid item with the given

  name. You must define an appropriately typed variable to accept the return value. Define the variable

  with a type of Item.

  Example (with FIND_MENU_ITEM, GET_MENU_ITEM_PROPERTY,

  SET_MENU_ITEM_PROPERTY)

  FIND_MENU_ITEM examples

  /*

  ** Built-in: FIND_MENU_ITEM

  ** Example: Find the id of a menu item before setting

  ** multiple properties

  */

  PROCEDURE Toggle_AutoCommit_Mode IS

  mi_id MenuItem;

  val VARCHAR2(10);

  BEGIN

  mi_id := Find_Menu_Item('Preferences.AutoCommit');

  /*

  ** Determine the current checked state of the AutoCommit ** menu checkbox item

  */

  val := Get_Menu_Item_Property(mi_id,CHECKED);

  /*

  ** Toggle the checked state

  */

  IF val = 'TRUE' THEN

  Set_Menu_Item_Property(mi_id,CHECKED,PROPERTY_FALSE);

  ELSE

  Set_Menu_Item_Property(mi_id,CHECKED,PROPERTY_TRUE);

  END IF;

  END;

• Question 53:

  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.

  Correct Answer: C

• Question 54:

  View the Exhibit.

  

  The DBA has added a 30-character Cust_Middle_Name field to the Customers table and wants you to add it to the Customers form. It should be on the same line as the as the first and last names, which are on the Name tab page of the Tab_Customer canvas that appears in the Layout Editor as shown in the Exhibit. The Tab_Customer tabbed canvas is displayed on the Customer_CV content canvas as shown in the Exhibit.

  What must you do to accommodate the additional label and text item and to display the middle name?

  A. increase the Width property of the Customer_CV canvas only.

  B. increase the Width property of the Tab_Customer canvas only.

  C. increase the Width properties of only the Customer_CV canvas and the Tab_Customer canvas.

  D. increase the Width properties of the Customer_CV canvas, the Tab_Customer canvas, and the name tab page.

  Correct Answer: C

• Question 55:

  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.

  Correct Answer: D

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

  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 ('Stored Procedure failure');

  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?

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

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

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

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

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

  Correct Answer: AD

  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 processing whenever an error occurs or FORM_SUCCESS evaluates to FALSE. The following sections describe their use in error-message handling.

• Question 57:

  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.

  Correct Answer: B

  *

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

  View the Exhibit.

  

  You are attempting to drag the Control and CV_Order objects to an object group as shown in the Exhibit, but you are unable to release them in the Object Group Children node of the object group.

  What is the reason for this?

  A. You cannot drag a canvas to an object group.

  B. You cannot drag a block to an object group.

  C. You need separate object groups for different types of objects.

  D. You cannot drag multiple types of objects to an object group at the same time.

  E. You should drag them to the ObjectGroup96 node, not to its Object Group Children node.

  Correct Answer: C

  See 5) below.

  Note: Object Groups An object group is a logical container for a set of Forms Builder objects. You need to define an object group when you want to package related objects for copying or subclassing in another module or if you want to bundle numerous objects into higher-level building blocks that you can use again in another application. You can package the various objects in an object group and copy the entire bundle in one operation. Steps to create an object group

  1.

  Select the Object Group node in the Object Navigator.

  2.

  Select the Create icon.

  3.

  Rename the new object group that is displayed.

  4.

  Click the form module and expand all the nodes.

  5.

  Select all the objects of one type that you want to include in the object group.

  6.

  Drag the selected objects into the new object group entry.

  Key notes about object groups

  Including a block in an object group also includes its items, the item-level triggers, the block-level triggers

  and the relations. You cannot use any of these objects in an object group without the block.

  It is not possible to include another object group.

  Deleting an object from a module automatically deletes the object from the object group.

  Deleting an object group from a module does not delete the objects it contains from the module.

• Question 59:

  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'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'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

  Correct Answer: A

• Question 60:

  Identify a function of the Forms Servlet.

  A. It creates a dynamic HTML file.

  B. It starts a Forms runtime session.

  C. It manages network requests from the Forms Client.

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

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

  Correct Answer: B

  OracleAS Forms Services uses the Forms Listener Servlet (a Java servlet) to start, stop, and communicate with the Forms runtime process. The Forms runtime is what executes the code contained in a particular Forms application. The Forms Listener Servlet manages the creation of a Forms runtime process for each client and manages the network communications between the client and its associated Forms runtime process. The Forms Listener Servlet replaces the Forms Listener provided in previous releases of Oracle Forms.

  Reference: Oracle Application Server Forms Services Deployment Guide, Forms Listener Servlet