Oracle 1Z0-151 Online Practice Questions and Exam Preparation

Oracle 1Z0-151 Online Questions & Answers

• Question 51:

  To troubleshoot a problem with a form, you have added a call to the MESSAGE () built-in at the beginning of the When-Validate-Item trigger of the Customer_Id then in the Orders Block of the Orders form. The message simply states that the trigger is firing.

  You run the form, make a change in Customer_Id, and then tab out of the item but the message does not appear. What are two possible causes for this problem?

  A. The form is in Enter-Query mode.
  B. The item is using an LOV for validation.
  C. The validation unit of the form needs to be changed.
  D. The MESSAGE () built-in is not allowed in validation triggers.
  E. There is a syntax error in the call to the MESSAGE() built-in.
  F. Validation for the Customer_Id item failed.
  A. The form is in Enter-Query mode.
  B. The item is using an LOV for validation.

  ---

  A: WHEN-VALIDATE-ITEM does not fire in ENTER-QUERY mode.

  B: LOVs in ENTER-QUERY Mode

  LOVs in ENTER-QUERY mode should be used sparingly, as Query Find is the preferred method for a user to locate records.

  You should only code them where they dramatically improve the usability of ENTER-QUERY mode, and you expect this mode to be used regularly despite Query Find.

  An LOV in ENTER-QUERY mode should display all values that the user can query, not just currently valid values.

  EXAMPLE: An LOV for vendors in a purchase order form in enter-query mode shows all vendors that could ever be placed on a PO, not just the set of vendors that currently are allowed to be placed on a PO. Do not reuse the entry LOV in ENTER_QUERY mode unless it provides the correct set of data for both modes.

  Important: WHEN-VALIDATE-ITEM does not fire in ENTER-QUERY mode. Therefore, you cannot depend on the WHEN-VALIDATE-ITEM trigger to clear hidden fields when selecting from an ENTER-QUERY LOV.

  Note: Validation occurs when you press enter, when you navigate away from the item, or when you save your block to the database.

  Note 2: When-Validate-Item trigger Description Fires during the Validate the Item process. Specifically, it fires as the last part of item validation foritems with the New or Changed validation status. Definition Level form, block, or item Legal Commands SELECT statements, unrestricted built-ins Enter Query Mode no Usage Notes

  *

  Use a When-Validate-Item trigger to supplement Form Builder default item validation processing.

  *

  It is possible to write a When-Validate-Item trigger that changes the value of an item that FormBuilder is validating. If validation succeeds, Form Builder marks the changed item as Valid anddoes not re-validate it. While this behavior is

  necessary to avoid validation loops, it does make itpossible for your application to commit an invalid value to the database.

  *

  The setting you choose for the Defer Required Enforcement property can affect the When- Validate-Item trigger. See Defer_Required_Enforcement for details. On Failure If fired as part of validation initiated by navigation, navigation fails, and the focus remains on theoriginal item. Fires In Validate the Item

• Question 52:

  You have a form with a single multi-record block. During a session, a user performs an insert and clicks Save What is the behavior of the record being inserted violates a database constraint?

  A. The record is posted to the database but not committed. The form redisplays the record with an error message so that the user can correct the data. Navigation to another record cannot occur until the correct data is committed or the new record is deleted. If the user exits the form without correcting the entry, a database rollback is performed.
  B. The record is committed to the database. The form redisplays the record with an error message so that the user can correct the data. The user is unable to exit the form or move to another record until the correct data is committed of the new record is deleted.
  C. A database rollback is performed. The form redisplays the record with an error message so that the user can correct the entry. The user is able to navigate to another record or exit the form.
  D. A database rollback is performed. The form redisplays the record with an error message so that an correct the entry. Navigation to another record cannot occur until the correct data is committed or the record is deleted.
  E. The record is committed to the database. The form redisplays the record with a warning in case the user would like to correct the entry. The user is able to navigate to another record or exit the form.
  A. The record is posted to the database but not committed. The form redisplays the record with an error message so that the user can correct the data. Navigation to another record cannot occur until the correct data is committed or the new record is deleted. If the user exits the form without correcting the entry, a database rollback is performed.

• Question 53:

  The Orders database table uses Order_id as its primary key. You have written the following code to use in the Orders block of a form:

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

  Which statement is true about this code?

  A. If you place this Code in a trigger that fires when the record is inserted into the database, you will likely have more gaps in Order IDs than if you use the sequence as a default value for the item.
  B. If you place this code in a trigger, you should ensure that Order_Id has its required property set to Yes.
  C. If you place this code in a trigger, you should ensure that Order_Id has its Database Item property set to No.
  D. If the named sequence does not exist, it is automatically created the first time the code is called.
  E. You should place this code a in a database trigger to minimize the gaps in Order IDs.
  F. You should place this code in Pre-insert trigger to minimize the gaps in Order IDs.
  G. You should place this code in a Post_insert trigger to minimize the gaps in Order IDs.
  F. You should place this code in Pre-insert trigger to minimize the gaps in Order IDs.

  ---

  Assigning Sequence Numbers to Records

  You will recall that you can assign default values for items from an Oracle sequence, to automatically provide unique keys for records on their creation. However, if the user does not complete a record, the assigned sequence number is

  "wasted." An alternative method is to assign unique keys to records from a Pre-Insert trigger, just before their insertion in the base table, by which time the user has completed the record and issued the Save.

  Assigning unique keys in the posting phase can:

  *

  Reduce gaps in the assigned numbers

  *

  Reduce data traffic on record creation, especially if records are discarded before saving

  Example This Pre-Insert trigger on the ORDERS block assigns an Order ID from the sequence ORDERS_SEQ, which will be written to the ORDER_ID column when the row is subsequently inserted. SELECT ORDERS_SEQ.nextval INTO :ORDERS.order_id FROM SYS.dual;

