Oracle 1Z0-151 Online Practice Questions and Exam Preparation

Oracle 1Z0-151 Online Questions & Answers

• Question 41:

  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.
  E. You cannot achieve this, because the When-Validate-Item trigger cannot be set to fire in Enter-Query mode.

  ---

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

  Which type of variable must be declared before it is used in a trigger?

  A. PL/SQL variable
  B. Form item
  C. global variable
  D. system variable
  E. parameter
  A. PL/SQL variable

  ---

  PL/SQL is the language used in Forms triggers and program units.

  PL/SQL lets you declare variables and constants, then use them in SQL and procedural statements anywhere an expression can be used. You must declare a constant or variable before referencing it in any other statements.

  Variables can have any SQL datatype, such as CHAR, DATE, or NUMBER, or a PL/SQL-only datatype, such as BOOLEAN orPLS_INTEGER.

  Note:

  PL/SQL's data types correspond with SQL's column types, making it easy to interchange PL/SQL variables with data inside a table.

• Question 43:

  You have a form that called a database stored procedure. You do not want processing to continue, so immediately after the call to the stored procedure, you add the following code:

  IF NOT FORM_SUCCESS THEN

  MESSAGE ('Stored Procedure failure');

  RAISE FORM_TRIGGER_FAILURE;

  END IF;

  You test the code and input some data that intentionally causes the stored procedure to fail. However, the message that you defined does not appear. What are two possible reasons for this?

  A. You must handle database errors in an exception clause of the trigger.
  B. You must test for FORM_FAILURE when testing for failure of a stored procedure.
  C. You must test for FORM_FATAL when testing for failure of a stored procedure.
  D. FORM_SUCCESS tests for failure of Forms built-ins, not stored procedures.
  E. You cannot test for failure of a stored procedure, because database errors are transparent to Forms.
  A. You must handle database errors in an exception clause of the trigger.
  D. FORM_SUCCESS tests for failure of Forms built-ins, not stored procedures.

  ---

  A: You should use DBMS_ERROR_CODE and DBMS_ERROR_TEXT in an ON-ERROR trigger to trap errors propagated from Oracle server from Forms.

  Note: FORM_SUCCESS and FORM_TRIGGER_FAILURE

  Either the FORM_SUCCESS built-in or the FORM_TRIGGER_FAILURE exception must be used to handle all Forms errors. FORM_SUCCESS is a Boolean function that evaluates to TRUE or FALSE depending on the success or failure of a Forms built-in. FORM_TRIGGER_FAILURE is an exception that has to be raised to stop further processing whenever an error occurs or FORM_SUCCESS evaluates to FALSE. The following sections describe their use in error-message handling.

• Question 44:

  The Enforce Primary Key property of a data block ensures that the primary key of a new record exists in the database.

  A. True
  B. False
  A. True

  ---

  Starting with Oracle version 8 Oracle has the ability to enforce primary key and unique key constraints using non-unique indexes.

• Question 45:

  Which four types of variables must have their names preceded by a colon when they are referenced in trigger code?

  A. PL/SQL variables
  B. Form items
  C. global variables
  D. system variables
  E. parameters
  A. PL/SQL variables
  B. Form items
  C. global variables
  D. system variables

  ---

  D: Example:

  On calling the

  raiseEvent method, a trigger named WHEN-CUSTOM-JAVASCRIPT-EVENT is fired on the server side.

  declare

  event_val varchar2(300):= :system.javascript_event_value; begin if (:system.javascript_event_name='show') then

  handleShowEvent(event_val);

  elsif(:system.javascript_event_name='grab') then

  handleGrabEvent(event_val);

  else

  null;

  end if;

  end;

• Question 46:

  View the Exhibit.

  

  You are creating a menu for use with several forms. You create the structure of the menu in the Menu Editor. As shown in the Object Navigator in the Exhibit, which objects are menu items?

  A. MENU3 only
  B. ITEM6 only
  C. MENU3, ITEM4, ITEM5, ITEM5_MENU, and ITEMG
  D. ITEM4, ITEM5, and ITEM6 only
  E. ITEM4 and ITEM5 only
  F. ITEM 4 and ITEM6 only
  G. ITEM5 and ITEM only
  H. MENU3 and ITEM5_MENU only
  D. ITEM4, ITEM5, and ITEM6 only

  ---

  MENU3 and ITEM5_MENU are menus.

• Question 47:

  The Orders form has four blocks. The Orders and Order_items block are on the CV_Order content canvas; the inventories block items are on the CV_inventories content canvas; and Control block buttons are on the CV_Buttons toolbar

  canvas. All buttons have mouse Navigate set to No.

  The Order_Items block is a detail of Orders. The inventories block is a detail of Order_Items, showing the stock of the selected product.

  There is a button in the Control block with a When-Button-Pressed trigger:

  IF GET_CANVAS_PROPERTY(:SYSTEM.cursor_item, item_canvas) = 'CV_ORDER' THEN GO_BLOCK ('inventories')

  ELSE

  GO_BLOCK('orders');

  END IF;

  When you run the form and click the button, navigation does not occur, and the form displays the runtime error "FRM-41053: Cannot find Canvas: invalid ID." What should you do to correct this problem?

  A. Change the sequence of blocks in the Object Navigator
  B. Chang the Mouse Navigator property of the button to yes
  C. in the first line of code, change the built-in to GET_ITEM_PROPERTY
  D. in the first line of code, change the system variable to: SYSTEM.CURSOR_CANVAS.
  E. in the first line of code, change the CV_ORDER to lowercase
  F. Chang the argument to the GO_BLOCK built-ins to uppercase
  D. in the first line of code, change the system variable to: SYSTEM.CURSOR_CANVAS.

  ---

  Note: GET_CANVAS_PROPERTY built-in Description Returns the given canvas property for the given canvas. . Syntax FUNCTION GET_CANVAS_PROPERTY( canvas_id Canvas ,property NUMBER);FUNCTION GET_CANVAS_PROPERTY( canvas_name VARCHAR2 ,property NUMBER)

• Question 48:

  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
  D. as an application message on the status line

  ---

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

  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.
  A. Delete the "On-" triggers; these triggers remove default processing, including array processing.

  ---

  *

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

  You have been assigned to maintain a Forms application that was designed by a developer who has left the company.

  The CV_Tools canvas contains several buttons. There is limited space on the canvas, but the first button is not quite wide enough to display its complete label. In the Layout Editor, you widen the button slightly and find that the width of all the

  buttons increases so that they now overlap each other.

  What could have caused this problem?

  A. The buttons inherit their properties from the same property class.
  B. The buttons were created by dragging them from an object group.
  C. The buttons were created by using a Smart Class.
  D. All other buttons were subclassed from the first button.
  E. All other buttons were copied from the first button.
  F. The first button was subclassed from another button.
  G. The first button was copied from another button.
  D. All other buttons were subclassed from the first button.

  ---

  D (not F): 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.

  Incorrect answers:

  A: A property class is a named object that contains a list of properties and their settings. You can use property classes to increase productivity and improve network performance. Here are some of the uses of a property class:

  *

  It increases productivity by setting standard or frequently used values for common properties and associates them with several form builder objects.

  *

  It defines standard properties not just for one particular object but also for several at a time. This results in increased productivity, because it eliminates the time spent on setting identical properties for several objects.

  *

  It improves network performance by increasing the efficiency of message diffing.

  C: A SmartClass is a special member of an Object Library. It can be used to easily subclass existing objects in a form using the SmartClass option from the right mouse button popup menu. E, G: 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.