Oracle 1Z0-141 Online Practice Questions and Exam Preparation

Oracle 1Z0-141 Online Questions & Answers

• Question 31:

  The menu that appears by default in a Forms application does not quite meet your needs, so you decide to create a custom menu. You create and compile a menu module called Test with three submenus that contain PL/SQL code, and you attach the Test menu to a form.

  How will the menu of the form appear and perform at run time?

  A. You will see only the three submenus from the Test menu (plus the Window menu that is usually displayed), and you will not be able to call code from the default menu in your form.
  B. You will see the three submenus from the Test menu merged with the submenus of the default menu (plus the Window submenu that is usually displayed).
  C. You will see only the submenus of the default menu (plus Window), but you will be able to call code from the Test menu in your form.
  D. You will see only the Test menu submenus (plus Window), but you will be able to call code from the default menu in your form.
  E. You will see only the submenus of the default menu (plus Window) until you issue the REPLACE_MENU built-in in the form.
  A. You will see only the three submenus from the Test menu (plus the Window menu that is usually displayed), and you will not be able to call code from the default menu in your form.

• Question 32:

  View the Exhibit.

  You are running a form in debug mode, but you have not set any breakpoints in the code. You click a button that invokes the code shown in the exhibit.

  While the code executes, you decide to examine the variable values in the loop.

  Which menu items in the Forms Builder Debug menu would you choose?

  

  A. Stop, Debug Windows > Variables
  B. Pause, Debug Windows > Variables
  C. Stop, Debug Windows > Form Values
  D. Pause, Debug Windows > Form Values
  E. Step Into, Debug Windows > Variables
  F. Step Into, Debug Windows > Form Values
  B. Pause, Debug Windows > Variables

• Question 33:

  While updating an existing customer record using the Customers form, the user invoked the Orders form by clicking the CONTROL.Orders_btn button. The When-Button-Pressed trigger had the following code:

  CALL_FORM('orders');

  There is a requirement to navigate back to the Customers form after the order details have also been updated. This will be achieved through a form-level Key-Exit trigger in the Orders form.

  Which code should be used?

  A. IF GET_APPLICATION_PROPERTY(calling_form) IS NOT NULL THENEXIT_FORM(ASK_COMMIT, NO_ROLLBACK);ELSEEXIT_FORM;END IF;
  B. VALIDATE(FORM_SCOPE);IF :SYSTEM.FORM_STATUS 'QUERY' THENGO_FORM ('customers');ELSEEXIT_FORM;END IF;
  C. ENTER;IF :SYSTEM.CURSOR_BLOCK = 'CHANGED' THENCOMMIT_FORM;ELSEEXIT_FORM(NO_VALIDATE, NO_ROLLBACK);END IF;
  D. IF :SYSTEM.FORM_STATUS = 'CHANGED' THENCOMMIT_FORM:END IF;GO_FORM('customers');
  A. IF GET_APPLICATION_PROPERTY(calling_form) IS NOT NULL THENEXIT_FORM(ASK_COMMIT, NO_ROLLBACK);ELSEEXIT_FORM;END IF;

• Question 34:

  You write a form in which there are two text items (FIELD1 and FIELD2) and a button (BTN1) arranged in the following navigation sequence:

  FIELD1, BTN1, FIELD2

  With the focus in FIELD1, the user presses the [Next Item] key and encounters a navigation trap, in which the cursor is unable to advance to the next item and cannot return to FIELD1.

  Which three conditions can combine to produce such a navigation trap? (Choose three.)

  A. FIELD1 has a Post-Text-Item trigger that fails.
  B. FIELD1 has a Pre-Text-Item trigger that fails.
  C. FIELD1 has a When-New-Item-Instance trigger that fails.
  D. FIELD2 has a Post-Text-Item trigger that fails.
  E. FIELD2 has a Pre-Text-Item trigger that fails.
  F. FIELD2 has a When-New-Item-Instance trigger that fails.
  G. The Keyboard Navigable property of BTN1 is set to No.
  H. The Keyboard Navigable property of BTN1 is set to Yes.
  B. FIELD1 has a Pre-Text-Item trigger that fails.
  E. FIELD2 has a Pre-Text-Item trigger that fails.
  G. The Keyboard Navigable property of BTN1 is set to No.

