Oracle 1Z0-141 Online Practice Questions and Exam Preparation

Oracle 1Z0-141 Online Questions & Answers

• Question 91:

  There is a requirement to modify the default functionality of the [Commit] key. To implement this requirement, you decide to write a Key-Commit trigger that will force validation and issue a commit if necessary. Which trigger code will achieve this?

  A. ENTER;IF GET_ITEM_PROPERTY(:SYSTEM.trigger_item,ITEM_IS_VALID) = 'TRUE' THENCOMMIT_FORM;END IF;
  B. ENTER;IF :SYSTEM.FORM_STATUS = 'CHANGED' THENCOMMIT_FORM;END IF;
  C. VALIDATE(ITEM_SCOPE);IF :SYSTEM.RECORD_STATUS = 'NEW' THENDO_KEY('COMMIT_FORM');END IF;
  D. VALIDATE;IF :SYSTEM.BLOCK_STATUS 'NEW' THENDO_KEY('COMMIT_FORM');END IF;
  E. VALIDATE(ITEM_SCOPE);IF :SYSTEM.BLOCK_STATUS = 'NEW' THENCOMMIT_FORM;END IF;
  B. ENTER;IF :SYSTEM.FORM_STATUS = 'CHANGED' THENCOMMIT_FORM;END IF;

• Question 92:

  In an Order Entry form, the Order_Items block has a text item called Shipping_Date, which is of the Date data type. The Lowest Allowed Value and the Highest Allowed Value properties are not defined for this item. Assuming that all of the following are defined, which three are valid settings for the Initial Value property of the Shipping_Date item? (Choose three.)

  A. $$DBDATE$$
  B. :Orders.Order_Date + 3
  C. SYSDATE
  D. :GLOBAL.SHIP_DATE
  E. :PARAMETER.SHIP_DATE
  F. ORDER_ITEMS_SEQ
  A. $$DBDATE$$
  D. :GLOBAL.SHIP_DATE
  E. :PARAMETER.SHIP_DATE

• Question 93:

  The Orders form is a master-detail form in which ORDERS is a single-record master block and ORDER_ITEMS is a multirecord detail block.

  During testing of the Orders form, users have complained about the behavior of Enter-Query mode.

  In the form they are testing, they are unable to navigate out of the current block while they are in Enter-Query mode. However, they would like to be able to carry out the following procedure:

  1.

  Press [Enter Query] while in the master block.

  2.

  Enter some search criteria.

  3.

  Navigate to the detail block.

  4.

  Enter more search criteria (while the form is still in Enter-Query mode).

  5.

  Press [Execute Query] to have the criteria applied to both blocks at once. How can you provide the requested functionality?

  A. The requested functionality is the default behavior. You simply need to remove or rewrite the triggers you wrote that "broke" the form.
  B. Use a Key-Entqry trigger on the master block to redirect the focus to the detail block after the search criteria have been entered in the master block.
  C. You cannot perform the requested operation with a master-detail form. The restriction on navigating out of the current block during Enter-Query mode cannot be circumvented.
  D. Use a Key-Exeqry trigger on both the master and detail blocks to call a centralized procedure and have rocedure handle the navigation.
  E. Use a Key-Nxtblk trigger on the ORDERS block to cause navigation to the ORDER_ITEMS block. This will work because Key triggers can fire in Enter-Query mode and can call restricted built-ins such as GO_BLOCK().
  F. Use a combination of Key-Entqry and Key-Exeqry triggers at form level to call generically written procedures to test where the current focus is and set global variables that a form-level Key-Nxtblk trigger can use to redirect the focus.
  C. You cannot perform the requested operation with a master-detail form. The restriction on navigating out of the current block during Enter-Query mode cannot be circumvented.

• Question 94:

  You start an OC4J instance on your development PC and then run a form from the Forms Builder.

  Which statement describes the behavior of OC4J?

  A. It appears in the Forms Builder window, which you can minimize after OC4J starts.
  B. It appears in a separate window, which you can close after OC4J starts.
  C. It appears in the Forms Builder window, which you can close after OC4J starts.
  D. It appears in a separate window, which you should not close or the OC4J instance will abort.
  E. It appears in a separate window, which you should not minimize or the OC4J instance will abort.
  D. It appears in a separate window, which you should not close or the OC4J instance will abort.

• Question 95:

  You are testing a form. How can you programmatically disable validation during testing?

  A. You cannot programmatically disable validation in a form.
  B. Use the SET_FORM_PROPERTY built-in to set the VALIDATION property.
  C. Use the SET_FORM_PROPERTY built-in to set the VALIDATION_UNIT property.
  D. Use the SET_FORM_PROPERTY built-in to set the DEFER_REQUIRED_ENFORCEMENT property.
  E. Use the CLEAR_FORM, CLEAR_BLOCK, and EXIT_FORM built-ins with the NO_VALIDATE argument.
  B. Use the SET_FORM_PROPERTY built-in to set the VALIDATION property.

