Oracle Oracle Certifications 1Z0-151 Questions & Answers

• Question 21:

  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.

  Correct Answer: AB

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

  You are using a PL/SQL program unit in the Orders form to display an image for the selected product in

  the Order Items block. The code is called from several different triggers in the form.

  The code (with line numbers added) is:

  1.

  PROCEDURE get_image IS

  2.

  Product_image_id ITEM := FIND_ITEM ('control.product_image');

  3.

  Filename VARCHAR2(250);

  4.

  BEGIN

  5.

  Filename := TO_CHAR(:order_items.product_id) | | '.jpg';

  6.

  READ_IMAGE_FILE (filename, 'jpeg', product_image_id);

  7.

  END;

  Management wants all codes to be in PL/SQL libraries to facilitate reuse. You create a PL/SQL library and

  drag the program unit from the orders form to the Program Units node of the library.

  You then delete the program unit from the Orders form.

  What three things must you do to compile the PL/SQL library and to use the code in the Orders form?

  A. Change line 5 to: filename := to_char(name_in 'order_items.product_id' )) | | '.jpg';.

  B. insert the RELEASE keyword between lines 1 and 2.

  C. Delete the BEGIN and END statements (lines 4 and 7).

  D. Change product_id to an in parameter and filename to an OUT parameter.

  E. Save the library.

  F. Generate the a .plx file.

  G. Attach the library to the orders form.

  H. Change the way the program unit is called in the Orders form.

  Correct Answer: EGH

  E: Save and compile the library.

  G: select the Attached Libraries node and click Create.

  In the Attach Library dialog box, click Browse to navigate to the saved library and open it, then answer Yes

  to the alert that asks if you want to remove the path.

  H: Modify the to simply call the procedure from the attached library:

• Question 23:

  You have written a When-Validate-Item trigger. You want this trigger to fire even if the form is in Enter-Query mode. What must you do to achieve this?

  A. Use the following code at the start of the When Validate-Item trigger: :SYSTEM.mode := 'ENTER-QUERY';

  B. Use the following code at the start of the When Validate Item trigger: :SYSTEM.mode := 'NORMAL';

  C. Set the Fire in Enter Query Mode property of the When-Validate-Item trigger.

  D. You do not need to do anything, because the default for the When Validate Item trigger is to fire in Enter-Query mode.

  E. You cannot achieve this, because the When-Validate-Item trigger cannot be set to fire in Enter-Query mode.

  Correct Answer: E

  Coding Triggers for Enter-Query Mode Some triggers that fire when the form is in Normal mode (during data entry and saving) may also be fired in Enter-Query mode. You need to consider the trigger type and actions in these cases. "Fire in Enter-Query Mode"Property To create a trigger that fires in Enter-Query mode, in its Property Palette set the "Fire in Enter- Query Mode"property to Yes. This property determines whether Forms fires a trigger if the associated event occurs in Enter-Query mode. Not all triggers can do this. See last line in note below.

  By default, the "Fire in Enter-Query Mode"property is set to Yes for triggers that accept this. Set it to No in the Property Palette if you want the trigger to fire only in Normal mode.

  Note:

  The following triggers may fire in Enter-Query mode:

  *Key

  *

  On-Error

  *

  On-Message

  *

  When-triggers, except: -When-Database-Record -When-Image-Activated -When-New-Block-Instance -When-New-Form-Instance -When-Create-Record -When-Remove-Record -When-Validate-Record -When-Validate-Item

• Question 24:

  You have been assigned to maintain the Orders form. Users complain that if the cursor is in the in the Orders block, they cannot navigate to the Order Items block by clicking a text item in that block. They must click the Next Block button to navigate from the Orders block to the Order Items block.

  How should you investigate the source of the problem?

  A. Check the Pre-Text-Item and Post-Text-Item triggers, because users may be encountering a navigation trap.

  B. Check the Navigation properties of the Orders block that have non-default values.

  C. Check the Navigation properties of the Order Items block that have non-default values.

  D. Check the Navigation properties of the items in the Orders block that have non-default values.

  E. Check the Navigation properties of the form that have non-default values.

  F. Check that the items in the Order Items block are enabled.

  Correct Answer: A

  The Navigation Trap You have seen that the Pre-and Post-navigation triggers fire during navigation, and when they fail the internal cursor attempts to return to the current item(SYSTEM.CURSOR_ITEM).The diagram below illustrates the navigation trap. This can occur when a Pre-or Post-navigation trigger fails and attempts to return the logical cursor to its initial item. However, if the initial item has a Pre-Text-Item trigger that also fails the cursor has nowhere to go, and a fatal error occurs. Note: Be sure to code against navigation trigger failure

  

