Oracle 1Z0-151 Online Practice Questions and Exam Preparation

Oracle 1Z0-151 Online Questions & Answers

• Question 61:

  View the Exhibit.

  

  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, 'Database trigger says no!'); end if; END;

  You run the Orders form, change the customer ID, and click Save. You receive the error message "FRM- 40509: Oracle error: unable to UPDATE record." You select Help > 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?

  A. IF ERROR_CODE = 40509 THEN MESSSAGE (DBMS_ERROR_TEXT); END IF
  B. IF ERROR_CODE = 40509 THEN MESSSAGE (SQLERRM); END IF;
  C. IF ERROR_CODE = 06512 THEN MESSSAGE(DBMS_ERROR_TEXT); END IF;
  D. IF ERROR_CODE = 06512 THEN MESSSAGE (SQLERRM); END IF;
  E. IF ERROR-CODE = 20101 THEN MESSSAGE (DBMS_ERROR_TEXT); END IF;
  F. IF ERROR_CODE = 20101 THEN MESSSAGE(SQLERRM); END IF;
  F. IF ERROR_CODE = 20101 THEN MESSSAGE(SQLERRM); END IF;

  ---

  The error code raised by your code is 20101.

  The SQLERRM function returns the error message associated with the most recently raised error exception.

  Note: The RAISE_APPLICATION_ERROR procedure lets you issue user-defined ORA-n error messages from stored subprograms. That way, you can report errors to your application and avoid returning unhandled exceptions.

  To invoke RAISE_APPLICATION_ERROR, use the following syntax:

  raise_application_error(

  error_number, message[, {TRUE | FALSE}]);

  where error_number is a negative integer in the range -20000..-20999 and message is a character string up to 2048 bytes long. If the optional third parameter is TRUE, the error is placed on the stack of previous errors. If the parameter is

  FALSE (the default), the error replaces all previous errors.

• Question 62:

  View the Exhibit.

  

  Iin the Human Resources form shown in the Exhibit, you want to modify the prompts, heights, and widths of the Department Id, Manager Id, and Location Id Holds in the Departments data block. What must you select before invoking the Layout Wizard in reentrant mode to modify these item properties?

  A. Frame5
  B. Frames
  C. Canvas4
  D. the Departments block
  E. the DEPARTMENT_ID, MANAGER_ID and LOCATION_ID items
  C. Canvas4

  ---

  From the exhibit we see that Department Id, Manager Id, and Location Id are all present on Canvas4.

• Question 63:

  The Orders form, you want to enable users to use Microsoft Excel to create and print an invoice for the customer. The file should be created on the user's computer so that it can be printed with the local printer.

  Which WebUtil package would you use to implement this requirement?

  A. CLIENT_GET_FILE_NAME
  B. CLIENT_HOST
  C. CLIENT_OLE2
  D. CLIENT_TEXT_IO
  E. CLIENT_Win_API
  F. WEBUTIL_FILE
  G. WEBUTIL_UTIL
  C. CLIENT_OLE2

  ---

  Note: Performing OLE Automation on the Client

  You can use any OLE2 package on the client by prefixing it with CLIENT_. You can see the list of the OLE2 package procedures and functions in the Forms Builder ObjectNavigator under the Built-in Packages node.

  Note 2: With WebUtil, you can do the following on the clientmachine: open a file dialog box, read and write image or text files, execute operating system commands, perform OLE automation, and obtain information about the client machine