• Question 35:

  Which statement about the Data properties of a text item is true?

  A. If the Maximum Length of an item is set to a value that is greater than the value for Width, the item will not be displayed at run time.
  B. You can set the Initial Value for an item outside the range of values specified by the Lowest Allowed Value and the Highest Allowed Value properties because Initial Value defines an exception to that range.
  C. If you set the Required property to Yes for an item whose corresponding database column does not have a NOT NULL constraint, you will receive an error at run time.
  D. If the Data Length Semantics property is set to BYTE, you may need to manually adjust the Maximum Length property depending on the character set that is being used.
  D. If the Data Length Semantics property is set to BYTE, you may need to manually adjust the Maximum Length property depending on the character set that is being used.

• Question 36:

  The two-column LOCATION Record Group has 10 rows.

  At run time, the user wants to mark two or more LOCATION records for use by another Forms Builder object. The rows will be used to construct a WHERE clause for a subsequent data block query.

  Which built-in enable individual rows to be marked?

  A. ADD_GROUP_COLUMN
  B. SET_RECORD_PROPERTY
  C. GET_GROUP_SELECTION
  D. SET_GROUP_SELECTION
  E. RESET_GROUP_SELECTION
  F. GET_GROUP_RECORD_NUMBER
  D. SET_GROUP_SELECTION

• Question 37:

  You are running a multiple-form application. The Customers form invokes the Orders form. When the Orders form launches, it displays orders for only the active customer from the Customers form. Forms exchange data with the

  :GLOBAL.CUSTOMER_ID variable.

  The Orders form should be restricted to orders for the current customer only the first time a query is issued after invoking the Orders form.

  Which built-in helps you do this by setting the ONETIME_WHERE property to refer dynamically to the GLOBAL.CUSTOMER_ID?

  A. SET_APPLICATION_PROPERTY
  B. SET_FORM_PROPERTY
  C. SET_BLOCK_PROPERTY
  D. SET_RECORD_PROPERTY
  C. SET_BLOCK_PROPERTY

• Question 38:

  View the Exhibit.

  You are developing and testing a Forms application on a machine that has plenty of memory. The Customers block, whose Property Palette is shown in the exhibit, is based on a table that contains a large number of records.

  The initial query on the block appears quickly. However, after scrolling through hundreds of records in the block, you notice that it is taking longer and longer to retrieve the next set of records.

  What can you do to improve performance without losing the fast initial response?

  

  A. Set Single Record to Yes.
  B. Set Query All Records to Yes.
  C. Set Query Array Size to a larger number.
  D. Set Number of Records Buffered to a larger number.
  E. Set Number of Records Buffered to a smaller number.
  F. Set Number of Records Displayed to a smaller number.
  D. Set Number of Records Buffered to a larger number.

• Question 39:

  In the Orders form, you create a button in the CONTROL block to send the input focus to the INVENTORIES block and cause it to be queried.

  You write this code in a When-Button-Pressed trigger:

  GO_BLOCK('Inventories'); EXECUTE_QUERY;

  What happens when you test the form?

  A. The form will not compile because the block name must be uppercase.
  B. The form compiles, but clicking the button causes a Navigation Trap to be encountered. You must revise the code to avoid such a trap.
  C. The form compiles and runs as required. Focus moves to the INVENTORIES block, and it is queried automatically when the button is clicked.
  D. The form compiles and focus moves to the INVENTORIES block. But because the internal cursor is still in the CONTROL block, the query is attempted against the wrong block.
  E. The form compiles, but clicking the button causes an error message to appear. GO_BLOCK() is a restricted procedure and cannot be called from any "When" triggers.
  F. The form compiles, but clicking the button leaves the focus in the original block, which is then queried. This could have been prevented if you had coded a check for FORM_SUCCESS after the GO_BLOCK ();
  C. The form compiles and runs as required. Focus moves to the INVENTORIES block, and it is queried automatically when the button is clicked.

• Question 40:

  View the Exhibit.

  You are attempting to drag the Control and CV_Order objects to an object group as shown in the exhibit, but you are unable to release them in the Object Group Children node of the object group.

  What is the reason for this?

  

  A. You cannot drag a canvas to an object group.
  B. You cannot drag a block to an object group.
  C. You need separate object groups for different types of objects.
  D. You cannot drag multiple types of objects to an object group at the same time.
  E. You should drag them to the ObjectGroup96 node, not to its Object Group Children node.
  D. You cannot drag multiple types of objects to an object group at the same time.