Oracle 1Z0-141 Online Practice Questions and Exam Preparation

Oracle 1Z0-141 Online Questions & Answers

• Question 21:

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

  You are developing a Human Resources form for HR clerks to insert, update, and delete records from the EMPLOYEES table. When the user commits records, Forms displays the default informative message "FRM-40400: Transaction

  complete: records applied and saved."

  You want to replace that with the message "Records inserted: Records updated: Records deleted: ", where represents the number of records inserted, updated, and deleted.

  Which triggers must you create or modify to accomplish this?

  A. On-Message only
  B. Post-Commit and On-Message
  C. Post-Database-Commit and On-Message
  D. When-Validate-Record and On-Message
  E. Post-Insert, Post-Update, Post-Delete, and On-Message
  E. Post-Insert, Post-Update, Post-Delete, and On-Message

• Question 23:

  The Orders form is required to initialize differently for different users.

  A database procedure (GET_ROLE_NAME) is used to determine which database roles are enabled for the user logging on to the form. If the user has the STORE_CLERK role enabled, certain buttons are disabled and the focus is sent to the

  Customer_Id text item. If the user has the ADMIN_MGR role enabled, all buttons are available and the focus is sent to the Date_Ordered text item. You have written a procedure (SET_BUTTONS) to set the appropriate button properties.

  The functionality is achieved with this code:

  IF get_role_name(USER) = 'STORE_CLERK' THEN

  set_buttons('STORE_CLERK');

  GO_ITEM('ORDERS.Customer_id');

  ELSE

  set_buttons('ADMIN_MGR');

  GO_ITEM('ORDERS.Date_Ordered');

  END IF;

  What is the best trigger to execute this code?

  A. Pre-Form at form level
  B. When-Validate-Item at form level
  C. When-New-Form-Instance at form level
  D. When-Button-Pressed on any of the enabled buttons
  E. Pre-Block on the first navigable block in the form
  F. When-New-Item-Instance on the Date_Ordered text item
  C. When-New-Form-Instance at form level

• Question 24:

  You have the Orders form open in Forms Builder. You create an object group in the Orders form and you try to drag various components in the Object Navigator to the object group. Which two components will you be unable to place in the object group? (Choose two.)

  A. the Orders block of the Orders form
  B. the Order_CV canvas of the Orders form
  C. the When-New-Item-Instance trigger of the Order_Items.Quantity item in the Orders from
  D. the When-New-Form-Instance trigger of the Orders form
  E. the Product_Id item in the Order_Items block of the Orders form
  C. the When-New-Item-Instance trigger of the Order_Items.Quantity item in the Orders from
  E. the Product_Id item in the Order_Items block of the Orders form

• Question 25:

  Which three statements about display items are true? (Choose three.)

  A. A display item can be a database item.
  B. The contents of a display item can be read and changed programmatically.
  C. If a display item is part of a control block, its Calculation Mode property is ignored.
  D. A display item does not have a Format Mask property, so a text item must be used where that functionality is required.
  E. The contents of a display item can be validated using a Key-Next-Item trigger with the scope of the display item.
  F. A display item does not have a Multi-Line property, so a text item must be used where that functionality is required.
  A. A display item can be a database item.
  B. The contents of a display item can be read and changed programmatically.
  F. A display item does not have a Multi-Line property, so a text item must be used where that functionality is required.

• Question 26:

  A user has requested a change to the Summit.fmb module. The form has two windows, DEPT_WIN and EMP_WIN. DEPT_WIN is always visible to the user. However, EMP_WIN is only occasionally required to be open. The user complains that once EMP_WIN is open, it is not possible to make the window invisible.

  The user can navigate between the open windows. You are asked not to write code to close EMP_WIN explicitly.

  What changes should you make to the Summit form?

  A. Define EMP_WIN as a modal window and set the Hide on Exit property to No.
  B. Define EMP_WIN as a modal window and set the Hide on Exit property to Yes.
  C. Define EMP_WIN as a modal window and set the Close Allowed property to Yes.
  D. Define EMP_WIN as a modeless window and set the Hide on Exit property to No.
  E. Define EMP_WIN as a modeless window and set the Hide on Exit property to Yes.
  F. Define EMP_WIN as a modeless window and set the Close Allowed property to Yes.
  E. Define EMP_WIN as a modeless window and set the Hide on Exit property to Yes.

• Question 27:

  What type of message indicates a Forms message that cannot be suppressed?

  A. a Busy message
  B. a level 0 message
  C. a Working message
  D. a level 25 message
  E. a level 50 message
  F. a message with a level less than 0
  G. a message with a level greater than 25
  H. a message with a level greater than 50
  G. a message with a level greater than 25

• Question 28:

  You apply the Btn_PC property class to the Exit button and then make several changes in the property values of the button. The Btn_PC property class includes the item type Push Button. You accidentally change the Item Type property of the Exit Button to Check Box. How can you change the Item Type of the Exit button back to Push Button, restore the subclassed relationship of the Item Type to the property class, and retain any other property changes that you have made?

  A. Select the Item Type property of the Exit button and click Inherit.
  B. Change the Item Type property of the Exit button back to Push Button.
  C. Select the Item Type property of the Exit button and click Property Class.
  D. Set the Subclass Information property of the Exit button to Null, then set it to Btn_PC.
  E. Set the Item Type property in the Btn_PC property class to Check Box, then change it back to Push Button.
  A. Select the Item Type property of the Exit button and click Inherit.

• Question 29:

  Which two statements about a Non-Query Record Group are true? (Choose two.)

  A. The Record Group is associated with a query at run time or at design time.
  B. The Record Group can be created and modified 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. You can modify the structure of this Record Group by adding columns and rows.
  F. The Record Group is associated with a query only at design time.
  B. The Record Group can be created and modified only at run time.
  E. You can modify the structure of this Record Group by adding columns and rows.

• Question 30:

  The validation unit for the Orders form is set to Item. This master-detail form contains an Orders block and a multirecord Order Items block. Why might you want to create a When-Validate-Record trigger on the Orders block in this form?

  A. to check that all items in the Orders block whose Required property is set to Yes have values
  B. to check that all items in the Order Items block whose Required property is set to Yes have values
  C. to check that the shipping date for the order is not earlier than the order date
  D. to perform some logic every time a user navigates to a different record in the queried block
  C. to check that the shipping date for the order is not earlier than the order date