• Question 64:

  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.
  C. You need separate object groups for different types of objects.

  ---

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

  View the Exhibit to examine the form.

  

  The text items (Field1, Field2, and Field3) and the button (Check_Values) are in the CONTROL block. The Mouse Navigate property of the button has been set to No.

  The following code as been written in a When-Button-Pressed trigger on the Check_Values button:

  MESSAGE(:field1| | ' - ' | | :SYSTEM.cursor_item | |

  ' - ' | | :SYSTEM.trigger_item);

  With the focus in Field1 and the values 1, 2, and 3 in the text items, what message will be displayed when the button is clicked.

  A. -4
  B. 1 -2 -3
  C. 1 field1 Check Values
  D. Field1 -1 Check Values
  E. 1 CONTROL.FIELD1 CONTROL.FIELD1
  F. 1 CONTROL.FIELD1 CONTROL.CHECK_VALUES
  G. :field1 - :SYSTEM.cursor_item - :SYSTEM.trigger_item
  F. 1 CONTROL.FIELD1 CONTROL.CHECK_VALUES

  ---

  *

  SYSTEM.CURSOR_ITEM

  Represents the name of the block and item, block.item, where the input focus (cursor) is located.

  The value is always a character string.

  In this scenario the value is CONTROL.Field1, as the focus is in Field1.

  *

  SYSTEM.TRIGGER_ITEM

  Represents the item (BLOCK.ITEM) in the scope for which the trigger is currently firing. When referenced in a key trigger, it represents the item where the cursor was located when the trigger began. The value is always a character string.

  In this scenario the value is CONTROL.CHECK_VALUES, as the CHECK_VALUES button is being clicked.

• Question 66:

  Which three are valid ways to populate a display item?

  A. initial Value property
  B. User input
  C. When-Button-Pressed trigger
  D. Calculation
  E. Executing a query
  A. initial Value property
  C. When-Button-Pressed trigger
  D. Calculation

  ---

  C: You can use the attachable PL/SQL libraries to implement a flexible message function formessages that are displayed programmatically by the built-in routines MESSAGE orCHANGE_ALERT_MESSAGE, or by assigning a message to a

  display item from a triggeror procedure.

  D: Creating Calculated Items

  Change the Item Type to Display Item.

  Set the Calculation Mode property to Formula.

  Set the Formula property to the required formula.

  Incorrect answers:

  B: Display items and text items are fairly similar and share many of the same properties. The biggest difference between the two is that a user can navigate to a text item and change its value. This is not possible with a display item. As its name implies, it merely displays information.

  Note: Display items do not allow any user interaction - they merely display data and never accept cursor focus. Use a display item for the following situations:

  *

  Null-canvas fields

  *

  Context fields

  *

  Fields that act as titles or prompts

• Question 67:

  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
  A. 1, 2, and 3

  ---

  All three triggers fire when you navigate

• Question 68:

  When users enter address information, you want them to be able to select the state from a static list of values. You have not used a list of states before, and there is no database table that contains state information. What is the first step in creating such a list of values as quickly as possible?

  A. invoke the LOV wizard.
  B. Create a new record group that is based on a SQL query.
  C. Create a new static record group.
  D. Create a list item instead; a list of values is not appropriate for a static list.
  A. invoke the LOV wizard.

  ---

  ow to create LOV in Oracle forms?

  List of Values(LOV) are used either when a selected list is too long and hence would not be appropriate for a drop down, but needs a search form to select the value.

  Steps to create LOV functionality:

  *

  Click on the LOV icon in the object navigator and choose a manual/automatic wizard. This will create a record group.

  *

  Open a search form in the Dialog Page

  *

  Select values inside this form.

  *

  Return selected values to the original page.

• Question 69:

  You have a text item in your form named Object1. You want to create Object2 as an exact duplicate of Object1. You want to be able to change the properties of Object2. However if you change Object1, you do not want Object2 to change.

  Which method of reusing Object1 would be best for these requirements?

  A. Copying Object1
  B. Subclassing Object1
  C. Creating a property class from Object1
  D. Putting Object1 in an Object library
  E. Referencing Object1 in a PL/SQL library
  A. Copying Object1

  ---

  When you copy an object, a separate, unique version of that object is created in the target module. Any objects owned by the copied object also get copied. Changes made to a copied object in the source module do not affect the copied object in the target module.

  Incorrect answers:

  B: With subclassing you can make an exact copy, and then alter the properties of some objects if desired. If you change the parent class, the changes also apply to the properties of the subclassed object that you have not altered. However,

  any properties that you override remain overridden.

  This provides a powerful object inheritance model.

• Question 70:

  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
  A. Layout Editor
  D. Layout wizard
  E. Object Navigator

  ---

  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.