Oracle 1Z0-151 Online Practice Questions and Exam Preparation

Oracle 1Z0-151 Online Questions & Answers

• Question 21:

  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.
  C. Subclass the webUtilConfig parameter from the WebUtil object library into the form.
  E. Move the WebUtil data block to the last position under the Data Blocks node in the Object Navigator.

  ---

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

  You have created a complex menu structure with several types of menu objects. To which objects would you assign menu commands?

  A. main menus
  B. individual menus
  C. submenus
  D. menu items
  E. all of the above
  E. all of the above

  ---

  The Menu Editor is a graphical design facility for laying out, modifying, and viewing menu modules and their objects. You can use the Menu Editor to carry out all of your menu design work.

  Note:

  To use the Menu Editor to create a basic structure for your menu, perform the following steps:

  1 .

  With the SUMMIT_MENU module selected, perform one of the following actions to invoke the Menu Editor:

  Double-click the icon to the left of the module Right-click the module and select Menu Editor Select Tools > Menu Editor from the Forms Builder menu

  2 .

  When you invoke the Menu Editor, it automatically creates the main menu and one menu item. The main menu is the menu whose items, which can be menu items or submenus, show in the menu bar when you run a form.

  In the Object Navigator, change the name of the main menu to MAIN_MENU in the same way that you changed the name of the menu module.

  3 .

  In the Object Navigator, change the name of the menu item to File.

  4 .

  Note that the item's display label in the Menu Editor remains the same.

  The label is the text that is displayed for the menu item at run time. The label may differ from the name. You use the name programmatically, and it must follow PL/SQL naming conventions.

  Change the label of the menu item by double-clicking in the Menu Editor and typing the new label of File.

  5 .

  Create two menu items under File. In the Menu Editor, select File, then click Create Down twice.

  6 .

  In the Menu Editor, relabel the menu items to Save and Exit.

  Note that creating menu items under the File object creates a FILE_MENU object as a menu with two items under it. Also, when you relabel the items in the Menu Editor, the names of the items, as shown in the Object Navigator, also change.

  7 .

  Create another submenu of the main menu and label it Edit by performing the following steps:

  In the Menu Editor, select the File node.

  Click Create Right.

  Relabel the new menu Edit.

  8 .

  In a similar fashion to the way you created the File menu items, create two items for the Edit menu labeled Copy and Paste.

  9 .

  You can also use the Object Navigator to add a menu item.

  Under the Edit_Menu in the Object Navigator, select the Items node and click Create.

  10 .

  In the same way as you did with other items, relabel the new item in the Menu Editor with the label Cut, which also renames it in the Object Navigator.

  Reference: Creating Oracle Forms Menus

• Question 23:

  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.
  B. It has no functionality.

• Question 24:

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

  A. True
  B. False
  B. False

  ---

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

• Question 25:

  You have installed WebLogic and Forms with a default configuration, which has been tested and determined to be correct.

  After creating a basic form in the Forms Builder, you click Run Form to test it. Forms Builder displays an error dialog box with the following message:

  FRM-10142: The HTTP Listener is not running on at port 9001. Please start the listener or check your runtime preferences.

  What is one action that you can take to resolve this error?

  A. Start the Web Logic Administration server.
  B. Start the WLS_FORMS managed server.
  C. Change the serverURL parameter in formsweb.cfg
  D. Start the Oracle HTTP server.
  E. Start WebCache.
  B. Start the WLS_FORMS managed server.

  ---

  The WLS managed server WLS_FORMS must be started.

• Question 26:

  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.
  A. The cursor successfully navigates to the first record.

  ---

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

  View the Exhibits.

  

  The hierarchical tree shown at run time in Exhibit 1 is populated programmatically. Default hierarchical tree properties are shown in Exhibit?

  

  Which properties of the hierarchical tree shown in Exhibit 1 have been changed from the default?

  A. Allow Empty Branches and Multi Selection only
  B. Allow Empty Branches and Show Symbols only
  C. Multi Selection and Show Symbols only
  D. Allow Empty Branches, Multi Selection, and Show Symbols
  A. Allow Empty Branches and Multi Selection only

  ---

  Both Chen and Popp are selected, so Multi-selection is set to Yes (not B). + and symbols are displayed, so Show Symbols is yes (not B, C, D). Allow Empty Branches is set to Yes (so A is ok), see note below.

  Note: Setting Hierarchical Tree Item Properties Hierarchical Tree properties include the following:

  *

  Item Type: Must be set to Hierarchical Tree

  *

  Allow Empty Branches: Yes / No. No is the default.

  If set to Yes, all leaf nodes will initially display in the tree with the plus sign (+) next to it, indicating that expansion is possible, even when there is nothing to expand. If set to Yes, the Show Symbols property must also be set to Yes.

  If set to No, leaf nodes will not have an expand/collapse symbol

  *

  Multi Selection: Whether multiple nodes may be selected at one time No is the default.

  *

  Show Lines: Whether a hierarchical tree displays lines leading up to each node Yes is the default.

  *

  Show Symbols: Whether a hierarchical tree should display + or - symbols in front of each branch node

  *

  Record Group: Name of the record group from which the hierarchical tree derives its values

  *

  Data Query: Specifies the query-based data source