• Question 25:

  You have coded the following When Button Pressed trigger:

  EXECUTE_QUERY;

  MESSAGE ('Query executed on block');

  MESSAGE ('click next to navigate the next record');

  When the user clicks the button, how is the message "Query executed on block" displayed?

  A. as a system message on the status line

  B. as a system message in a system alert

  C. as a system message in an application alert

  D. as an application message on the status line

  E. as an application message in a system alert

  F. as an application message in an application alert

  Correct Answer: D

  This is a customized application message.

  You can also build messages and alerts into your application:

  * Application message: These are messages that you build into your application by using the MESSAGE built-in. The default display is on the message line. *Application alert: These are alerts that you design as part of your application, and issue to the operator for a response by using the SHOW_ALERT built-in.

• Question 26:

  Which two actions are always necessary when deploying Forms applications that were developed on Windows platform to a UNIX middle tier server?

  A. moving the forms executable files from the development machine to the middle-tier machine

  B. compiling the Forms modules on the middle tier machine

  C. creating a menu module for the application

  D. compiling the Forms modules on the development machine

  E. moving the Forms source files from the development machine to the middle tier machine

  F. creating a Forms PL/SQL library file to contain the application logic

  G. installing forms Builder on the middle-tier machine

  Correct Answer: AD

  Once you have created your application in Forms Developer, you are ready for application Web

  deployment. Oracle Forms Services accesses an application in Oracle Fusion Middleware through a

  specified URL. The URL then accesses the HTTP Listener, which communicates with the Listener Servlet.

  The Listener Servlet starts a Forms run- time process (frmweb.exe on Windows or frmweb on UNIX and

  Linux) for each Forms Services session.

  Note:

  To deploy a basic form with the default parameters set up by the installer:

  1.

  Create your application in Forms Developer and save it. The .fmb file is a design time file that can only

  be opened in Forms Developer. The .fmx file is the run-time file created when you compile the .fmb and is

  used for Web deployment.

  2.

  Modify the formsweb.cfg file so that Oracle Forms Services can access your application module.

  3.

  Make sure the .fmx file location is specified in the FORMS_PATH environment variable.

  4.

  To modify an environment file, select the file in the Environment Configuration page of Fusion

  Middleware Control and add or edit environment variables as needed by your application

  5.

  Enter the name of your application in the URL as shown:

  http://example.com:8888/forms/frmservlet?

  where "example" is the hostname of your computer and "8888" is the port used by your HTTP Listener.

  Once you have created a configuration section, add "config=" and the name of the configuration section. In

  this example, the URL to access hrapp.fmx is:

  http://example.com:8888/forms/frmservlet?config=my_

  application

