Oracle 1Z0-141 Online Practice Questions and Exam Preparation

Oracle 1Z0-141 Online Questions & Answers

• Question 61:

  You are building the Customer.fmb module, and you define a multirecord data block based on the CUSTOMERS table. The data block is called CUST.

  You specify a Tabular layout style for the CUST items. When the window is at its maximum size, only some of the items can be viewed in the window. To view all items together, you should enable users to scroll horizontally through the CUST

  items; however, the Cust_ID and Cust_Name items should always be visible.

  Which combination of canvas types is most appropriate to display the CUST items together?

  A. Content canvas and an overlay Tab canvas
  B. Tab canvas and an overlay stacked canvas
  C. Vertical Toolbar canvas and a Tab canvas
  D. Content canvas and an overlay stacked canvas
  E. Horizontal Toolbar canvas and a content canvas
  D. Content canvas and an overlay stacked canvas

• Question 62:

  LibraryA and LibraryB are in the working directory of the Employees form. Library A is attached to the Employees form. There is a stored procedure in the database called Raise_Salary which must be called without any parameters. There is no Raise_Salary procedure in the form or in the attached library.

  A When-Button-Pressed trigger in the Employees form contains this code:

  raise_salary;

  Where does Forms search for the Raise_Salary procedure?

  A. first in the attached library, then in the database
  B. first in the form module, then in the attached library
  C. first in the form module, then in the attached library, then in the database
  D. first in the form module, then in the attached library, then in other libraries in the working directory, then in the database
  E. in the form module only
  F. in the attached library only
  G. in the database only
  C. first in the form module, then in the attached library, then in the database

• Question 63:

  The following On-Error trigger was written to give users a more meaningful message when they press the Up key when the cursor is in the first record (the FRM-40100 error) and to display default messages for all other errors:

  IF message_code = 40100 THEN

  MESSAGE('You are already at the first record');

  ELSE

  MESSAGE(message_type || '-' ||

  to_char(message_code) || ': ' || message_text);

  END IF;

  When you test the form, you still get the FRM-40100 message when you press the Up key while the cursor is in the first record. Your custom message does not appear.

  What corrections can you make so that the code functions properly?

  A. Change all occurrences of message_code, message_type, and message_text to error_code, error_type, and error_text.
  B. Eliminate the to_char function because message_code is a varchar2 value.
  C. To keep the remaining code from executing, add after the second line:RAISE FORM_TRIGGER_FAILURE;
  D. Change all occurrences of message_code, message_type, and message_text to DBMS_error_code, DBMS_error_type, and DBMS_error_text.
  A. Change all occurrences of message_code, message_type, and message_text to error_code, error_type, and error_text.

• Question 64:

  View the Exhibit.

  The EMPLOYEES table contains 100 records. You are developing a Human Resources form that has an Employees block with properties as shown in the exhibit. When you run the form and execute a query in the Employees block, approximately how many network round trips will be made to the server before records are displayed in the block?

  

  A. 1
  B. 2
  C. 10
  D. 50
  E. 100
  C. 10

• Question 65:

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

  View the Exhibit.

  The Name text item is subclassed from a property class.

  Which two statements are true about the Keyboard Navigable property of the Name text item whose Property Palette is shown in the exhibit? (Choose two.)

  

  A. It is a variant property.
  B. It is a default property.
  C. It is a changed property.
  D. It is an inherited property.
  E. It was inherited from the property class. If the value of Keyboard Navigable changes in the property class, it will change in the Name item also.
  F. It was inherited from the property class and has been changed from the value in the property class.
  G. It was not inherited from the property class and has been modified from the default Keyboard Navigable value for a text item.
  H. It was not inherited from the property class and is the default Keyboard Navigable value for a text item.
  A. It is a variant property.
  F. It was inherited from the property class and has been changed from the value in the property class.

• Question 67:

  In a multiform application, one form must invoke another. The form modules are called Customers and Orders internally, but the compiled files are saved as CUST.FMX and ORD.FMX, respectively.

  There is a button in the Customers form with a When-Button-Pressed trigger to invoke the Orders form.

  There is a requirement that only one Orders form can be running at a time, so the trigger must check to see if the form is already open. If it is open, the focus must be sent to it. If it is not open, it has to be opened.

  Which of these trigger codes will achieve the required functionality?

  A. IF NOT FIND_FORM('ord') THENOPEN_FORM('ord');ELSEGO_FORM('orders');END IF;
  B. IF ID_NULL(FIND_FORM('ord')) THENOPEN_FORM('orders');ELSEGO_FORM('ord');END IF;
  C. IF ID_NULL(FIND_FORM('orders')) THENOPEN_FORM('ord');ELSEGO_FORM('orders');END IF;
  D. IF NOT FIND_FORM('orders')) THENOPEN_FORM('orders');ELSEGO_FORM('ord');END IF;
  C. IF ID_NULL(FIND_FORM('orders')) THENOPEN_FORM('ord');ELSEGO_FORM('orders');END IF;

• Question 68:

  You want users to be able to add values to a list item at run time. How do you achieve this?

  A. Set the List Style property to combo box.From the When-List-Activated trigger, call the Add_List_Element built-in.
  B. Set the List Style property to Tlist.From the When-List-Activated trigger, call the Populate_List built-in.
  C. Set the List Style property to poplist.From the When-List-Activated trigger, call the Add_List_Element built-in.
  D. Set the List Style property to combo box.From the When-List_Changed trigger, call the Add_List_Element built-in.
  E. Set the List Style property to Tlist.From the When-Validate-Item trigger, call the Populate_List built-in.
  F. Set the List Style property to poplist.From the When-Validate-Item trigger, call the Add_List_Element built-in.
  D. Set the List Style property to combo box.From the When-List_Changed trigger, call the Add_List_Element built-in.

• Question 69:

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

  Which statement is true about client-side validation?

  A. It requires a network round trip.
  B. It does not require any middle-tier configuration.
  C. It requires setting an item's Implementation Class property.
  D. It is implemented with the When-Validate-Item and When-Validate-Record triggers.
  C. It requires setting an item's Implementation Class property.