• Question 28:

  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.
  C. The form runs, but as soon as it appears, you receive a runtime error.

  ---

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

• Question 29:

  View the Exhibit.

  

  What four facts can you determine by examining the Object Navigator?

  A. The Orders block is a detail block.
  B. The Order_Items block is a detail block.
  C. An order can be deleted only if it has no order items.
  D. If an order is deleted, all of its order items are deleted.
  E. You cannot delete order items without deleting the order.
  F. You can delete an order without deleting its order items.
  G. The Orders block is a master block.
  H. The Order_Items block is a master block.
  I. If you delete an order item, all of its associated inventory items are deleted.
  J. The inventories block is a master block.
  B. The Order_Items block is a detail block.
  C. An order can be deleted only if it has no order items.
  D. If an order is deleted, all of its order items are deleted.
  G. The Orders block is a master block.

  ---

  B: Order_Items is a detail block.

  C (not F): A master block record cannot be deleted if there are corresponding detail block records.

  D: To delete an order, all the corresponding order items must be deleted, for example through an ON- CHECK-DELETE-MASTER trigger.

  G: The Orders block is a master block.

  Incorrect answers:

  E: Order_items can very well be deleted without deleting the corresponding order.

  J: There are no triggers for INVENTORIES.

  Either Master or Detail Triggers would have been created if it was either a Master or Detail block.

  Note: Master/Detail Triggers:

  Oracle Forms generates master/detail triggers automatically when a master/detail relation is defined between blocks. The default master/detail triggers enforce coordination between records in a detail block and the master record in a master

  block. Unless developing custom block- coordination schemes, you do not need to define these triggers.

  *

  On-Check-Delete-Master Fires when Oracle Forms attempts to delete a record in a block that is a master block in a master/detail relation.

  *

  On-Clear-Details Fires when Oracle Forms needs to clear records in a block that is a detail block in a master/detail relation because those records no longer correspond to the current record in the master block.

  *

  On-Populate-Details Fires when Oracle Forms needs to fetch records into a block that is the detail block in a master/detail relation so that detail records are synchronized with the current record in the master block.

• Question 30:

  Customers log in to your Orders application by using their customer ID, which is saved as a global variable. When the Orders form first comes up, you want it to be populated with the customer's orders, and you do not want customers to be

  able to query for another customer's orders.

  You code the following triggers:

  When-New Form instance on the Orders form:

  GO_BLOCK('orders');

  EXECUTE_QUERY;

  You also have a button in the Control block labeled Query Orders with a When-Button Pressed trigger that has the same code as the When New-Form instance trigger. To test the form, you run it and log in a Customer 104. When you click

  Query Orders, all orders are shown, not just those for Customer 104.

  What is the best way to correct this issue to ensure that the customer can never query another customer's orders?

  A. Delete the Key-Exeqry trigger and add the its first line after the call to GO_BLOCK in the When-New- Form-instance trigger.
  B. Change the last line of the When-Button-Pressed code to: DO_KEY ('EXECUTE_QUERY');
  C. Delete the Key-Exqry trigger and put its code in an On-Select trigger.
  D. Delete the Key-Exqry trigger and put its code in a Pre-Query trigger.
  B. Change the last line of the When-Button-Pressed code to: DO_KEY ('EXECUTE_QUERY');

  ---

  Note: EXECUTE_QUERY procedure Clears the current block, opens a query, and fetches anumber of selected records. If there are changes tocommit, Forms Builder prompts the operator to committhem before continuing EXECUTE- QUERYprocessing