• Question 54:

  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
  B. the UI_ICON setting in the operating system
  C. the iconpath setting in the Forms registry file

  ---

  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

• Question 55:

  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'.
  A. Change FIND_ITEM to FIND_MENU_ITEM.
  F. Change GET_ITEM_PROPERTY to GET_MENU_ITEM_PROPERTY
  G. Change SET_ITEM_PROPERTY to SET_MENU_ITEM_PROPERTY

  ---

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

  You put some code in a Post_Update trigger and raise the FORM_TRIGGER_FAILURE under certain conditions. Does a rollback take place if the trigger falls?

  A. Yes. Although the update has been applied to the database, the old column values are retained as rollback data; so a failure of this trigger automatically reinstates the original values.
  B. No. It is too late to perform a rollback at this stage because the update has already been applied.
  C. The value have already been applied, so you must programmatically save the old values in the global variables or PL/SQL variables if you want to reinstall the original values.
  B. No. It is too late to perform a rollback at this stage because the update has already been applied.

  ---

  The record has already been updated.

  Note: FORM_FAILURE

  Returns a value that indicates the outcome of the action most recently performed during the current Runform session.

  Use FORM_FAILURE to test the outcome of a builtin to determine further processing within any trigger. To get the correct results, you must perform the test immediately after the action executes. That is, another action should not occur prior

  to the test.

• Question 57:

  Which three statements are true about the PL/SQL Packages panel in the Forms debugger?

  A. You can select an option button to view server packages.
  B. You can view packages only while the runtime process executes PL/SQL.
  C. You can view the values of variables that are defined in the package specification.
  D. You ran select an option button to view the packages that have not yet been instantiated.
  A. You can select an option button to view server packages.
  B. You can view packages only while the runtime process executes PL/SQL.
  C. You can view the values of variables that are defined in the package specification.

  ---

  PL/SQL Packages Panel: This panel is used only to browse and examine the PL/SQL packages which are been instantiated while executing the form.

• Question 58:

  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
  A. True

• Question 59:

  You do not want users to execute queries while in the Order_Items block, so you write the following key- Exeqry trigger for the Order_Items block:

  GO_BLOCK('orders'); EXECUTE_QUERY;

  This works fine except that in the Order_Items block, when you click Enter Query first, and then click Execute Query, you get the error message "FRM-41009: Function key not allowed." What can you do correct this?

  A. Set the Fire in Enter-Query Mode property of the Key-Exeqry trigger to Yes.
  B. Add the following as the first of the key-Exqry trigger to Yes. SYSTEM.mode := 'NORMAL';
  C. Delete the Key-Exqry trigger and define the following Key-Entqry trigger for the Order_Items block: GO_BLOCK ('orders'); ENTER_QUERY;
  D. Delete the Key-Exqry trigger and define the following Key-Entqry trigger for the Order_Items block: ENTER_QUERY; GO_BLOCK ('orders');
  E. Change the key-Exqry trigger to: IF : SYSTEM.MODE := 'ENTER-QUERY' THEN GO_BLOCK ('orders'); EXECUTE_QUERY; ELSE MESSAGE ('you cannot execute a query for the Order_Items block'): END IF; Define the following Key-Entqry trigger for the Order_Items block: GO_BLOCK ('orders'); ENTER_QUERY
  F. Change the Key-Exeqry trigger to: IF :SYSTEM.MODE != 'ENTER-QUERY' THEN GO_BLOCK('orders'); EXECUTE_QUERY; ELSE MESSAGE ('You cannot execute a query in this block'); ENTER_QUERY; GO_BLOCK ('orders');
  G. You cannot change this behavior, but you should use the On-Message trigger to display a more meaningful message.
  C. Delete the Key-Exqry trigger and define the following Key-Entqry trigger for the Order_Items block: GO_BLOCK ('orders'); ENTER_QUERY;

  ---

  Note: You can use system variables and built-ins to obtain information about queries.

  Using SYSTEM.mode

  Use the SYSTEM.mode system variable to obtain the form mode. The three values are NORMAL , ENTER_QUERY , and QUERY.

  NORMAL Indicates that the form is currently in normal processing mode. ENTER-QUERY Indicates that the form is currently in Enter Query mode. QUERY Indicates that the form is currently in fetch processing mode, meaning that a query is

  currently being processed.

  Note 1: ENTER_QUERY procedure

  Clears the current block and creates a sample record. Operators can then specify query conditions before executing the query with a menu or button command.If there are changes to commit, the Forms Builder prompts the operator to commit

  them before continuing ENTER- QUERY processing

  Note 2: 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- QUERYprocessin

• Question 60:

  You want to use WebUtil functionality in the Orders form. What three things must you do to integrate WebUtil into the Orders Form?

  A. Copy the WebUtil object group from the WebUtil object library into a separate object library.
  B. Subclass the WebUtil object group from the WebUtil object library into the Orders form.
  C. Ensure that the WebUtil block is the last block under the Data Blocks node in the Object Navigator.
  D. Ensure that the WebUtil block is the first block under the Data Blocks node in the Object Navigator.
  E. Attach the WebUtil library to the Orders form.
  F. Copy the WebUtil library to the same directory as the Orders form.
  G. in the When-New-Form-instance trigger, register the WebUtil javaBeans.
  H. Set the Implementation Class Property for any items that will implement WebUtil JavaBeans.
  B. Subclass the WebUtil object group from the WebUtil object library into the Orders form.
  C. Ensure that the WebUtil block is the last block under the Data Blocks node in the Object Navigator.
  E. Attach the WebUtil library to the Orders form.

  ---

  Integrating WebUtil into a Form

  Step 1: Attaching the WebUtil Library (E)

  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 (B)

  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.

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