• Question 27:

  View the Exhibit.

  

  The Departments form has form level triggers defined as shown in the Exhibit. You have enabled array DML for the Departments block by setting its DML array size to 5 and setting the Primary Key property of Department id to Yes. You set runtime preferences for Forms Builder to use array processing.

  You want to test that array processing is actually occurring, so, as shown in the Exhibit, the On- Update, On-Delete, and on insert triggers have code that:

  1.

  Displays a message to indicate which trigger is firing for which record?

  2.

  Does the thing (either updates, deletes, or inserts)

  The other triggers simply display a message, indicating the trigger that is firing.

  You run the form from Forms Builder, but from the messages, you can tell that array processing is not occurring. What should you change so that array DML gets implemented?

  A. Delete the "On-" triggers; these triggers remove default processing, including array processing.

  B. Set the DML array size to a value of 10 or greater; for array sizes loss than 10, array processing Is inefficient, and so is not performed.

  C. Use the SYNCHRONIZE built-in after the MESSAGE built-in; otherwise, the message are not displayed until the processing is finished, giving the appearance that array processing is not taking place.

  D. Set the Enforce Primary Key property of the Department block to Yes; it is not enough to just set the Department_Id to be the primary key.

  Correct Answer: A

  *

  ON-INSERT

  Override default processing for inserting a new row into the database during "post" processing Override the doDML() method in your entity class, and if theoperation equals DML_INSERT, then write code instead ofcalling the super.

  *

  ON-DELETE

  Override default processing for deleting a row removed from the data block from the database during "post" processing Override the doDML() method in your entity class, and if theoperation equals DML_DELETE, then write code instead ofcalling the super.

  *

  ON-UPDATE

  Override default processing for updating a row changed in the data block from the database during "post"

  processing

  Note: Use Array Processing

  Both Forms Developer and Reports Developer are able to take advantage of the Oracle database server's

  array processing capabilities. This allows records to be fetched from the database in batches instead of

  one at a time, and results in significantly fewer calls to the database. The downside of array processing is

  that more space is required on the execution platform for storing the arrays of records returned.

  If load on the network becomes a major bottleneck in the production environment, then set the Developer

  product's runtime ARRAYSIZE parameter to as large a value as possible for the execution environment.

  Note 2:

  Query Array Processing

  The default behavior of Forms is to process records one at a time. With array processing, astructure

  (array) containing multiple records is sent to or returned from the server for processing.Forms supports

  both array fetch processing and array data manipulation language (DML)processing. For both querying

  and DML operations, you can determine the array size to optimizeperformance for your needs.

  Note 3: You can enable array processing for queries by:

  *Setting preferences:

  -Select Edit > Preferences.

  -Click the Runtime tab.

  -Select the Array Processing check box.

  * Setting block properties: -In the Object Navigator, double -click the node of the block to display the PropertyPalette. -Under the Records category, set the Query Array Size property to a number that represents the number of records in the array for array processing

• Question 28:

  There are certain errors that are specific to the Salary item on the Employees form. You want to trap these errors only when the user navigates from the Salary item.

  You have a form-level On-Error trigger that traps errors that apply to the form in general, but yon additionally code an item-level On-Error trigger for the Salary item.

  When testing the form, you find that the general errors are not trapped when you navigate from the Salary item. What can you do to correct this problem?

  A. Call the form level On-Error trigger from the item-level On-Error trigger.

  B. Call the item-level On-Error trigger from the form-level On-Error trigger.

  C. Change the Execution Hierarchy property for the item-level On-Error trigger.

  D. Change the Execution Hierarchy property for the form-level On-Error trigger.

  E. Move all the code to a PL/SQL program unit and call it from both the form level and item level On-Error triggers.

  Correct Answer: C

  when you have a WHEN-NEW-ITEM-INSTANCE :

  if you create a trigger on item, block and form-level, then only the ITEM-Level will start. If you use the exec-

  hierarchy Override.

  If all trigger use After, then the FORM, BLOCK and ITEM starts in that sequence.

  If all trigger use Before, then the ITEM, BLOCK and FORM starts in that sequence.

  the execution-hierarchy on FORM-Level is ignored, because there is no higher level than FORM

• Question 29:

  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

  Correct Answer: F

  *

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

  View the Exhibit.

  

  The orders form contains two canvases. Orders_CV displays one order and all of its order items. Help-CV displays context-sensitive help.

  When users invoke the help screen for the Customer_Id item, the help information obscures the Custormer_Id item, as shown in the Exhibit. Users would like to be able to see both the item and its help information simultaneously.

  How can you move the help information to the right so that the Customer_Id item is visible?

  A. increase the Viewport X Position on the Help_CV canvas.

  B. increase the Viewport X Position on Canvas on the Orders_CV canvas.

  C. Decrease the Width on the Help_CV canvas.

  D. in the Layout Editor for the Orders_CV canvas, select View > Stacked Views, and then select the Help_CV canvas. Drag the Help_CV canvas to the right of the Customer_Id item.

  Correct Answer: A

  Note: Viewport X Position on Canvas, Viewport Y Position on Canvas property Description Specifies the location of the view's upper left corner relative to the upper left corner of the canvas. The size and location of the viewport define the view ; that is, the part of the canvas that is actually visible in the window to which the canvas is assigned. Applies to canvas