• Question 96:

  You are developing an application for use by meteorologists. Form1 contains a list item based on a query of cloud types that are stored in a database table. Users can add cloud types to the list by typing in new values that are automatically inserted to the database table. Form1 calls Form2, which contains an identical list item. You do not want to requery the database to obtain the list of cloud types.

  Which method can you use to pass the cloud types from Form1 to Form2?

  A. Parameter list
  B. Global variables
  C. Global record group
  D. Shared PL/SQL library
  E. There is no way to pass such data between forms; you must requery the data from the database.
  C. Global record group

• Question 97:

  You want to create a calculated item in the Control block of the Human Resources form. This item will contain the total of employee salaries for employees in a particular department. Which statement is true about how to create the calculated item?

  A. You can create it by first creating a text item and then changing the item type.
  B. You can create it in the Layout Editor using a special tool that creates a calculated item.
  C. You can create it by first creating a display item and then setting appropriate properties in its Calculation property group.
  D. You can create it in the Layout Editor by selecting the Salary item of the Employees block, selecting the Control block from the block list, clicking the Text Item tool, and drawing a text item on the canvas to automatically calculate a sum of the selected Salary item.
  C. You can create it by first creating a display item and then setting appropriate properties in its Calculation property group.

• Question 98:

  You are developing an Order Entry application. The Customers form calls the Orders form and passes the value of Customer_Id as a parameter by the same name, so that the orders for only that customer are layed.

  Which three statements are true? (Choose three).

  A. You must create the parameter at design time in the Customers form.
  B. You must create the parameter at design time in the Orders form.
  C. You must create the parameter programmatically in the Customers form.
  D. You must create the parameter programmatically in the Orders form.
  E. You can programmatically refer to the parameter as :parameter.customer_id in the Customers form.
  F. You can programmatically refer to the parameter as :parameter.customer_id in the Orders form.
  B. You must create the parameter at design time in the Orders form.
  C. You must create the parameter programmatically in the Customers form.
  F. You can programmatically refer to the parameter as :parameter.customer_id in the Orders form.

• Question 99:

  An Order Entry form that you are developing contains several blocks. The first is a control block where you create buttons to perform certain actions.

  One button, which is mouse and keyboard navigable, contains code to navigate to and perform queries in multiple blocks in the form:

  GO_BLOCK('Customers'); EXECUTE_QUERY; GO_BLOCK('Orders'); EXECUTE_QUERY; GO_BLOCK('Items'); EXECUTE_QUERY;

  You do not want trigger processing to continue if there is any type of error in navigating to the Customers block.

  How should you modify the code?

  A. GO_BLOCK('Customers');if FORM_SUCCESS thenEXECUTE_QUERY;end if;GO_BLOCK ('Orders');EXECUTE_QUERY;GO_BLOCK('Items');EXECUTE_QUERY;
  B. GO_BLOCK('Customers');if not FORM_FAILURE thenraise FORM_TRIGGER_FAILURE;end if;EXECUTE_QUERY;GO_BLOCK('Orders');EXECUTE_QUERY;GO_BLOCK('Items');EXECUTE _QUERY;
  C. GO_BLOCK('Customers');if not FORM_SUCCESS thenraise FORM_TRIGGER_FAILURE;end if;EXECUTE_QUERY;GO_BLOCK('Items');EXECUTE_QUERY;GO_BLOCK ('Items');EXECUTE_QUERY
  D. GO_BLOCK('Customers');if FORM_FATAL thenraise FORM_TRIGGER_FAILURE;end if;EXECUTE_QUERY;GO_BLOCK('Orders');EXECUTE_QUERY;GO_BLOCK ('Items');EXECUTE_QUERY
  C. GO_BLOCK('Customers');if not FORM_SUCCESS thenraise FORM_TRIGGER_FAILURE;end if;EXECUTE_QUERY;GO_BLOCK('Items');EXECUTE_QUERY;GO_BLOCK ('Items');EXECUTE_QUERY

• Question 100:

  Which two statements are true of a Query Record Group? (Choose two.)

  A. The Record Group is associated with a query.
  B. The Record Group can be created only at run time.
  C. The Record Group can be created and modified only at design time.
  D. The Record Group can be created and modified at design time or at run time.
  E. The query associated with this Record Group can be defined only at design time.
  F. The query associated with this Record Group can be modified only at design time.
  G. The query associated with this Record Group can be modified only at run time.
  A. The Record Group is associated with a query.
  D. The Record Group can be created and modified at design time or at run time.