Oracle Oracle Certifications 1Z0-151 Questions & Answers

• Question 71:

  View the Exhibit.

  

  You have placed the following code in a Post insert trigger on the Orders block:

  SELECT orders_seq.NEXTVAL INTO :orders.order_id FORM SYS.dual;

  You have also set Item properties for the Order_Id Item in the form so that users cannot directly enter an Order ID.

  As the SUMMIT user, you run the form to test it. Yon are able to insert a record in the block, but when you click Save, you have a database error as shown in the Exhibit.

  What is the probable cause of this error?

  A. The code should be in Pre_insert trigger instead

  B. The code should be in a database trigger instead

  C. You should change the code to select the sequence number from SUMMIT.dual instead.

  D. You should create the sequence in the database, because the runtime error is an indication that is does not exist.

  E. You should assign a temporary value to the Order_Id item before saving the form.

  Correct Answer: E

• Question 72:

  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.

  Correct Answer: B

  The WLS managed server WLS_FORMS must be started.

• Question 73:

  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.

  Correct Answer: H

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

  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

  Correct Answer: D

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

  You have created an editor named MyEditor, and you want it to be available to edit the text item Product_Description. You can associate the editor with the text item by setting the Editor property of Product_Description to MyEditor.

  A. True

  B. False

  Correct Answer: A

• Question 76:

  The Orders form is sometimes run automatically and sometimes run from the Customers form, when it is

  run from the Customers form, any queries should be restricted to the customer that is currently selected.

  The Customers form button that runs the Orders form sets a global variable to the current customer ID.

  The Orders form has a button labeled Execute Query with the following When-Button Pressed trigger:

  DEFAULT_VALUE (NULL, 'GLOBAL.Customer_id');

  IF: GLOBAL.customer_id IS NOT NULL

  THEN

  SET_BLOCK_PROPERTY ('orders', DEFAULT_WHERE, 'orders.customer_id = ' | |

  :GLOBAL.CUSTOMER_id);

  END IF;

  EXECUTE_QUERY

  You want to duplicate that functionality in a menu item for the Summit menu that is attached To the Orders

  form.

  What changes must you make to the code so that the menu code functions as it does in the form?

  A. Change both occurrence of :GLOBAL.customer_id to 'GLOBAL.customer_id'.

  B. Change 'GLOBAL.customer_id' in line 1 to :GLOBAL.customer_id.

  C. Change both occurrence of :GLOBAL.customer_id to NAME_IN ('GLOBAL.customer_id').

  D. You do not need to change anything; the code compiles and functions correctly in the menu item.

  E. You cannot add this type of code in the menu because it refers to the items on the form that cannot be referenced from a menu.

  Correct Answer: C

  Because you cannot refer directly to form values in menu code, change :GLOBAL.customer_id to the following indirect reference: NAME_IN('GLOBAL.customer_id')

  Note: You could also change the references to the global variable to use the NAME_IN built-in; however, this is not strictly necessary, because global variables are available directly throughout the application.

  Reference: Managing Oracle Forms Menu Modules

• Question 77:

  To avoid overloading the database during busy times, you decide to restrict the queries that are executed on the Orders form so that users query by either Order ID or Customer ID during these times. Which trigger is most appropriate for the code to enforce this restriction?

  A. When-New-Form-instance

  B. When-New-Block-instance

  C. On-Query

  D. Pre-Query E. Post-Query

  Correct Answer: D

  About controlling queries with Pre-Query and Post-Query triggers

  The Pre-Query and Post-Query triggers allow control over query processing. They can be defined at the

  form or block level. Most often, attach them to specific blocks to control the query functionality of those

  blocks.

  The Pre-Query trigger fires just before Form Builder issues the SELECT statement to the database, after

  the operator has defined the example record by entering query criteria in Enter Query mode.

  Inside a Pre-Query trigger, the example record defined by the query criteria is the current record. This

  means that trigger code can read and set the values of items in the example record using standard

  :block_name.item_name syntax.

  A Pre-Query trigger can be used to disallow query conditions that might be invalid. When a form is in Enter

  Query mode, normal validation is suspended and no validation triggers fire as they do in Normal mode.

  The Pre-Query trigger thus allows you to verify that any values entered by the operator are valid query

  conditions.

  When invalid query conditions have been entered, you can abort the query by raising the

  FORM_TRIGGER_FAILURE built-in exception in the Pre-Query trigger.

  You can also call SET_BLOCK_PROPERTY to modify the block's WHERE and ORDER BY clauses from

  within the Pre-Query trigger, to further restrict or order the records the query will retrieve.

• Question 78:

  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

  Correct Answer: D

• Question 79:

  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

  Correct Answer: E

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

  In Forms Builder, the iconic buttons on the form are blank, but when you click Run Form the form appears in the browser with Images in the iconic buttons.

  What are two things that you can check to track the source of this problem?

  A. forms Builder runtime preferences

  B. the UI_ICON setting in the operating system

  C. the iconpath setting in the Forms registry file

  D. the UI_ICOM_EXTENSION setting in the operating system

  E. the iconextension setting in the Forms registry file

  F. the FORMS_PATH setting in the Forms environment file

  G. the classpath setting in the operating system

  Correct Answer: BC

  C: assume you put your gif in a directory /icon under your /forms on server, then in the registry.dat file, find the section containing sth below

  xxx.xxx.iconpath=

  xxx.xxx.iconextension =,

  set above iconpath=/icon

  iconextension =gif